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 Regards, Jeroen reijn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevo Slavic Sent: Tuesday, May 27, 2008 9:21 PM To: Hippo CMS development public mailinglist Subject: Re: [HippoCMS-dev] Load balanced Hippo, Master-Slave Postgres, andSQLException Hello Jeroen, Thanks for quick reply! Situation is following: * there are two web servers and on each there is o two tomcats o one hippo repository (latest) o one hippo cms (latest) * two db servers with postgres 8.3 installed in a master-slave configuration using slony 2 repositories are configured for load balancing (jgroups configuration should be ok) and they see DBs as a single DB, through a context sensitive switch. Correct JDBC driver is being used, postgresql-8.3-603.jdbc4.jar and attached you can find requested configuration file. Regards, Stevo. Jeroen Reijn wrote: > Hi Stevo, > > could you provide us with some more details? Which version of Postgress are > you using for instance? > Are the postgres server and the CMS on the same machine, or are they on > different machines? > > Could you perhaps post your postgres workflow configuration to the list? Have > you checked that you are using the correct JDBC driver? > > Regards, > > Jeroen > > > -----Original Message----- > From: [EMAIL PROTECTED] on behalf of Stevo Slavic > Sent: Tue 5/27/2008 8:00 PM > To: Hippo CMS development public mailinglist > Subject: [HippoCMS-dev] Load balanced Hippo, Master-Slave Postgres,and > SQLException > > Hello all, > > I'm not sure which of the 3 from the subject is good, bad, or ugly, but > something doesn't work in this configuration and I need your help. > Everything seems to work for some time, editing, creating, etc. but then > suddenly after a while Hippo CMS editor becomes unresponsive, just > showing animation in its right-hand bar. Log (see attachment) prints an > SQLException. > > Any advice where to look for a solution would be highly appreciated. > Thanks in advance! > > Regards, > Stevo. > > ******************************************** > Hippocms-dev: Hippo CMS development public mailinglist > > -- Met vriendelijke groet / Kind regards, Stevo Slavić Senior Software Developer Levi9 Global Sourcing ------------------------------------------------------------------------ . Jan van Goyenkade 8, 1075 HP Amsterdam, The Netherlands ( (+31) (0) 20 6701 947 È (+381) (0) 63 7 258 458 * [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ^ Skype: sslavic ü http://www.levi9.com/ Chamber of commerce Levi9 Global Sourcing BV: 34221951 Chamber of commerce Levi9 Global Sourcing Benelux BV: 34224746 ------------------------------------------------------------------------ This e-mail may contain confidential or privileged information. If you are not (one of) the intended recipient(s), please notify the sender immediately by reply e-mail and delete this message and any attachments permanently without retaining a copy. Any review, disclosure, copying, distribution or taking any action in reliance on the contents of this e-mail by persons or entities other than the intended recipient(s) is strictly prohibited and may be unlawful. The services of Levi9 are exclusively subject to its general terms and conditions. These general terms and conditions can be found on http://www.levi9.com/ and a copy will be promptly submitted to you on your request and free of charge.
******************************************** Hippocms-dev: Hippo CMS development public mailinglist
