problem w/ OracleValidConnectionChecker
dabramov Jul 5, 2005 5:49 PMUsing:
JBoss 3.2.6
Java 1.4.2_05-b04
Oracle: 9.2.0.1.0
Oracle driver: 9.0.2.0.0
I'm trying to use the OracleValidConnectionChecker, but get the exception below when a connection is requested.
From the error and taking a look a the OracleValidConnectionChecker, it looks like Connection being passed in, isnt' really an Oracle connection. Ideas?
My datasource config looks like:
<?xml version="1.0" encoding="UTF-8"?> <!-- Data Source for the Insight DB --> <datasources> <no-tx-datasource> <jndi-name>SonusInsightDS</jndi-name> <connection-url>jdbc:oracle:thin:@10.6.20.110:1521:DADB</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>dbimpl</user-name> <password>dbimpl</password> <min-pool-size>1</min-pool-size> <max-pool-size>2</max-pool-size> <idle-timeout-minutes>240</idle-timeout-minutes> <!-- Warn when statements and result sets are returned to the connection pool and are not closed --> <!-- track-statements>true</track-statements --> <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name> </no-tx-datasource> </datasources>
2005-07-05 16:14:55,185 WARN [org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker] Unexpected error in pingDatabase
java.lang.IllegalArgumentException: object is not an instance of declaring class
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:51)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:458)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:284)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:166)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:444)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:429)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
...