[jboss-jira] [JBoss JIRA] (AG-100) Bypass validate-on-borrow

[Philippe Marschall (Jira)]

Philippe Marschall created AG-100:
-------------------------------------

             Summary: 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


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/hikari-cp/6XOI8_x9YeU/G3k6g9otAAAJ





--
This message was sent by Atlassian Jira
(v7.12.1#712002)