I spent last two days trying to make this work and it looks like there are number of issues with both oracle xa datasource and jboss itself. I am getting close to have this configuration work (it's oracle 8.1.7.3 in my case but this should not make big difference). Problems that I've seen/fixed so far
1. Oracle xa driver returns difference XAResource for each call to XAConnection.getXAResource (see specs jdbc 2.0, section 7.2.2 why it should not). This problem causes "xaRes not enlisted". Fixed XAManagedConnection to cache XAResource, this fix should not break anything else.
2. Although oracle xa driver accepts non-oracle Xid object, it seems to require that both getGlobalTransactionId and getBranchQualifier always return byte[64], otherwise it throws "invalid transaction id" during XAResource.end. Fixed XidImpl to return such arrays, not sure if it will work with all resource managers.
3. Currently I am trying to understand how XAManagedConnection#associateConnection(Object). Currently it unconditionally throws "method not implemented" exception. I would appreciate if anyone can comment on this...
> -----Original Message-----
> From: Geer, Benjamin [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 1:02 PM
> To: '[EMAIL PROTECTED]'
> Cc: Lindsay, Steve; Wink, Stephen
> Subject: [JBoss-user] XATxConnectionManager with Oracle?
>
>
> I'm trying to get XA transactions to work in JBoss 3.0.0 with
> Oracle 9i.
>
> I've tried the oracle-service.xml provided with JBoss in
> docs/examples/jca (which uses LocalTxConnectionManager), and it works
> fine. I modified it to make an oracle-xa-service.xml
> (attached), using
> XATxConnectionManager, and I'm testing it with a little MBean service
> (attached). I can get a DataSource, get a Connection from
> it, and do a
> SELECT, but when my service calls Connection.close(), I get the
> following exception:
>
> java.lang.IllegalArgumentException: xaRes not enlisted
> at org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:546)
>
> (Full stack trace attached.)
>
> Can anyone tell me what I'm doing wrong?
>
> Ben
>
>
