NHibernate with http tunneling

NHibernate with http tunneling

Postby florian.kammermann » Mon 02 Jul 2012 19:41

I try to use dotConnect with the http tunneling for a MySQL Connection.
Anyone an idea how to do it?

How can I configure NHibernate, that dotConnect will be used with the right parameters?
florian.kammermann
 
Posts: 2
Joined: Mon 02 Jul 2012 19:35

Re: NHibernate with http tunneling

Postby florian.kammermann » Tue 03 Jul 2012 08:36

Ok, I implemted the driver like it is documented here:
http://engineeringblog.nsphere.net/post/19396958733/nhibernate-mysql-via-dotconnect

Then I chanaged the parameter in the hibernate config:
<property name="connection.driver_class">NHibernate.Driver.DevartMySQLDriver</property>

Now I get a stackoverflow at this point in the Hibernate Code:
SchemaUpdate.cs, line 163
stmt = connection.CreateCommand();

Version of NHibernate is: 3.1.0
florian.kammermann
 
Posts: 2
Joined: Mon 02 Jul 2012 19:35

Re: NHibernate with http tunneling

Postby Shalex » Wed 04 Jul 2012 14:18

florian.kammermann wrote:I try to use dotConnect with the http tunneling for a MySQL Connection.
How can I configure NHibernate, that dotConnect will be used with the right parameters?

Please set the corresponding connection string parameters for using HTTP tunneling via dotConnect for MySQL: http://www.devart.com/dotconnect/mysql/docs/Tunneling.html#tunnel. This is a provider's level, so no NHibernate settings are needed for HTTP tunneling.

florian.kammermann wrote:I get a stackoverflow at this point in the Hibernate Code:
SchemaUpdate.cs, line 163
stmt = connection.CreateCommand();

Please send us the following information:
1) the call stack exact and full text of the error
2) the full version (x.x.xx) of dotConnect for MySQL you are using
3) a small test project with the corresponding DDL/DML script to reproduce the issue in our environment
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44

Re: NHibernate with http tunneling

Postby BobOakes » Sun 24 Jan 2016 19:11

Was there ever a solution to the stack overflow problem mentioned here? I am evaluating the software and am hitting a similar problem where I get a stack overflow when trying to save an entity via nHibernate.

The stack trace looks as follows:

at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.CreateCommand () <0x00022>
at Devart.Data.MySql.NHibernate.NHibernateMySqlConnection.a () <0x0000f>
at Devart.Data.MySql.MySqlConnection.System.Data.IDbConnection.CreateCommand () <0x00013>
at NHibernate.Id.TableGenerator.DoWorkInCurrentTransaction (NHibernate.Engine.ISessionImplementor,System.Data.IDbConnection,System.Data.IDbTransaction) <0x00079>
at NHibernate.Engine.TransactionHelper/Work.DoWork (System.Data.IDbConnection,System.Data.IDbTransaction) <0x00040>
at NHibernate.Transaction.AdoNetTransactionFactory.ExecuteWorkInIsolation (NHibernate.Engine.ISessionImplementor,NHibernate.Engine.Transaction.IIsolatedWork,bool) <0x0016f>
at NHibernate.Transaction.AdoNetWithDistributedTransactionFactory.ExecuteWorkInIsolation (NHibernate.Engine.ISessionImplementor,NHibernate.Engine.Transaction.IIsolatedWork,bool) <0x0006b>
at NHibernate.Engine.Transaction.Isolater.DoIsolatedWork (NHibernate.Engine.Transaction.IIsolatedWork,NHibernate.Engine.ISessionImplementor) <0x00049>
at NHibernate.Engine.TransactionHelper.DoWorkInNewTransaction (NHibernate.Engine.ISessionImplementor) <0x0004f>
at NHibernate.Id.TableGenerator.Generate (NHibernate.Engine.ISessionImplementor,object) <0x00015>
at (wrapper synchronized) NHibernate.Id.TableGenerator.Generate (NHibernate.Engine.ISessionImplementor,object) <0xffffffff>
at NHibernate.Id.TableHiLoGenerator.Generate (NHibernate.Engine.ISessionImplementor,object) <0x000b3>
at (wrapper synchronized) NHibernate.Id.TableHiLoGenerator.Generate (NHibernate.Engine.ISessionImplementor,object) <0xffffffff>
at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId (object,string,object,NHibernate.Event.IEventSource,bool) <0x0006a>
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId (NHibernate.Event.SaveOrUpdateEvent) <0x0004b>
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient (NHibernate.Event.SaveOrUpdateEvent) <0x000de>
at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate (NHibernate.Event.SaveOrUpdateEvent) <0x0007f>
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate (NHibernate.Event.SaveOrUpdateEvent) <0x00233>
at NHibernate.Impl.SessionImpl.FireSave (NHibernate.Event.SaveOrUpdateEvent) <0x000b6>
at NHibernate.Impl.SessionImpl.Save (object) <0x0008f>

Versions of the DLLs are as follows:
Devart.Data.MySql: 8.4.583
Devart.Data: 5.0.1375

I am seeing this with both NHibernate version 4.0 and 3.3 GA

Thanks.
Bob
BobOakes
 
Posts: 3
Joined: Sun 24 Jan 2016 19:04

Re: NHibernate with http tunneling

Postby Shalex » Mon 25 Jan 2016 10:07

Please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44

Re: NHibernate with http tunneling

Postby BobOakes » Mon 25 Jan 2016 14:04

Thanks for the quick response. I am isolating the problem into a small project right now. I will send it to you as soon as its complete.
BobOakes
 
Posts: 3
Joined: Sun 24 Jan 2016 19:04

Re: NHibernate with http tunneling

Postby BobOakes » Tue 26 Jan 2016 21:50

Hi, I just wanted to check if the program I posted yesterday was received.

Thanks.
BobOakes
 
Posts: 3
Joined: Sun 24 Jan 2016 19:04

Re: NHibernate with http tunneling

Postby Shalex » Wed 27 Jan 2016 18:25

Thank you for the test project. We have reproduced System.StackOverflowException and are investigating the issue. We will notify you about the result.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44

Re: NHibernate with http tunneling

Postby Shalex » Fri 29 Jan 2016 16:57

The bug is fixed. We will notify you when the corresponding build of dotConnect for MySQL is available for download.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44

Re: NHibernate with http tunneling

Postby Shalex » Thu 11 Feb 2016 16:00

The new build of dotConnect for MySQL 8.4.592 is available for download: http://forums.devart.com/viewtopic.php?f=2&t=33200.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL