3 Replies Latest reply on Jan 8, 2003 12:25 AM by George Chianese

    Oracle OCI Driver Configuration

    George Chianese Newbie

      We are using Oracle8i and can connect with SQL*Plus from the server running JBoss/Tomcat bundle. I've reviewed both the JBoss forums and Oracle forums, but I'm still not getting OCI drivers to work.

      In attempting to convert from using Oracle Thin drivers to Oracle OCI, I've just changed oracle-service.xml to:

      <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:oci:@myservice</config-property>

      Which causes this error:

      Find failed: org.jboss.util.NestedSQLException: A
      pparently wrong driver class specified for URL: class: oracle.jdbc.driver.Oracle
      Driver, url: jdbc:oracle:oci:@myservice; - nested throwable: (javax.resource.R
      esourceException: Apparently wrong driver class specified for URL: class: oracle
      .jdbc.driver.OracleDriver, url: jdbc:oracle:oci:@myservice)

      I then changed the URL from 'oci' to 'oci8':

      <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:oci8:@myservice</config-property>

      Which caused this error:

      Caused by: java.lang.UnsatisfiedLinkError
      : Can't find library ocijdbc8 (libocijdbc8.so) in java.library.path

      I then put the Solaris version libocijdbc8.so in /usr/lib and get this:

      javax.transaction.TransactionRolledbackException: /usr/lib/libocijdbc8.so: /usr/lib/libocijdbc8.so: ELF file data encoding not little-endian; nested exception is:
      java.lang.UnsatisfiedLinkError: /usr/lib/libocijdbc8.so: /usr/lib/libocijdbc8.so: ELF file data encoding not little-endian

      Which of course makes sense, since C binaries are not compatible between Linux and Solaris.

      Any suggestions would be greatly appreciated.