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

Home -> Community -> Usenet -> c.d.o.server -> Help! Multithreaded app needs to access Oracle

Help! Multithreaded app needs to access Oracle

From: Matthew K. Smith <matsmi_at_acxiom.com>
Date: 1996/12/19
Message-ID: <01bbedf3$4a668850$b71f6e87@matsmi1>#1/1

I'm having a problem accessing our Oracle 7 database from two different threads within a C++ application. What happens is that each thread tries to
access the database at the same time and the app crashes, giving me the following message:

        ORA-03106: fatal two-task communication protocol error

To my knowledge, Oracle will not allow a single process to have multiple connections to it, so I know that is not the solution.

It was also suggested that I use PL/SQL scripts that reside on the database instead of embedded SQL in my app. Unfortunately that will not work either because the tables being accessed by my app are constantly changing, and PL/SQL scripts would have to be re-written all the time.

For the time being, I have defined a mutex lock that will not allow the two threads to access the database at the same time, but this does not allow the app to achieve the speed that we need. If any of you have encountered similar problems, or know of a solution, I would appreciate your suggestions.

Thanks!

-- 
Matthew K. Smith
Acxiom Corporation
matsmi_at_acxiom.com
501-336-2434
Received on Thu Dec 19 1996 - 00:00:00 CST

Original text of this message

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