Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Talk:Jetty/Howto/Configure JNDI Datasource
Revision as of 09:22, 15 July 2012 by Unnamed Poltroon (Talk) (Suggestion to add testOnBorrow and validationQuery to DBCP config parameters.)
Section 2.3 on the DBCP connection pool config would benefit from the inclusion of testOnBorrow and validationQuery attributes:
<Set name="testOnBorrow">true</Set> <Set name="validationQuery">SELECT 1</Set>
Without these, I found a deployment left running for a day or so against MySQL on a quiet server encountered errors about connections already being closed. Re: http://javathings.blogspot.com/2009/04/fix-for-timeout-on-db