[jboss-user] [JCA/JBoss] - Not getting XADataSource

[pkdj]

I'm using JBoss 4.0.5.GA with Oracle 10g. I created a datasource definition in server/default/deploy/oracle-xa-ds.xml as follows:

  | <datasources>
  |    <xa-datasource>
  |       <jndi-name>BasicService01DS</jndi-name>
  |       <track-connection-by-tx>true</track-connection-by-tx>
  |       <no-tx-separate-pools>true</no-tx-separate-pools>
  |       <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:@weezer:1521:demo1
  |       </xa-datasource-property>
  |       <xa-datasource-property name="User">bs01</xa-datasource-property>
  |       <xa-datasource-property name="Password">bs01</xa-datasource-property>
  |       <exception-sorter-class-name>
  |          org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
  |       </exception-sorter-class-name>
  |    </xa-datasource>
  | 
  |   <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter" 
  |          name="jboss.jca:service=OracleXAExceptionFormatter">
  |     <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
  |   </mbean>
  | </datasources>

When I look at it in the JXM console, it shows 

  +- BasicService01DS (class: javax.sql.DataSource)
  | 

When I try to get a transactional connection using JBoss Transactions' TransactionalDriver

Connection conn = arjunaJDBC2Driver.connect("jdbc:arjuna:java:BasicService01DS", new Properties());

it throws a ClassCastException

14:20:27,308 ERROR [STDERR] java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource

For some reason the datasource definition above is not realizing an XA datasource. Does this indicate that the Oracle database is not configured to support XA (I'm checking into this now) or is it some other configuration I've neglected to perform in JBoss?

Thanks,
Paul


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3990543#3990543

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3990543