Porting J2EE application from weblogic to Jboss, JTS? (weblogic.jdbc.jts.Driver)

Question

My weblogic(8.1) application uses weblogic.jdbc.jts.Driver to connect to Oracle.

I'd like to port this app to JBOSS(4.0) and quick googling did not yield the correct driver to replace this JDBC JTS driver with in order to connect from Jboss, ideas?

Answer 1

Why use WebLogic's wrapper driver in a non-WebLogic application server?

As it is written here, I presume you needed it in WebLogic in order for the Oracle driver to participate in XA (two-phase commit) transactions, if that's so I would suggest that you use the native XA DataSource that oracle provides (oracle.jdbc.xa.client.OracleXADataSource) and fetch the datasource from the JNDI, along with JBoss's own transaction manager.

Here is one sample and a more elaborate one, of the datasource configuration. And the link to the JBoss transaction manager documentation.