Jahia is now using Apache org.apache.commons.dbcp for the connection pool
But after the installation process, all entries in dbpool.properties are
commented out and then the connection pool is running with default values (see
http://jakarta.apache.org/commons/dbcp/configuration.html)
=> max number of connections is 8 :
under load the server will sload down dramatically
=> maxWait is infinite :
when connections are not properly released, they keep on being busy and the
server will freeze completely, waiting to be able to create a new connection (it
will never happen if the default 8 are already opened)
We are running fine with maxWait=5000 (5s) against postgresql 7.4.3
int.maxActive=100
int.maxIdle=10
long.maxWait=10000
This should provide for better default values, but might fail on database setups that do not support 100 connections.