Hi all
How can I get an Oracle XA-datasource to work in Orion in such a way that it leverages Orion transaction management (CMT)?
Here is my attempted datasources.xml.
<data-source
class="oracle.jdbc.xa.client.OracleXADataSource"
name="DB"
location="jdbc/DBXASource"
url="jdbc:oracle:oci8:vc/vc@ORACLE"
inactivity-timeout="30"
schema="database-schemas/oracle.xml"
/>
<data-source
class="com.evermind.sql.OrionCMTDataSource"
name="DBXA"
location="jdbc/DBXA"
xa-source-location="jdbc/DBXASource"
inactivity-timeout="30"
schema="database-schemas/oracle.xml"
/>
I use an O-R mapping tool, which assumes a JTS CMT DataSource at the JNDI location "jdbc/DBXA". When I throw an EJBException, which according to spec should cause a transaction rollback, the SQL issued through the connection still seems to be committed.