[DBCP-249] Validate connection only on create.

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.2
• Fix Version/s: 2.0

Environment

All.

• Assignee: Unassigned
• Reporter: Parag Mehta
• Created: 14/Nov/07 18:17
• Updated: 31/May/14 04:14
• Resolved: 25/Feb/14 12:26

Description

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