Configure an Oracle 9i data source

[mikedamazon]

I am having a problem getting my Oracle 9i data source working on JBOSS 4.0.

Have I missed any steps?

I have downloaded the ojdb14.jar file from the oracle distribution and placed it under $JBOSS_HOME/server/all/lib.

I created the following data source description file and put it in the $JBOSS_HOME/server/all/deploy directory:

<?xml version="1.0" encoding="UTF-8"?>

<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:oci:@mydb</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>user</user-name>
password
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

<type-mapping>Oracle9i</type-mapping>

</local-tx-datasource>



When I start JBOSS I get the following errors:
org.jboss.deployment.DeploymentInfo@2a6ac7 { url=file:/workplace2/apps/jboss-4.0.1RC2/server/all/deploy/my_oracle_ds.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/workplace2/apps/jboss-4.0.1RC2/server/all/deploy/my_oracle_ds.xml
altDD: null
lastDeployed: 1107566974193
lastModified: 1107566974000
mbeans:

Incompletely deployed packages:
org.jboss.deployment.DeploymentInfo@2a6ac7 { url=file:/workplace2/apps/jboss-4.0.1RC2/server/all/deploy/my_oracle_ds.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/workplace2/apps/jboss-4.0.1RC2/server/all/deploy/my_oracle_ds.xml
altDD: null
lastDeployed: 1107566974193
lastModified: 1107566974000
mbeans:


Any suggestions would be greatly appreciated.

[david.salter]

From the trace it looks like you have called your deployment file "my_oracle_ds.xml". Data sources have to end with "-ds.xml", so if you rename your file "my_oracle-ds.xml", it will probably deploy fine.