Is there a way to define the query to use for testing the database connection pool?
You can define the query to use for testing connections by specifying the preferredTestQuery property in the <xMHOME>/webserver/webapps/cocoon/WEB-INF/classes/c3p0-config.xml file.
For example, on an Oracle deployment:
<property name="preferredTestQuery">SELECT 1 FROM DUAL</property>
DTN-2234, SUP-3734, JDN-1092
Originally created by Don Clark