I'm using c3p0 9.0.4 with hibernate 3.0.4 and MySQL 4.1
I successfully run a load test for 48 hours with ~10M
DB operations through c3p0 (way to go!). However, 30
minutes after the test ended the system died on a
simpler test because c3p0 does not create new DB
connections. The error I get is "TimeoutException:
internal -- timeout at awaitAcquire()"
Digging in I found that once it became idle, c3p0
cleared the connection pool so it has 0 connections
(below my setting of hibernate.c3p0.max_size=3 !!!).
Once it dropped below 0, it never makes any new
connection. All requests for new connections just time
out. A full restart is required to exist this state.
My c3p0 configuration is:
I will appreciate any help!