1) Like most options, it is a config property on the connection factory:
<config-property name="CheckValidConnectionSQL" type="java.lang.String">
2) If it is not in the jboss distribution it is not supported in the version of jboss you have.
I assume you are using an early version of 3.0.x?
Thanks Adrian for prompt reply.
We are using JBoss 3.0.4.
I tried specifying following config-property
<config-property name="CheckValidConnectionSQL" type="java.lang.String">SELECT 1 FROM DUAL</config-property>
Error I got was :
java.lang.IllegalArgumentException: The class 'class org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory' has no setter for config property 'CheckValidConnectionSQL', ObjectName:jboss.jca:service=NoTxCM,name=MYDS
Could you please also tell me which jar file has "org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter" class ?
Thanks & Regards
Not your version. Looking at CVS it was introduced in 3.0.7 or 3.2.x
Before you ask, No It will not work in 3.0.4
Thanks for your reply.
What could be workaround in JBoss 3.0.4 to check connection before it is returned from the pool? Is there any way to refresh this pool if connections are stale ?