Oracle distributed transaction

[Guest]

I'm using the System.Data.OracleClient namaspace and I get he following
problem.

In the main thread I open a connection to the database, I query the DB
retrieving all the available stored procedure, allowing the user through a
GUI to pick a stored procedure a execute it in parallele in different thread.
Every thread open a new connection to the DB !

But if the stored procedure issue a rollback statement I get an error from
oracle:
i can't rollback in a distributed transaction !

But I really don't need a distributed transaction !
I would that any thread session had its ownn transaction !

Any suggestion ?

 

[Guest]

I read from MSDN Libray:

Transaction Support
Connections are drawn from the pool and assigned based on transaction
context. The context of the requesting thread and the assigned connection
must match. Therefore, each connection pool is actually subdivided into
connections with no transaction context associated with them, and into N
subdivisions that each contain connections with a particular transaction
context.

When a connection is closed, it is released back into the pool and into the
appropriate subdivision based on its transaction context. Therefore, you can
close the connection without generating an error, even though a distributed
transaction is still pending. This allows you to commit or abort the
distributed transaction at a later time.

I try to disable the pool and the enlist attribute of the connection string
but I still get the same error !

 

[Angel Saenz-Badillos[MS]]

Cosimo,
Sorry, you are running into a known Oracle bug, take a look at the following
thread for more information: http://tinyurl.com/483k5


--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/