Bartosz Oudekerk wrote:
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>
Replying to myself....
If you're having this problem with the CMS, you run the risk of running
into the same problem with the repository, would it ever cease to
receive requests for any substantial amount of time.
Add the following to your definition.xml (below the dbcpPooling
parameter):
<parameter name="dbcp.testWhileIdle">true</parameter>
<parameter name="dbcp.timeBetweenEvictionRunsMillis">600000</parameter>
<parameter name="dbcp.validationQuery">SELECT 1</parameter>
p.s.: I have not tested the 'SELECT 1' query on postgresql, make sure it
doesn't return an error. If it does, replace it with a simple query that
doesn't ;)
p.p.s: Just FYI, this problem is most likely caused by a firewall
between the applications and the databases silently dropping the
connection after it being idle for a while (an hour in most cases).
Regards,
Bartosz
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
