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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
