NHibernate with http tunneling

[florian.kammermann]

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]

Ok, I implemted the driver like it is documented here:
http://engineeringblog.nsphere.net/post ... 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

[Shalex]

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/ ... tml#tunnel. This is a provider's level, so no NHibernate settings are needed for HTTP tunneling.

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

[BobOakes]

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

[Shalex]

Please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.

[BobOakes]

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]

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

Thanks.

[Shalex]

Thank you for the test project. We have reproduced System.StackOverflowException and are investigating the issue. We will notify you about the result.

[Shalex]

The bug is fixed. We will notify you when the corresponding build of dotConnect for MySQL is available for download.

[Shalex]

The new build of dotConnect for MySQL 8.4.592 is available for download: http://forums.devart.com/viewtopic.php?f=2&t=33200.