View Single Post
  #1 (permalink)  
Old September 24th, 2003, 09:09 AM
keseln keseln is offline
Registered User
 
Join Date: Jun 2003
Location: Hannover, Low Sachsony, Germany.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote