Jeroen Reijn wrote:
I'm not that familiar with Postgres. But as far as I can read from the
internet, this could be a solution.
http://forum.springframework.org/showthread.php?t=12990&page=2
They say switching from commons dbcp to C3P0 and set the following parameter:
idleConnectionTestPeriod
I don't see why you need to switch to C3P0, as DBCP[0] can do the same,
add the following three lines to the projectWorkflowDataSource bean:
<property name="testWhileIdle"><value>true</value></property>
<property name="validationQuery"><value>SELECT 1</value></property>
<property
name="timeBetweenEvictionRunsMillis"><value>600000</value></property>
This is a configuration we use in production with quite a few customers.
[0] http://commons.apache.org/dbcp/configuration.html
Regards,
Bartosz
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
