Subject Re: [ib-support] Threads and Transactions in Embedded SQL Applications
Author Ann W. Harrison
At 09:59 AM 3/7/2002 +0000, pgtoni wrote:

>I have developed a library in C++ (enviroment RH linux 7.1 gcc-2.96)
>with embedded SQL (gpre).
>
>Now some errors a occuring which I am not understanding.
>
>When I have 2 clients each using some named transaction, are this
>transactions handle different on the server, or is the server
>assuming it is the same named transaction?

The server never sees the names - they're translated into handles.
If, however, several threads use the same names, they may be
referencing the same handles, which will cause problems.


>Does somebody have some tips or links where I can get some info about
>gpre, threads, transactions in Embedded SQL applications etc

Gpre predates threads in general - it's the oldest part of the product,
older even than the engine. I suggest that you look at the output
of gpre, looking particularly at the attach, start_transaction, and
compile_request calls and the handles they use. Be sure those handles
are thread-specific and things should work.... Famous last words...


Regards,

Ann
www.ibphoenix.com
We have answers.