Sounds like a good plan! Do we also have Postgres configuration somewhere, because they are not available from svn. I think that would be a good addition.
Regards, Jeroen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bart van der Schans Sent: Wednesday, May 28, 2008 9:30 AM To: Hippo CMS development public mailinglist Subject: Re: [HippoCMS-dev] Load balanced Hippo, Master-Slave Postgres,andSQLException Let's add these settings to the default configuration. They won't do any harm and prevent some nasty errors on networks with (strange) network timeouts. Bartosz, can you create a jira issue for this? Regards, Bart Jeroen Reijn wrote: > 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 -- Hippo B.V. - Amsterdam Oosteinde 11, 1017 WT, Amsterdam, +31(0)20-5224466 Hippo USA Inc. - San Francisco 101 H Street, Suite Q, Petaluma CA, 94952-3329, +1 (707) 773-4646 ----------------------------------------------------------------- http://www.onehippo.com - [EMAIL PROTECTED] ----------------------------------------------------------------- ******************************************** Hippocms-dev: Hippo CMS development public mailinglist ******************************************** Hippocms-dev: Hippo CMS development public mailinglist
