Re: thread safe sqlca-value

From: Frank Gerlach <Frank.Gerlach_at_brokat.de>
Date: 1999/10/30
Message-ID: <381B24A1.36E11C66_at_brokat.de>#1/1


I forgot:
Opinions are mine and do not necessarily reflect those of Brokat Infosystems AG !

Frank Gerlach wrote:

> 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

Original text of this message