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?
I was able to solve my JMS problem by upgrading the Oracle driver. No need to use OCI. Upgrade ojdbc14.jar from 9.0.2.0.0 to 10.1.0.3.0.