[jira] Issue Comment Edited: (DBCP-263) Use a queryTimeout for the validationQuery in PoolableConnectionFactory

["Henri Yandell (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DBCP-263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12592617#action_12592617 ] 

bayard edited comment on DBCP-263 at 4/26/08 6:39 PM:
-------------------------------------------------------------

Seems like a good idea. Patches welcome :)

      was (Author: bayard):
    Seems like a good idea.
  
> Use a queryTimeout for the validationQuery in PoolableConnectionFactory
> -----------------------------------------------------------------------
>
>                 Key: DBCP-263
>                 URL: https://issues.apache.org/jira/browse/DBCP-263
>             Project: Commons Dbcp
>          Issue Type: Improvement
>    Affects Versions: 1.2, 1.2.1, 1.2.2
>            Reporter: Christoph Grothaus
>            Priority: Minor
>             Fix For: 1.3
>
>   Original Estimate: 0.5h
>  Remaining Estimate: 0.5h
>
> 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)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.