Hi Bartosz, Thanks for your suggestions. Might be a good idea to put this up on the wiki, so other developers can also obtain this information from the website.
As I mentioned I had no experience with Postgres as wel as with dbcp configuration. Good to know it also has these capabilities! Regards, Jeroen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bartosz Oudekerk Sent: Wednesday, May 28, 2008 2:26 AM To: Hippo CMS development public mailinglist Subject: Re: [HippoCMS-dev] Load balanced Hippo, Master-Slave Postgres,andSQLException 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 ******************************************** Hippocms-dev: Hippo CMS development public mailinglist
