Marco Casavecchia Morganti wrote:
Hello all,
This morning, when i opened the "to/do" panel of the CMS I obtained a
strange SQL error.
It seems to be a problem with the connection of the pool to the database..
The problem was solved with a restart of HippoCMS.
Can anyone tell me if i can do something to avoid it in the future?
(I'm running the workflow database undes PostgresSQL over a Solaris 10
system.)
PS: I attach to this mail my log4j.log where the error was logged.
It looks like the database connection is closed, but commons dbcp
doesn't detect it correctly [1]. Maybe you can fiddle with some dbcp
options [2]? You could look for things like: validationQuery="SELECT 1"
or testOnBorrow="true".
Regards,
Bart
[1] https://issues.apache.org/jira/browse/DBCP-23
[2] http://commons.apache.org/dbcp/configuration.html
--
Hippo
Oosteinde 11
1017WT Amsterdam
The Netherlands
Tel +31 (0)20 5224466
-------------------------------------------------------------
[EMAIL PROTECTED] / http://www.hippo.nl
--------------------------------------------------------------
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
