JBoss Server Configuration - Datasource config for Oracle (oracle-ds.xml)

The 'oracle-ds.xml' file is the config file for your database. It should be located in the JBoss deploy directory for your application.

A sample 'oracle-ds.xml' for normal case.

<datasources>
    <local-tx-datasource>
        <jndi-name>NAME_OF_JNDI</jndi-name>
        <connection-url>jdbc:oracle:thin:@localhost:1521:SID</connection-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <user-name>user</user-name>
        <password>password</password>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
        </exception-sorter-class-name>
        <metadata>
            <type-mapping>Oracle9i</type-mapping>
        </metadata>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
        </exception-sorter-class-name>
        <min-pool-size>2</min-pool-size>
        <max-pool-size>5</max-pool-size>
        <blocking-timeout-millis>5000</blocking-timeout-millis>
        <track-statements>true</track-statements>
    </local-tx-datasource>
</datasources>

Reference: Configuring JDBC DataSources