Oracle OCI, COM+, dblinks and Multi Threaded Server????
From: Royco <bla_at_bla.nl>
Date: Thu, 26 Feb 2004 15:31:01 +0100
Message-ID: <c1l04k$m1g$1_at_azure.qinip.net>
Hi,
Date: Thu, 26 Feb 2004 15:31:01 +0100
Message-ID: <c1l04k$m1g$1_at_azure.qinip.net>
Hi,
Situation as follows
- a C++ component with OCI-calls running under the control of COM (w2k)
- component is marked transactional
- the component connects to database1 but wants to update tables in database2 (through a databaselink).
- Oracle version is 8i on client and server
Initially we received an Oracle error 24777 : Use of non-migratable database link not allowed.
After reading some documentation we decided to configure Multi Threaded Server but now the database-server processen are instable. Doing something like "insert into database2 as select from a table in database1" hangs up the database-processes.
Is there some thinking-error in our solution????? How can I make a 'transactional' com-component doing selects and updates in more then 1 database?
roy Received on Thu Feb 26 2004 - 15:31:01 CET