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>
