Re: thread safe sqlca-value

Our R&D team had a lot of problems with ora 8.x client libs, which do not seem to be threadsafe in every case (especially connect). There is also a silly error message when the session limit of the listener is reached. Seems that even oracle does not have a good QA team :-((

Roland wrote:

> Hi!
>
> I am developing a multi-threaded server (in c) using oracle pro*c to
> access an oracle-db on linux, using oracle 8.0.5.
>
> If i have lots of threads, do I have to mutex the sqlca accesses or not?
> I have 1 session context, but more than 1 accesses to the database, and
> the threads
> are pretty complex (they call lots of functions), so in the end: i do
> not know WHAT action a thread at a given time does perform.
>
> As far as I could figure out, the sqlca datastructure is the only
> dangerous part, is this correct?
>
> Thanks for ur help!
> Roland.
>
> --
> And I heard Jeff exclaim,
> As they strolled out of sight,
> "Merry Christmas to all --
> You take credit cards, right?"
> -- "Outsiders" comic
>
> join my ArchibalD-mailinglist!
> send an empty mail to: archibald-list_at_listbot.com
> -----------------------------------------------------
> Roland Schaffer
>
> e9426992_at_stud4.tuwien.ac.at
> http://www.bitsmart.com/roland_schaffer
> http://stud4.tuwien.ac.at/~e9426992
> ######################################################
Received on Sat Oct 30 1999 - 00:00:00 CEST