Hi,

I have the following situation:

1) Create an OracleConnection (or an IDbConnection)
2) Create an OracleTransaction (or an IDbTransaction)
3) Execute a command in that transaction's context
4) Create an NHibernate ISession using the IDbConnection (ISessionFactory.OpenSession(IDbConnection))
5) Save some entity using NHibernate's Session (ISession.Save(Object))
6) Commit the transaction (IDbTransaction or NHibernate.ITransaction)

This doesn't work! I get an error (in step 5) complaining about a Transaction that's not associated with the Command object.

So, how can i create an IDbTransaction and share that transaction with NHibernate? This must be possible, right?

Regards...

One option is to do the following

1) Create an OracleConnection (or an IDbConnection)
2) Create an NHibernate ISession using the IDbConnection (ISessionFactory.OpenSession(IDbConnection))
3) Create a NHibernate transaction (ISession.BeginTransaction())
4) Create a command in that transaction's context using something like the code snippet below
5) Save some entity using NHibernate's Session (ISession.Save(Object))
6) Commit the transaction (IDbTransaction or NHibernate.ITransaction)



Mike A.

One option is to do the following

1) Create an OracleConnection (or an IDbConnection)
2) Create an NHibernate ISession using the IDbConnection (ISessionFactory.OpenSession(IDbConnection))
3) Create a NHibernate transaction (ISession.BeginTransaction())
4) Create a command in that transaction's context using something like the code snippet below
5) Save some entity using NHibernate's Session (ISession.Save(Object))
6) Commit the transaction (IDbTransaction or NHibernate.ITransaction)



Mike A.

Ok, but that doesn't solve my problem. I simply have an IDbTransaction (that comes from other places) and i want to use that transaction within NHibernate. Isn't this possible?

Perhaps this article helps:
http://www.codeproject.com/csharp/compl ... _trans.asp

No, this is not possible currently. Feel free to file a JIRA issue.

This would be a good enhancement. It would allow me to write an auditor interceptor and have the audit entries commit in the same transaction as the changes being audited.

I have filed a JIRA issue for this (NH-917), since no one seems to have created one yet.

Hey,

I just ran into this with regards to auditing as well. I've basically made my own audit component, but it's conceptional the same as the suggested hibernate auditing method: http://www.hibernate.org/318.html.

At the moment I'm using a separate session to grab the existing db data. But locking on dirty objects that got flushed more than once per transaction was stopping me grabbing the previous state data. Essentially the app was deadlocking. So I've had to change my transaction isolation level from ReadCommitted to ReadUncommitted which I'm not that happy about. I'd rather create a separate session which piggy backed on the same connection and transaction. That way I could set the isolation level to ReadCommitted.