Problems in using Oracle 9i OCI driver specified in oracle-d
dsn Jun 20, 2005 5:20 PMWe 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