I would read the specifications of DP to understand why two DP should have so different behavior and then understand where create the issue ticket (at Microsoft or at Oracle).
-- Fabio Maulo El 21/09/2010, a las 21:34, sudip <[email protected]> escribió: > The following code snippet works fine with SQL Server 2008 (SP1) but > with Oracle 11g the call to session.BeginTransaction() throws an > exception with the message ‘Connection is already part of a local or > a distributed transaction’ (stack trace shown below). Using the > '"NHibernate.Driver.OracleDataClientDriver". > > Has anyone else run into this? > > using (var scope = new TransactionScope()) > { > using (var session = sessionFactory.OpenSession()) > using (var transaction = session.BeginTransaction()) > { > // do what you need to do with the session > transaction.Commit(); > } > scope.Complete(); > } > > > Exception at: at > NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel > isolationLevel) > at NHibernate.Transaction.AdoTransaction.Begin() > at NHibernate.AdoNet.ConnectionManager.BeginTransaction() > at NHibernate.Impl.SessionImpl.BeginTransaction() > at > MetraTech.BusinessEntity.DataAccess.Persistence.StandardRepository.SaveInstances(List`1& > dataObjects) in S:\MetraTech\BusinessEntity\DataAccess\Persistence > \StandardRepository.cs:line 3103 > > Inner error message was: Connection is already part of a local or a > distributed transaction > Inner exception at: at > Oracle.DataAccess.Client.OracleConnection.BeginTransaction(IsolationLevel > isolationLevel) > at > Oracle.DataAccess.Client.OracleConnection.BeginDbTransaction(IsolationLevel > isolationLevel) > at > System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() > at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel > isolationLevel) > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
