Details
-
Task
-
Resolution: Won't Fix
-
L3 - Default
-
None
Description
In the current tomcat distro the jdbc configuration contains no connection validations.
Frequently the question arises why jdbc connections on the tomcat are closed (exceptions are thrown as well) See for example this forum post or the linked support issue.
Simple solution is to specify the validation behavior for the connection pool, also the
test for borrow and removing of abandoned connections.
So the resource configuration should contain the following lines:
<Resource
[...]
validationQuery="SELECT 1"
validationInterval="34"
testOnBorrow="true"
removeAbandoned="true"
removeAbandonedTimeout="233"
/>
The values are only for example they should be checked if they are useful.
This configuration is only true for tomcat and h2.
We need to add a comment to the documentation, if some one needs to use another database he have to change the validation query. Maybe we link to the tomcat apache configuration page 1 .
Something similar can be done for WildFly and JBoss.