Here's my stacktrace:
19:11:01,056 WARN [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(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker.i
sValidConnection(OracleValidConnectionChecker.java:54)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.i
sValidConnection(BaseWrapperManagedConnectionFactory.java:377)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkVal
id(BaseWrapperManagedConnection.java:212)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.m
atchManagedConnections(LocalManagedConnectionFactory.java:186)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
tConnection(InternalManagedConnectionPool.java:167)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
ool.getConnection(JBossManagedConnectionPool.java:529)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
dConnection(BaseConnectionManager2.java:410)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
nnection(TxConnectionManager.java:342)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:462)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:894)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
erDataSource.java:73)
Here's my ds.xml to show it's configured correctly (this is working fine with
JBoss 3.2.5, I'm now trying to move up to 4.0.2 or 4.0.3 both are giving this
error):
<local-tx-datasource>
<jndi-name>jdbc/MyDS</jndi-name>
<connection-url>jdbc:oracle:thin:APP/APP@//mybox:1521/MYDB</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<min-pool-size>20</min-pool-size>
<max-pool-size>400</max-pool-size>
<!-- Uses the pingDatabase method to check a connection is
still valid before handing it out from the pool -->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<!-- Checks the Oracle error codes and messages for fatal
errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- Make a large statement cache size for increased
performance -->
<prepared-statement-cache-size>100</prepared-statement-cache-size>
<!-- Checks for idle connections retrieved from the pool and
times them out -->
<!-- This should be set to the same value as the auto-logout
property -->
<idle-timeout-minutes>30</idle-timeout-minutes>
</local-tx-datasource>
I've also noticed now that in some of my queries that then cast results back to
oracle.sql.Array type, that is also throwing a ClassCastException.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899741#3899741
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899741
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
