[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - OCI8 configuration
rizkaarifianto
do-not-reply at jboss.com
Mon Feb 12 22:01:23 EST 2007
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
More information about the jboss-user
mailing list