Oracle XA Datasource Problem

[tamtam]

hi 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

[sashahunt]

Hi,
I'm probably not much help,as I'm also having problems with Oracle xa (jboss-3.0.7_jakarta-tomcat-4.1.24), but I thought you couldn't use the thin driver
for transactions - that instead you needed the oci driver.