Threaded Pro*C in OAS 4.0.7

From: Erik Domstad <d2domer_at_dtek.chalmers.se>
Date: 21 Apr 1999 08:59:16 GMT
Message-ID: <7fk414$o01$1@nyheter.chalmers.se>

Hello,

I am writing a C Web cartridge for OAS 4.0.7. For the database (Oracle 8.0.5) connections, I use Pro*C and a little OCI8 to fetch LOBs. The OS is Solaris 7 on a Sparc Ultra 5.

When I run the application in the console, it seems to be thread safe. I can run 100 thread simultaneously calling the same functions as the cartridge (with the exception of calls to the WRB api that I made stubs for).

When I run it in the OAS, it works fine single threaded but not multithreaded.

I have taken the following actions;

Pre-compiling with the option threads=yes Calling exec sql enable threads in the init cartridge callback Calling OCIInitialize() with OCI_THREADED in the init cartridge callback Declaring sqlca locally in each function

What did I miss? Does anyone have any experience on the subject?

Regards,
Erik Received on Wed Apr 21 1999 - 03:59:16 CDT