Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Controlling multiple database connections as one transaction.
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 - 02:24:10 CDT