Henry,
your c3p0.properties file looks good, but your hibernate config needs to use hibernate-mapped versions of c3p0's config parameters. (i know this is very confusing... hopefully the bifurcated configuration will be resolved soon.)
Anyway, your hibernate c3p0 config should look like this:
<!-- connection pool -->
<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">40</property>
<property name="c3p0.timeout">20</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.validate">true</property>
<property name="c3p0.idle_test_period">1800</property>
For the moment, and confusingly, c3p0 and hibernate simply have different names for the same parameters.
NOTE: your "timeout" and "idle_test_period" are inconsistent. you have the pool set up to test idle connections every half hour, but only to allow Connections to remain idle for 20 seconds before being purged from the pool. I'd switch timeout to something like 7200.
All of this said, the stack trace of a problem you posted earlier never even made it into c3p0-related code. If your application continues to break, please search your log files (it'll be wherever standard error/System.err gets logged) for an earlier stack trace, maybe search for the String c3p0, so I can get a better idea of where it's breaking if it is a c3p0 issue.
smiles,
steve
Login
FAQ
Search
