On 02/22/2010 02:33 PM, Paul Libbrecht wrote:

Hello XWikiers,

Today I met a short hang of our platform (also noticed by a nagios) which seemed to say in the log:

org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

Is it right to raise the <property name="connection.pool_size">2</property> to <property name="connection.pool_size">5</property>

in hibernate.cfg.xml?

IIRC, this was 20 at some point. I used it at that value for a long time, without any problems observed. Still, I've rarely seen it, although such a small pool size would make one expect it quite frequently on a normal site, and I've seen several connections to the database even with this small value, so I think that this configuration isn't taken into consideration. -- Sergiu Dumitriu http://purl.org/net/sergiu/