How to Create XADatasource in JBoss?

[shmu80]

I need to create XADataSource in JBoss, so that my transaction able to support 2 phases submission.

Below is my code in oracle-ds.xml, but I still meet some problem with the code below:
<local-tx-datasource>
<jndi-name>XAHostOracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@10.10.0.24:1521:testing</connection-url>
<driver-class>org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</driver-class>
<user-name>testing</user-name>
testing
</local-tx-datasource>

May I know anybody can give me some suggestion of this code? May I know anything else should I do in my java code? Is it the code is similar with the non XADatasource lookup?

Thank you.

[silentbob]

Hi,

I think you shall use this:

http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpADB2Datasource

You should use the example in the middle because you want to
create a XADataSource and not a local-tx-datasource as you did.

[weston.price]

No, that is a DB2 XA datasource, not an Oracle XA datasource. Please look at the following:

http://wiki.jboss.org/wiki/Wiki.jsp?page=DSdotXML

Note the line that says that there are example configurations in docs/examples/jca

A quick look at that directory will show you that there is indeed an oracle-xa-ds.xml file that shows you how to set up an Oracle XA Datasource.