4 Replies Latest reply on Nov 5, 2001 3:32 PM by Vikas Singh

    Unable to connect to Oracle when using oci driver

    Vikas Singh Newbie

      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