Setting up Oracle with JBoss

Here is an example JBoss Oracle JDBC Datasource configuration file:



<!-- Datasource config for Oracle originally from Steven Coy -->

<datasources>

<local-tx-datasource>

<jndi-name>OracleDS</jndi-name>

<connection-url>jdbc:oracle:thin:@youroraclehost:1521:yoursid</connection-url>

<!-- Here are a couple of the possible OCI configurations. For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm <connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url><br /> or<br /> <connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url><br /><br /> Clearly, its better to have TNS set up properly.<br /> -->

<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

<user-name>x</user-name>

<password>y</password>

<!-- 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>

<!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql><br /> -->

<!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql><br /> -->

</local-tx-datasource>

</datasources>