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

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.