[jboss-user] [JBoss jBPM] - Re: Connections never close. Two many connections exception

[mputz]

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:

http://www.hibernate.org/214.html
http://www.mchange.com/projects/c3p0/index.html#hibernate-specific

I'm wondering why you have set idle_test_period to zero:

  | <property name="hibernate.c3p0.idle_test_period">0</property>
  | 

>From the first link above:
anonymous wrote : 
  | 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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4137703#4137703

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4137703