Using:
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)
...
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883751#3883751
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3883751
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
