Hi,
i am using Hibernate 3.1 with struts 2.0 and mysql as DB. My c3p0 connection setting are as follows..

<property name="hibernate.c3p0.min_size">3</property>
<property name="hibernate.c3p0.max_size">5</property>
<property name="hibernate.c3p0.timeout">20</property>
<property name="hibernate.c3p0.preferredTestQuery=SELECT 1"></property>
<property name="hibernate.c3p0.testConnectionOnCheckout=true "></property>

<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.idle_test_period">20</property>

But still when I start my application and do showprocesslist it shows 6 connection in sleep more over as I roam into the application with other requests they keep on increasing and doesnt get kill..

and eventually after some time it stops with exception showing no resource in pool.

Please help its urgent as my application is in testing and release date is near..


Thanks
Nimit