[DBCP-263] Use a queryTimeout for the validationQuery in PoolableConnectionFactory

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.2, 1.2.1, 1.2.2
• Fix Version/s: 1.3
• Assignee: Unassigned
• Reporter: Christoph Grothaus
• Created: 28/Mar/08 07:32
• Updated: 25/Jan/09 04:07
• Resolved: 25/Jan/09 04:06

Description

PoolableConnectionFactory.validateConnection(Connection conn) should use java.sql.Statement.setQueryTimeout(int) to avoid network problems and inappropriate validation queries. The timeout should either be a sensible default (say 5 secs) or be configurable.

Links:

• http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/src/java/org/apache/commons/dbcp/PoolableConnectionFactory.java?view=markup
• http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#setQueryTimeout(int)

Issue Links

• duplicates: DBCP-226 DBCP should support configuration of queryTimeout for validation queries