Re: Is an explicit connect required when using XA?

Hi David,
Thanks for the reply!! dint see it got posted twice :D

i have already checked the link you gave.. the xa_start() is working fine and returning success... but the problem is the EXEC SQL calls that i am making after the tx_begin()....they return the sqlca.sqlcode value -01012

is there some command line xaoSvcCtx() that we need to give in the application to get the context and then execute SQLs in the database? or is it called implicitly?

I have another question.... is the Oracle precompiler Pro*C for Oracle 8.0.6 compatible with XA? Because i had seen somewhere that an application using Pro*c calls with XA to manage transactions does not work and it is compatible starting with Oracle 9i only!!!!!! Is that true??

Appreciate the reply ...
thanks,
Bhanu

fitzjarrell_at_cox.net wrote:
> On Mar 1, 10:43 am, bhan..._at_gmail.com wrote:
> > Hi!
> >
> > Is an explicit connect command or an explicit command to change
> > database required when using XA to connect to Oracle using
> > TPM(transsaction process monitoring)?
> >
> > My XA trace shows that xa_open was successful but none of my fetch/
> > update commands work!
> > the error i get is ORA-01012 - not connected.
> >
> > i am connecting from Oracle client 8.0.6 to Oracle server
> > 8.1.7 ....are there any known issues??
> >
> > Thanks!
>
> Possibly this link will help you:
>
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adga1_xa.htm
>
> Your xa_open command only connects to the resource manager; you'll
> need an xa_start() call to actually begin a transaction.
>
> Plaase do not post the same question twice as it won't get you any
> faster response and may get you ignored.
>
>
>
> David Fitzjarrell
Received on Fri Mar 02 2007 - 02:23:10 CST