Oracle XA Datasource Problem
tamtam Jun 18, 2003 7:44 AMhi all
as always! problems with oracle and xa... ;-(
i'm porting our erp-solution from jboss 2.4.4 to jboss 3.2.x i configured the oracle xa-datasource (using the oracle-xa-ds.xml example). i spent a lot of time but it doesn't work. (with jboss 2.4.4 there is no problem)
oracle db-server version: oracle 8i
jboss-version: 3.2.2rc1 (also tested with 3.2.1)
jdbc-driver: 9.2.0.1 (also tested with the newest driver from oracle 9.2.0.3)
oracle-xa-ds.xml:
<xa-datasource>
<jndi-name>BisonDataSource</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:@bisdevdb:1521: prod</xa-datasource-property>
<xa-datasource-property name="User">theUsername</xa-datasource-property>
<xa-datasource-property name="Password">thePassword</xa-datasource-property>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</xa-datasource>
deploying is ok - no errors.
first access to the database:
12:40:08,366 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl [Fo
rmatId=257, GlobalId=Bisonws1031//33, BranchQual=] errorCode=XAER_RMERR
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157
)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:29
5)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManage
dConnection.java:133)
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1137)
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:624)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnection
EventListener.enlist(TxConnectionManager.java:460)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConne
ctionReconnected(TxConnectionManager.java:358)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:491)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:799)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
erDataSource.java:102)
at CH.obj.Libraries.Session.EJBMasterSessionContext.allocateConnection(E
.
.
.
12:40:09,277 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not enlist
in transaction on entering meta-aware object!javax.transaction.SystemException:
enlistResource failed; - nested throwable: (javax.resource.ResourceException: Co
uld not enlist in transaction on entering meta-aware object!javax.transaction.Sy
stemException: enlistResource failed)
12:40:09,287 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSo
urce.getConnection(WrapperDataSource.java:106)
12:40:09,287 ERROR [STDERR] at CH.obj.Libraries.Session.EJBMasterSessionCont
ext.allocateConnection(EJBMasterSessionContext.java:108)
.
.
.
hope anyone has an idea!
thanks
martin