Hi,
Please anyone giveme your inputs on this. I am using below Oracle-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>MyDS</jndi-name>
<connection-url>
jdbcracle:thin:@<HostName>:<POrt_NUM>:<SID></connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>user</user-name>
<password>pwd</password>
<!--<security-domain>mydbDBSecurity</security-domain>-->
<!--connection-property name="relaxAutoCommit">yes</connection-property-->
<!--<connection-property name="autoCommit">false</connection-property> -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>-->
<!--new-connection-sql>set autocommit=0;</new-connection-sql-->
<!--<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>-->
<track-statements>true</track-statements>
<metadata>
<type-mapping>Oracle11G</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>