Bypass validate-on-borrow
-------------------------
Key: AG-100
URL:
https://issues.jboss.org/browse/AG-100
Project: Agroal
Issue Type: Feature Request
Reporter: Philippe Marschall
Assignee: Luis Barreiro
Priority: Major
Fix For: 1.4
We recently evaluated JDBC connections pools for Java SE and were impressed by the
connection validation algorithm implemented by
[
HikariCP|https://github.com/brettwooldridge/HikariCP]. We would like to see something
similar implemented by Agroal.
HikariCP implements validate-on-borrow using {{java.sql.Connection.isValid(int)}} (Java
1.6/JDBC 4.0). However if the connection has been successfully used in the past 500ms then
this check is bypassed. To quote the author
{quote}Generally speaking, in an active application or process, this avoids nearly all
validation, while providing confidence that the connections returned by the pool are
actually alive.{quote}
Discussion is here
https://groups.google.com/forum/#!searchin/hikari-cp/batch%7Csort:date/hi...