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

[Luis Barreiro (Jira)]

     [ https://issues.jboss.org/browse/AG-100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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



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