Problem with SQLCA for Error-handling

From: Frank an der Heiden <fh_at_energotec.de>
Date: Fri, 9 Aug 2002 11:09:01 +0100
Message-ID: <aj00dp$mmh$1@news1.transmedia.de>

hi folks,

I habe a problem with the sqlca structure. I have one server process (db_server) which handles the read/write access to my databases.

I have TWO databases. All actions are written in parallel on both databases The first database (on the local pc, where the db_server process is running) is accessed by the main-thread of the db_server. The second database (on another pc, connected via net8 databaselink) is accessed by a parallel thread of the db_server.

As far as i know, it doesn't matter which database i access, all error-messages
are written in one local SQLCA structure. This causes problems, because in the case that both threads (databases) have an error, the different error-messages influence (and for sure the programatical
reaction of the errors) each other.

Does anybody know, if i can define a separate SQLCA structure for each thread
in order to isolate them?

Thanx in advance for any help!

My system:

Two server with W2k SP2, Oracle 8.1.7 SE Database access programmed with PRO C/C++ TCP/IP Network

--
MfG / Best Regards

Frank an der Heiden
Logica CP GmbH
Tel: +49 (0)211 91440-19
Fax:+49 (0)211 669343
email: heidenfad_at_logica.com
"I came, saw and installed everything new!"

Received on Fri Aug 09 2002 - 05:09:01 CDT