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:

      <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>

      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?