Unable to connect to Oracle when using oci driver

[vsingh]

Hi,

I am trying to connect to oracle 8.1.6 using oci driver with JBOSS2-4.1. If I use the thin driver I am able to connect to the database. But when I try to use the oci driver, I get the following error message.

DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[Configuration] java.lang.UnsatisfiedLinkError: do_open
[Configuration] at oracle.jdbc.oci8.OCIDBAccess.do_open(Native Method)
[Configuration] at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:309)
[Configuration] at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:198)
[Configuration] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)
[Configuration] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
[Configuration] at java.sql.DriverManager.getConnection(Unknown Source)
[Configuration] at java.sql.DriverManager.getConnection(Unknown Source)
[Configuration] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:118)
[Configuration] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:151)
[Configuration] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnectionFactory.java:267)
[Configuration] at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:842)
[Configuration] at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:587)
[Configuration] at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:538)
[Configuration] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
[Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
[Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
[Configuration] at $Proxy0.start(Unknown Source)
[Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.Main.(Main.java:210)
[Configuration] at org.jboss.Main$1.run(Main.java:116)
[Configuration] at java.security.AccessController.doPrivileged(Native Method)
[Configuration] at org.jboss.Main.main(Main.java:112)

I have copied the ocijdbc8.dll in oracle\lib folder and have changed the environment settings for PATH to include this directory.

The JdbcCheckup program provided by oracle works fine(when using oci driver).
Is there a specific setting for JBoss & OCI drivers for oracle?

Thanks,

Vikas

[schaefera]

Can you provide the DataSource definition you use to create "DefaultDS".

Thanx - Andy

[vsingh]

Hi Andy,

Here is the Datasource entry from JBoss.jcml


DefaultDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:oci8:@vikasnt:1521:PARTNER
PARTNERADMIN
PARTNERADMIN




Thanks,

Vikas

[droman]

Hi,

you seem to have wrong darabase URL for oci. The kind of URL you are using will work for thin driver.

THIN : jdbc:oracle:oci8:@vikasnt:1521:PARTNER

OCI8 : jdbc:oracle:oci8:@PARTNER

Don't forget to define PARTNER in tnsnames.ora.

Dmitri.

[vsingh]

Hi Dmitri,

Thanks for pointing out the mistake in the DB URL. I changed the dburl in JBOSS.jcml. It seems as if I had some problem with the Oracle Client installation on my PC too. I had to reinstall Oracle client (Specifically the JDBC drivers) and after that it worked for me.

Thanks again for helping me out.

Vikas