[jboss-jira] [JBoss JIRA] (JBJCA-1140) New option for <validate-on-match/> policy

[Jesper Pedersen (JIRA)]

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

Jesper Pedersen updated JBJCA-1140:
-----------------------------------

    Component/s: JDBC
                     (was: Code Generator)

    
> New option for <validate-on-match/> policy
> ------------------------------------------
>
>                 Key: JBJCA-1140
>                 URL: https://issues.jboss.org/browse/JBJCA-1140
>             Project: IronJacamar
>          Issue Type: Feature Request
>          Components: JDBC
>         Environment: JBoss EAP 6.2.0
>            Reporter: Tom Ross
>            Assignee: Jesper Pedersen
>
> There is a requirement for a new option in the pool connection validation. 
>  <validate-on-match/> should validate, except if the connection has been returned recently into the pool for instance in the last 10 secs.
> The reasoning is that if the connection has been used in the last 10 secs, and it is consider as checked. so it is not worth doing an extra validation.
> The only way this could be approached at the moment would be to use more aggressively background validation. But this would put more needless pressure on the db considering all pool filled with many connections that will take time to shrink down.
> With the proposed solution, would be the best of both worlds: an active application does not pay for the price of validation before use, although it uses checked connections, without having to schedule aggressive background checks.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira