Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Duplicate transaction
Yes, it could be a good solution,
but if it couldn't be possible for me, is there a way to solve this
problem or to have a workaroud?
Thank you!
Brian Peasland ha scritto:
> 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
Received on Wed Jul 12 2006 - 03:12:42 CDT