How do I change the connection test query for the database connection pool?

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>  

xMatters Reference

DTN-2234, SUP-3734, JDN-1092

Originally created by Don Clark

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk