0 Replies Latest reply on Feb 12, 2007 10:01 PM by Rizka Arifianto

    OCI8 configuration

    Rizka Arifianto Newbie

      Hi,
      I'm using JBOSS 4.0.4GA using CMP and having problem with OCI8 to connect to 2 different database. I have 2 databases with a different version of database (8i and 9i).
      - Installing Oracle 9i Client
      - Setting up the TNS For both databases
      - Setting up datasource (oracle.ds) using OCI
      - Copy file classes12.jar from %ORACLE_HOME%/jdbc/lib to %JBOSS_HOME%/server/default/lib

      When JBOSS is running, connection to database oracle 9i is succesfully established (no error).
      The problem is occured when jboss try to connect to oracle 8i (release 8.1.5).

      Can someone help me to solve the problem?

      Below is the oracle.ds configuration:
      <local-tx-datasource>
      <jndi-name>ORA8DS</jndi-name>
      <connection-url>jdbc:oracle:oci8:@ora8SID</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>ora8user</user-name>
      ora8pass
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

      <type-mapping>Oracle8</type-mapping>

      </local-tx-datasource>
      <local-tx-datasource>
      <jndi-name>ORA9DS</jndi-name>
      <!--connection-url>jdbc:oracle:thin:@kerpec22:1521:pltmar01</connection-url-->
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <connection-url>jdbc:oracle:oci8:@ora9SID</connection-url>
      <user-name>ora9user</user-name>
      ora9pass
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

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

      </local-tx-datasource>