[
https://issues.jboss.org/browse/AG-100?page=com.atlassian.jira.plugin.sys...
]
Luis Barreiro resolved AG-100.
------------------------------
Fix Version/s: 1.4
Resolution: Done
[~pmm] thank you very much for the feature request!
Implemented as 'Idle Validation': connections that are on the pool for longer than
X are validated before being handled to the the app using the current validation strategy
(see AgroalConnectionPoolConfiguration#ConnectionValidator)
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...
--
This message was sent by Atlassian Jira
(v7.12.1#712002)