<!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool --> <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name--> <!-- Checks the Oracle error codes and messages for fatal errors --> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa --> <no-tx-separate-pools/>
<!-- sql to call when connection is created--> <new-connection-sql>select * from er_user</new-connection-sql>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) <metadata> <type-mapping>Oracle9i</type-mapping> </metadata> -->
I'm unclear on what an XA datasource has to do with UserTransaction, but the problem that you've probably run into is that you also need to configure the Xid padding in jboss-service.xml (in the conf directory).
Reid - SCJP2 (April 2002)
Joined: Dec 16, 2003
while using the local transaction datasoure i am getting a exception,
you cannot commit the user transcation. so i changed the datasource to xa datasource.