Problem using Oracle XA DataSource in WAS 5.1

[phihl]

Hello,

I have got an error when trying to execute a SQL statement on a XA Connection. I'm using Oracle 9i (patch set 9.2.0.5) and WSAD 5.1 (fix pack 3). The error I got is:

SRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -3
The XA Error message is : A resource manager error has occured in the transaction branch.
The Oracle Error code is : 6550
The Oracle Error message is: Internal XA Error
The cause is : null.
[5/8/04 13:29:15:340 ICT] 7ec2b955 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
[5/8/04 13:29:15:434 ICT] 7ec2b955 RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: oracle.jdbc.xa.OracleXAException

I've read somewhere that there are a bug in Oracle 9i related to the XA DataSource (bug 2511780 and 2784688) but I suppose patch set 9.2.0.5 fix these bugs and I also set the custom properties transactionBranchesLooselyCoupled to true.

I've tried to use the Oracle non-XA data source and it's running fine. Does anyone know what was wrong?

Any help will be appreciated. Thank you for reading this mail.

Regards

[Kevin]

From a trusted contact in WebSphere development:

This error message is a generic Oracle message, thus could mean many
things. However, since the problem happened on the xa start, it leads
me to believe that its a setup issue. Things that will help us
identify the problem:
0) check the isolation level that you are using, Oracle XA doesn't
support Serializable isolation level with XA.
1) was this the first xa start of the code, or did this happen after
running for a while?
-- if its the first, was the database created from an old script?
did the user install the jServer? The jServer is checked to be
created by default on 9i releases, but was unchecked in prior
releases.
-- if its not the first error, then odds are, its a setup issue
and i may need to look at the database.

Post by phihl
Hello,
The XA Error is : -3
The XA Error message is : A resource manager error has occured in the transaction branch.
The Oracle Error code is : 6550
The Oracle Error message is: Internal XA Error
The cause is : null.
[5/8/04 13:29:15:340 ICT] 7ec2b955 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
[5/8/04 13:29:15:434 ICT] 7ec2b955 RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: oracle.jdbc.xa.OracleXAException
I've read somewhere that there are a bug in Oracle 9i related to the XA DataSource (bug 2511780 and 2784688) but I suppose patch set 9.2.0.5 fix these bugs and I also set the custom properties transactionBranchesLooselyCoupled to true.
I've tried to use the Oracle non-XA data source and it's running fine. Does anyone know what was wrong?
Any help will be appreciated. Thank you for reading this mail.
Regards

[ctarpy]

I had similar problem - couldnt get the XA oracle datasource to work. Downloaded the lastest driver (ojdbc14.jar) which fixed it.