I'm using a c3p0 connection pool in hibernate and I attach the property that I configured in hibernate.cfg.xml:



<property name="hibernate.c3p0.acquire_increment">1</property> <property name="hibernate.c3p0.idle_test_period">12</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.max_size">10</property>
<property name="hibernate.c3p0.min_size">2</property>
<property name="hibernate.c3p0.timeout">60</property>

I aspect that when start my web application I see in My SQL connection manager only 2 connection if the application is not called from anyone.
I aspect that the maximum connection that the pool will use is 60 and that when a the application use a connection, it dies after 60 second if another user asks to use it.

Indeed, I see in my connection manager that when the application starts, the connection from the ip of the server where the application is deployed are the double of the hibernate.c3p0.min_size parameter value, exactly 4 and that these connection die after 12 seconds (hibernate.c3p0.idle_test_period value) and are created newly.

Why the c3p0 connection pool not work with the parameters I configured?
There are the c3p0 parameters that I don't know?
And at this point, what is the mean of the basic paremeters for the C3p0 and how can I set them ?

Than You to anyone have same inofrmation about this topic