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/