Validate connection only on create.
-----------------------------------

                 Key: DBCP-249
                 URL: https://issues.apache.org/jira/browse/DBCP-249
             Project: Commons Dbcp
          Issue Type: New Feature
    Affects Versions: 1.3, 1.4
         Environment: All.
            Reporter: Parag Mehta


Request to add support for testOnCreate, to validate connections only when they 
are created, much less frequent than on borrow.

This will solve issues where for example driver logs you into master instead of 
db on the connection string because db is not available (e.g. Sybase) and then 
rest of the queries fail.  This only happens on first login.  Hence validating 
the correct db using sql can test such a case so that borrowers are guaranteed 
correct db without having to testOnBorrow every time.

May also be worthwhile to support different validation queries for testing at 
different times.

Thanks.
Parag

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

Reply via email to