Commons-dbcp 1.4 supports a validationQueryTimeout property. The tomcat7 tomcat-jdbc connection pool (http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html) does not support this. Has anyone found a way to configure a validation query timeout or achieve similar functionality to commons-dbcp-1.4 in tomcat 7's tomcat-jdbc connection pool?
I note that there is a QueryTimeoutInterceptor, which appears to apply to all query timeouts, but I'd like to have the validationQueryTimeout much shorter than the normal query timeout. Many thanks Rob Dunn | Senior Software Engineer - Australia | Transaction Network Services Level 21, 300 Adelaide Street | Brisbane QLD 4000 | Australia Office +61.7.3224.9731 | Fax +61.7.3224.1785 | Mobile +61.415.860.282 e-mail rd...@tnsi.com<mailto:rd...@tnsi.com> | http://www.tnsi.com<http://www.tnsi.com/> This message and any attachments are for the sole use of each intended recipient and may contain copyright, confidential and/or privileged information of Transaction Network Services Inc or its related companies ("TNS"). Any unauthorised review, use, disclosure or distribution is prohibited. If you are not an intended recipient, please immediately destroy all copies of the original message and let the sender know by reply e-mail. Unless otherwise expressly specified all views are those of the sender and not TNS.
