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 Thu Apr 01 2004 - 03:24:00 CST
