Jeroen Reijn wrote:
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.
No, it's not in svn and we sould add it. I think it came up a little
while ago on the list.
Bart
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
