Re: distributed transactions with more than one application

From: Richard Maher <maher_rj_at_hotspamnotmail.com>
Date: Fri, 9 Apr 2004 05:54:04 +0000 (UTC)
Message-ID: <c55dpr$g97$1@sparta.btinternet.com>

Hi,

What platform(s) are you using? I believe the Transaction Internet Protocol (TIP) is what you may be looking for. The beauty of TIP's "Two-Pipe" strategy means the Transaction Manager communication Pipe and associated software and network comms are completely seperate and independent of the application middleware. (And unlike most XA monitor implementations, you don' need tuxedo/Encina/ProductX *everywhere*)

The problem is there are not too many TIP implementations out there. (But that's changeing!)

Regards Richard.

Cornelius Kuppler <kuppler_at_ipd.uni-karlsruhe.de> wrote in message news:c4gn3h$c84$1_at_news2.rz.uni-karlsruhe.de...
> Chuck wrote:
> > Cornelius Kuppler <kuppler_at_ipd.uni-karlsruhe.de> wrote in
news:c3ce2a$ldd
> > $1_at_news.rz.uni-karlsruhe.de:
> >
> >
> >>Chuck wrote:
> >>
> >>
> >>>>(How) can I let _two_ applications work on _one_ distributed
> >>>>transaction? Is there any support from Oracle for this purpose?
> >>>>Something like passing over the transaction context?
> >>>>
> >>>>It's obvious that it is possible with an external middleware (like
> >>>>CORBA OTS), but it would be more appropriate for us to do it without.
> >>>>
> >>
> >>>Why would you want 2 applications working on the same distributed
> >>>transaction? You'd need to duplicate all the two phase commit logic
> >>>that's already built in to the RDBMS. Why reinvent the wheel?
> >>
> >>In the end we want two software agents to work on this transaction. And
> >>it is urgent that they work in the same context, so that only if both
> >>agents succeed the whole transaction is commited.
> >>
> >>
> >
> >
> > That's called 2 phase commit. Oracle already has that built in. If both
> > databases are Oracle why not use what's already there?

>
>

> Thank you for your answers.
> The point is that there are not only two databases involved, but also
> two different applications (software agents in our case). They shall be
> commited or rolled backed (according to 2 phase commit) together.
> Example: Bank account transfer: One agent withdrawing 100$; the other
> booking 100$.
> Only if both succeed both transactions can be fixed.
> Now my question is: Is the 2 phase commit implemented in Oracle in any
> way able to cover more than one application at once?
> Received on Fri Apr 09 2004 - 00:54:04 CDT