Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.4, 1.4.1
Description
Hello,
Current method of connection validation relies on validationQuery.
This method has a rather big performance impact on the DB (CPU, for example 3% with SELECT 1 FROM DUAL even with Oracle 10G FAST DUAL) and make an additional query for each borrow (when testOnBorrow is true).
Wouldn't it be better to use new JDBC 4 method isValid which relies on Driver check ? (Oracle would for example use its internal method ping)
Thank you
Philippe
http://www.ubik-ingenierie.com
Attachments
Issue Links
- is duplicated by
-
DBCP-401 PoolableConnectionFactory.validateConnection() doesn't test connection.isValid()
- Closed