problem with Transaction Scope Local
Posted: Sun 23 Oct 2011 19:05
Hey everyone,
we have a server application built against .net 4.0 running on a windows 2008 server, against oracle 11g with 11g client (nor direct mode). We are using the devart EF provider, and during a single request we open a few connections (creating a few contexts). We are using TransactionScope for transaction handling. Our problem started when we got an error from oracle about too many local sessions. We have searched for a solution and saw the Transaction Scope Local property in the connection string. We tried adding it to the connection string and now we get a null reference exception. Does anyone familiar with this?
This is the stack trace (null reference exception):
Devart.Common.DbConnectionInternal.EnlistToDistributedTransactionInternal(Transaction)
System.Data.EntityClient.EntityConnection.EnlistTransaction(Transaction)
System.Data.Objects.ObjectContext.SaveChanges(saveoptions)
MyCode()
Thanks
we have a server application built against .net 4.0 running on a windows 2008 server, against oracle 11g with 11g client (nor direct mode). We are using the devart EF provider, and during a single request we open a few connections (creating a few contexts). We are using TransactionScope for transaction handling. Our problem started when we got an error from oracle about too many local sessions. We have searched for a solution and saw the Transaction Scope Local property in the connection string. We tried adding it to the connection string and now we get a null reference exception. Does anyone familiar with this?
This is the stack trace (null reference exception):
Devart.Common.DbConnectionInternal.EnlistToDistributedTransactionInternal(Transaction)
System.Data.EntityClient.EntityConnection.EnlistTransaction(Transaction)
System.Data.Objects.ObjectContext.SaveChanges(saveoptions)
MyCode()
Thanks