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

[Juan Francisco Fernández Rodríguez]

Yes, OpenCms uses DBCP to pooling connections, and it is supposed to close
connections, so removeAbandoned and other similar config options on DBCP
must not be the problem. In opencms.properties I have these settings:

db.pool.default.maxActive=100
db.pool.default.maxWait=2000
db.pool.default.minIdle=3
db.pool.default.maxIdle=10
db.pool.default.whenExhaustedAction=block

-----Mensaje original-----
De: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org]
En nombre de John Fereira
Enviado el: jueves, 06 de marzo de 2008 12:45
Para: The OpenCms mailing list; 'The OpenCms mailing list'
Asunto: Re: [opencms-dev] OpenCms not closing connections on Postgres?

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 


_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev