Re: distributed transactions with more than one application

From: Chuck <chuckh_nospam_at_softhome.net>
Date: 23 Mar 2004 18:33:33 GMT
Message-ID: <Xns94B589F0ABC53chuckhsofthomenet@130.133.1.4>

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?

-- 
Chuck
Remove "_nospam" to reply by email

Received on Tue Mar 23 2004 - 12:33:33 CST