1 Reply Latest reply on Feb 6, 2005 1:47 PM by David Salter

    Configure an Oracle 9i data source

    Mike David Newbie

      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.