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 -> How to use the SAME transaction in a distributed environment

How to use the SAME transaction in a distributed environment

From: <allond_at_fts-soft.com>
Date: 23 Dec 2004 09:38:55 -0800
Message-ID: <1103823535.011913.95160@c13g2000cwb.googlegroups.com>


Hi All,
I'm looking for a possible solution to the following problem:

  1. My application consists of 2 separate processes (lets call them A and B), running on 2 separate machines (using CORBA as middleware)
  2. Both A & B are using the SAME Oracle-DB instance (probably the same schema too - but not necessarily)
  3. The tables are separate (A has its own tables, and so does B)
  4. I want to implement kind of a "distributed" transaction:
  5. A will start a transaction, do it's INSERTs, and then "pass" the transaction to B.
  6. B will do it's INSERTs, on the transaction it got from A
  7. The COMMIT can be done either by A (after B finishes) or by B.

Does Oracle have any solution for this issue? (I'm using Oracle 9i, C++, and OTL)

Thanks, merry Christmas and a VERY happy new year...

Allon.

---
Allon Dafner
Formula Telecom Solutions
Visit our website: http://www.fts-soft.com
Received on Thu Dec 23 2004 - 11:38:55 CST

Original text of this message

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