[JBoss-user] Oracle XA Datasource problems

[Andrew May]

Hi, I'm trying to use an XA datasource with Oracle 8.1.7 for the first time and I'm 
getting this error:

14:56:23,707 WARN  [TransactionImpl] XAException: tx=TransactionImpl:XidImpl 
[FormatId=257, GlobalId=cleaver.ingenta.com//3, BranchQual=] errorCode=XAER_NOTA
oracle.jdbc.xa.OracleXAException
        at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:659)
        at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:301)
        at 
org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:146)
        at org.jboss.tm.TransactionImpl.endResource(TransactionImpl.java:1194)
        at org.jboss.tm.TransactionImpl.endResources(TransactionImpl.java:1267)
        at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:346)
        at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:367)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:253)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:198)
        at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
        at 
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)
        at org.jboss.ejb.Container.invoke(Container.java:678)

Am I right in thinking that "[FormatId=257, GlobalId=cleaver.ingenta.com//3, BranchQual=]" 
is the transaction identifier? If so, then it seems odd that Oracle would claim there's no 
transaction when it's supposed to be commiting it (The oracle documentation says that 
XAER_NOTA = ORA-24756 transaction does not exist). The application managed to get a 
connection and perform a query - it just fails at the end of the bean method.

I'm using the Oracle thin drivers that came with this version of Oracle.

Anyone had similar problems?

Andrew



-------------------------------------------------------
This SF.net email is sponsored by: ValueWeb: 
Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
No other company gives more support or power for your dedicated server
http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user