OrionSupport, Setting up Oracle's native XA driver

Setting up Oracle's native XA driver

Written by Joseph Ottinger

This data-sources block gives you the Oracle connection pool, instead of relying on Orion's innate pooling:


 <data-source

       class="oracle.jdbc.pool.OracleConnectionPoolDataSource

       name="jdbc/pool/OracleConnectionPoolDS"

       location="jdbc/pool/OracleConnectionPoolDS"

       username="abc"

       password="abc"

       url="jdbc:oracle:thin:@your.db.server:1521:test"

/>


This block is what you'd use to get full and complete support for distributed transaction support:

<data-source

       class="oracle.jdbc.xa.client.OracleXADataSource"

       name="jdbc/xa/OracleXADS"

       location="jdbc/xa/OracleXADS"

       username="abc"

       password="abc"

       url="jdbc:oracle:thin:@your.db.server:1521:test"

/>

This code reportedly works around a bug in an old Oracle driver, which means you shouldn't need it for the oracle 10g driver:


 <data-source

       class="com.evermind.sql.OrionCMTDataSource"

       name="jdbc/OracleDS"

       location="jdbc/OracleDS"

       source-location="jdbc/pool/OracleConnectionPoolDS"

       xa-source-location="jdbc/xa/OracleXADS"

       url="jdbc:oracle:thin:@your.db.server:1521:test"

/>