I'd suggest using real connectionpools from you appserver with datasources instead of plain hibernate and c3p0
Is there anyway to use a Local Datasource? I mean, I havenÂ´t got any appserver because my application is "standalone". I have JBPM running inside a "standalone" application.
Thanks in advanced.
Ahhh... hmmm... no sorry, I have no clue on this. c3p0 should fill that gap afaik.
if an app server is out of the picture, have a look at the following URLs, which contain helpful information on the c3p0 configuration options, especially in the combination with Hibernate:
I'm wondering why you have set idle_test_period to zero:
From the first link above:
If this is a number greater than 0, c3p0 will test all idle, pooled but unchecked-out connections, every this number of seconds.
I would start off with the values as shown in the sample config on the first link above and thus set it to 100 (seconds). Let us know if you start to see a difference.
The error was inside in my application code. There was a jbpmContext that was never closed, so this connection was always active.
I'm using c3p0 with success.
Thanks again and forgiveness for the inconvenience.
Would you care to summarize this somewhere on the wiki?