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