1 Reply Latest reply on Mar 17, 2005 6:50 AM by Mark Gruener

    Using an Oracle OCI connection pool

    Mark Gruener Newbie

      I need to create a connection pool using the Oracle OCI driver for my JMS pool in order to persist a Blob. When I try to deploy my OCI pool I get the following error:

      44:19,045 INFO [JmsDS] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=LocalTxCM,name=JmsDS to JNDI name 'java:/JmsDS'
      44:19,045 INFO [TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=JmsDS
      44:25,925 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
      .jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-06401: NETCMN: invalid driver designator


      My pool definition in the oracle-ds.xml file looks like this:

      <local-tx-datasource>
      <jndi-name>JmsDS</jndi-name>
      <max-pool-size>30</max-pool-size>
      <connection-url>jdbc:oracle:oci:@aserver.mydomain.com:1521:usdev106</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>fred</user-name>
      sorry
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
      </local-tx-datasource>

      I am running on Windows XP and have installed the Oracle 9 client software (DLLs). I am using ojdbc14.jar and all of my thin connection pools work fine, as well as this one if I change oci to thin. Any ideas?