Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> TxSeries/Encina XA Multi Threading Issue with 8.0.5..
Our data server is an Encina server that talks to ORACLE using XA. It contains only one non-transactional RPC which starts a transaction, does ORACLE operation, and commits the transaction. This operation uses Pro*C Method 4 (pure dynamic SQL) to perform all database related operations. The Resource Manager in Encina is registered with "Threads=true" in Open String and "Multiple Association" for Thread Agreement.
The problem appears when this one RPC is executed under heavy load. The cursor I open during the data operation seems to be getting shared by multiple calls - I am getting errors like ORA-02117/ORA-02114 etc..
I am compiling my Pro*C code with options "RELEASE_CURSOR=YES MODE=ANSI". My code looks like
: :
I tried to use THREADS=YES and changed the code as follows. It still doesn't work.
EXEC SQL BEGIN DECLARE;
sql_context ctx;
EXEC SQL END DECLARE;
EXEC SQL ENABLE THREADS;
EXEC SQL CONTEXT ALLOCTE :ctx;
EXEC SQL CONTEXT USE :ctx;
EXEC SQL INCLUDE SQLCA; : :
How do I solve this problem? I would appreciate your responses.
Thanks
-Sudhir
kolli_s_at_hotmail.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 07 2000 - 09:04:23 CST