How to configure XA-DataSource for Oracle in JBoss
Hallo everybody,
I'm using JBoss 3.2.1 with intergrated Tomcat.
Does anybody know how to configure XA-DataSource for Oracle 8.1.6. I've made till now following steps:
I've copied file oracle-xa-ds.xml from example directory to default/deploy directory. Here is this file:
<datasources>
<xa-datasource>
<jndi-name>jdbc/estat</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<managedconnectionfactory-class>
org.jboss.resource.adapter.jdbc.xa.oracle.XAOracle ManagedConnectionFactory
</managedconnectionfactory-class>
<transaction-isolation></transaction-isolation>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:@serv2b:1521:dastat</xa-datasource-property>
<xa-datasource-property name="User">bmftprod</xa-datasource-property>
<xa-datasource-property name="Password">hisdast</xa-datasource-property>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.Oracle ExceptionSorter</exception-sorter-class-name>
</xa-datasource>
<mbean code="org.jboss.resource.adapter.jdbc.xa.oracle.Or acleXAExceptionFormatter"
name="jboss.jca:service=OracleXAExceptionFormatter ">
<depends optional-attribute-name="TransactionManagerService">jboss:service=Tra nsactionManager</depends>
</mbean>
</datasources>
I've set pad on true in file transaction-service.xml. But when getting connection from datasource I always get exception like:
Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: enlistResource failed
Does anybody know what else should be done? I would be very appreciated for any help.
Greetings,
Nadja
|