Re: Controlling multiple database connections as one transaction.

From: Drazen Zoric <drazen.zoric_at_vip.hr>
Date: Wed, 19 Sep 2001 09:24:10 +0200
Message-ID: <9o9h5m$7em$1_at_fstgss02.tu-graz.ac.at>


I asked simmilar question but without answer. Same transaction in OCI and ADO connections. How?

"Ben" <ben_at_mercia.com> wrote in message news:BjLp7.35086$a74.159722_at_NewsReader...
> Hi all,
>
> I'm trying to find out what the simplest way is to do the following:
>
> I have a C++ program that makes a call to a Java class (using the Java
> Native Interface). Both of these programs create a database connection
 (one
> using OCI and the other JDBC) to a single Oracle database. Various
 updates
> are made on the database from the two progams and I want to tie the
 updates
> together as a single transaction.
>
> What is is the easiest way to do this? Ideally I'd like to use existing
> Oracle8i services to do it (rather than buy a separate TP Monitor - which
 I
> believe is one way to do this). I've read than TP Monitors are good if
 you
> have more than one resource (database) that you are working with - I only
> have one, so I'm hoping that's going to be easier!
>
> Any solutions or ideas gratefully received!
>
> Best regards,
> Ben Miller
>
>
>
Received on Wed Sep 19 2001 - 09:24:10 CEST

Original text of this message