Re: Duplicate transaction

sfama wrote:
> Hi!
> I have a problem using XA transaction.
> I have two database on the same oracle server.
> If I start two transactions with the same XID, one transaction returns
> an XA and Oracle error (ORA-24757).
>
> The two trasactions are started from two different clients.
> I'd like to know if there is a workaround about this problem, or if
> Oracle is able to understand that the XID is related to two different
> databases also if on the same server.
>
> Then, I read on one google group, that Oracle keeps in memory, for a
> while, the XID of the transaction also if they are ended (committed or
> rolled-back). Is this true? Is there a way to deny this Oracle
> behaviour?
>
> Thank you!
>

Why explicitly state a transaction identifier? Let Oracle handle the transactions for you. It's pretty good at doing that job! Please go through the Oracle Concepts manual (http://tahiti.oracle.com) for your specific version to get a better understanding of how Oracle handles transactions.

Thanks,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown