Here is the oracle-ds.xml content
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: oracle-ds.xml 71535 2008-04-01 07:05:03Z
adrian@jboss.org $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>OracleDSNew</jndi-name>
<connection-url>
jdbcracle:thin:@10.199.212.222:1521:ora</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>jboss</user-name>
<password>password</password>
<!-- <security-domain>MyOracleDbRealm</security-domain> -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>