java - JDBC Connection Pool: connections are not recycled after DB restart -


i added setmaxactive(8) on org.apache.tomcat.jdbc.pool.poolproperties. every time db restarts, application unusable because established connections remain. following error:

org.postgresql.util.psqlexception: connection has been closed

i've tried using other settings on pool no avail...

thank help!

use validationquery property check if connection valid before returning connection.

ref: tomcat 6 jdbc connection pool

this property available on latest tomcat versions.


Comments