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>
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4015550#4015550
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4015550
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
