We got a problem when using dotConnect with a connection string containing "Enlist=True" within a TransactionScope created like this:
Code: Select all
' VB.NET code
New TransactionScope(TransactionScopeOption.RequiresNew, New TransactionOptions With {.IsolationLevel = IsolationLevel.ReadCommitted})
The stack trace looks like thatORA-00600: internal error code, arguments : [kpotxsking: branch], [0xC000000068672E60], [0xC000000067274BD0], [], [], [], [], []
Does anyone have an idea about this problem?at Devart.Data.Oracle.a0.b(Int32 A_0)
at Devart.Data.Oracle.a5.d(Int32 A_0)
at Devart.Data.Oracle.a5.b(Boolean A_0)
at Devart.Data.Oracle.OracleInternalConnection.Rollback()
at Devart.Common.w.a(Enlistment A_0)
at System.Transactions.VolatileEnlistmentAborting.EnterState(InternalEnlistment enlistment)
at System.Transactions.VolatileEnlistmentActive.InternalAborted(InternalEnlistment enlistment)
at System.Transactions.TransactionStateAborted.EnterState(InternalTransaction tx)
at System.Transactions.TransactionStateActive.Rollback(InternalTransaction tx, Exception e)
at System.Transactions.Transaction.Rollback()
at System.Transactions.TransactionScope.InternalDispose()
at System.Transactions.TransactionScope.Dispose()
We are using the realease "6.10.126 23-Mar-11" of dotConnect.
******** EDIT *******
We've been able to make it work by setting this in the connection string
But, as soon as we try to use our connection after the commit or rollback of a previous TransactionScope, we got the following error ORA-24324.Transaction Scope Local=True
We got the same error even if we try to start another TransactionScope before our database request.
END EDITat Devart.Data.Oracle.a0.b(Int32 A_0)
at Devart.Data.Oracle.a2.d(Int32 A_0)
at Devart.Data.Oracle.a2.a(Int32 A_0, bk A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a(CommandBehavior A_0)
at Devart.Common.Entity.bb.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at HibernatingRhinos.Profiler.Appender.ProfiledDataAccess.ProfiledCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
Thank you very much
Phil