JBoss Deployment: Windows XP and Oracle

For all deployments Java 1.5.0_15 or newer should be used

A xml file with the following contents will need to be create and named oracle-ds.xml:

<?xml version="1.0" encoding="UTF-8"?> 
<datasources> 
 <local-tx-datasource> 
 <jndi-name>jdbc/ExpereDoc</jndi-name> 
 <connection-url>jdbc:oracle:thin:@MACHINE_NAME:1521:DATABASE_NAME:SID 
 </connection-url> 
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 
 <user-name>SCHEMA_USERNAME</user-name> 
 <password>SCHEMA_PASSWORD</password> 
 <exception-sorter-class-
 name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-
 sorter-class-name> 
 </local-tx-datasource> 
</datasources>

MACHINE_NAME will be substituted by the machine name on which the database is installed.
DATABASE_NAME will be substituted by the name of the Oracle server database.
SID will be substituted by the SID for the Oracle server database.
SCHEMA_USERNAME will be substituted by the database schema user name.
SCHEMA_PASSWORD will be substituted by the database schema user password.

For more information, see the following: