Multithreaded application hangs after upgrade to Oracle 10.2
402647Jun 7 2006 — edited Feb 12 2007Hi all,
I am having problems with a multithreaded OCI application that hangs after upgrading OCI and Oracle client to 10.2, using the 9.2 OCI & client it works fine.
The application has its own internal connection pool (i.e. NOT an oracle pool, those features were not available when the application was built a long time ago). The pool is handled by a singleton that (somewhat simplified) issues triplets of environment,connection,session handles to worker threads that need DB access. Only one thread uses those handles at a time. OCI_THREADED and OCI_OBJECT is being used.
After upgrading to (and compiling with) Oracle 10.2, the application hangs after a while at OCIStmtPrepare2. It seems that it is always the first OCIStmtPrepare2 that is executed by another thread than the thread that originally created those particular environment/connection/session handles and put them into the pool.
I have read that using one common environment handle for all connections should be ok (with OCI_THREADED) and tried that, but it did not change the behavior.
Has anyone encountered similar problems after upgrading to 10.2?
Any help would be greatly appreciated!