Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: multithreaded in pro*c

Re: multithreaded in pro*c

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 09 Oct 1998 18:42:59 GMT
Message-ID: <362e57e3.101913914@192.86.155.100>


A copy of this was sent to pradeepj_at_delhi.tcs.co.in (if that email address didn't require changing) On Fri, 09 Oct 1998 04:27:44 GMT, you wrote:

>Hi!
>
> We are trying to implement connection pool in C.Here we are creating
>mutliple threads which are trying to connect to Database simultaneously.While
>execution of the program it gives coredump. In the same program if we use
>mutex lock before making connection to Database it works fine!! The SQL
>statement are converted to C statement by Pro*C compiler ( like sqlcxt() ).
>Our Query here is that : Are the different funtions ( like sqlcxt() ) called
>by multiple threads 'THREAD SAFE' or not??
>
>We are using Pro*C/C++ Release 2.2.3.0.0 compiler to compile our
>mutlithreaded Pro*C program.
>We are using oracle 7.3.3 on Digital Unix V 4.0
>

pro*c is thread safe on various platforms but mostly starting with 2.3 and up of pro*c (the pro*c that comes with 7.3).

If your pro*c manual does not have a section "Developing Multi–threaded Applications" in chapter 3 "Developing Pro C/C++ Applications" you probably don't have support for it. (even if you do have those chapters, you need to refer to your OS documentation to see if its supported on that platform)....

If you do have those chapters -- are you using the EXEC SQL CONTEXT and related statements?

>Thanks in advance,
>-Pradeep
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Oct 09 1998 - 13:42:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US