Issues with multi-threading
644790Jun 12 2008 — edited Jul 18 2008I have a highly threaded C# program that needs to process a large number of records. All these records are actually using stored procesures to write the records out. I am using Oracle.DataAccess.Client and Oracle.DataAccess.Types namespaces and am using Oracle.DataAccess.dll version 2.102.2.20.
My program starts multiple threads. In each thread, I create a database conenction, execute stored procedure, commit the transaction and then close the conenction. I am noticing that once I have an error, I start getting the same error on all conenctions in all other threads as well.
Does any one have any ideas. I don't think that Orcale's client library should have issues with multiple threads but it sure looks like rolling back transactions is somehow causing errors. Is therte any shared state among conenctions from different threads at the driver level?
Thanks.
Waqar Sadiq