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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...