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.
Difference between revisions of "Talk:Jetty/Howto/Configure JNDI Datasource"
(Suggestion to add testOnBorrow and validationQuery to DBCP config parameters.) |
(No difference)
|
Revision as of 09:22, 15 July 2012
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