2 Replies Latest reply on Apr 7, 2008 4:41 PM by clementcm

    Problems in using Oracle 9i OCI driver specified in oracle-d

    dsn

      We are trying to use the OCI driver with Oracle 9.2.0.1. The oracle-ds.xml file in the 'deploy' directory has the following entry (per JBoss documentation), and ojdbc14.jar is in the 'lib' directory and the CLASSPATH.

      <local-tx-datasource>
      <jndi-name>opalPool</jndi-name>
      <connection-url>
      jdbc:oracle:oci:@COVIGDB</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>sa</user-name>
      sa
      <min-pool-size>10</min-pool-size>
      <max-pool-size>35</max-pool-size>
      <transaction-isolation>
      TRANSACTION_READ_COMMITTED</transaction-isolation>
      <exception-sorter-class-name>
      org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>

      The following exception is thrown when getting a connection:

      [exec] 13:42:20,397 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      [exec] org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url
      : jdbc:oracle:oci:@COVIGDB)
      [exec] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionF
      actory.createManagedConnection(LocalManagedConnectionFactory.java:168)
      [exec] at org.jboss.resource.connectionmanager.InternalManagedConnectio
      nPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
      [exec] at org.jboss.resource.connectionmanager.InternalManagedConnectio
      nPool.getConnection(InternalManagedConnectionPool.java:207)
      [exec] at org.jboss.resource.connectionmanager.JBossManagedConnectionPo
      ol$BasePool.getConnection(JBossManagedConnectionPool.java:535)
      [exec] at org.jboss.resource.connectionmanager.BaseConnectionManager2.g
      etManagedConnection(BaseConnectionManager2.java:445)
      [exec] at org.jboss.resource.connectionmanager.TxConnectionManager.getM
      anagedConnection(TxConnectionManager.java:298)
      [exec] at org.jboss.resource.connectionmanager.BaseConnectionManager2.a
      llocateConnection(BaseConnectionManager2.java:497)
      [exec] at org.jboss.resource.connectionmanager.BaseConnectionManager2$C
      onnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:888)
      [exec] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnecti
      on(WrapperDataSource.java:102)


      Any pointers are much appreciated.

      TIA
      Deepak

        • 1. Re: Problems in using Oracle 9i OCI driver specified in orac
          dsn

          We were able to make this work as follows -

          1. oracle-ds.xml has the following

          <local-tx-datasource>
          <jndi-name>opalPool</jndi-name>
          <connection-url>
          jdbc:oracle:oci:@COVIGDB</connection-url>
          <driver-class>oracle.jdbc.OracleDriver</driver-class>
          <user-name>sa</user-name>
          sa
          <min-pool-size>10</min-pool-size>
          <max-pool-size>35</max-pool-size>
          <transaction-isolation>
          TRANSACTION_READ_COMMITTED</transaction-isolation>
          <exception-sorter-class-name>
          org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
          </local-tx-datasource>

          2. Ensure that ojdbc14.jar is in /lib directory. And any classes12.zip (if previously used) is not in /lib

          3. Ensure that <oracle-home>/ora92/bin is in the system path

          Good luck
          Deepak

          • 2. Re: Problems in using Oracle 9i OCI driver specified in orac
            clementcm

            Hi dsn,

            We are having the same problem and we followed every thing you did. It is still throwing the same exception. Please help. Thanks!