[opencms-dev] OpenCms not closing connections on Postgres?

[John Fereira]

At 04:42 AM 3/6/2008, Juan Francisco Fernández Rodrígu wrote:
>Hi Georgi, we are migrating our servers to 
>Postgres 8.2.6, but Im not the server admin and 
>the process is being too slowly... Now, I'm 
>trying with the postgresql-8.1-412.jdbc3.jar, to 
>check if it is related to driver version, but it 
>doesn't look better :(. Thanks a lot!!!! -----

It unlikely a problem with Postgres or the driver 
that you're using, but how the connections are 
being managed.  Are you letting Tomcat manage the 
database connections with DBCP (databate 
connection pooling)?  There are a number of 
configurable options which determine how 
connections are released back to he pool.  I 
don't know enough about the OpenCMS code to know 
how it wires in database connection management 
but I've worked on other applications which 
handle a much larger number of connections 
without a hitch.  I'm hoping to install the 7.0.4 
version today for evaluation as a possible 
platform for a Conference Management content management system.


jaf30 at cornell.edu
Ithaca, NY