Hello,
i am using hibernate with a c3p0 connection pool. Now i am a little bit worried. Allthough c3p0 sometimes closes unused connections, the number of managed connections is increasing with any connection-failure. Seems like broken connections hang up and could not be closed.
Here are my active Hibernate properties:
Code:
<property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
...
<!-- C3PO -->
<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.idle_test_period">100</property>
<property name="c3p0.max_size">100</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.min_size">3</property>
<property name="c3p0.timeout">100</property>
<property name="c3p0.maxConnectionAge">100</property>
I have allready tried this c3p0 params:
* maxConnectionAge
* maxIdleTime
* maxIdleTimeExcessConnections
Whithout Connection failures the pool has this values:
Code:
trace com.mchange.v2.resourcepool.BasicResourcePool@e8eeca [managed: 3-4, unused: 3, excluded: 0] (e.g.
After some broken connections it looks like this:
Code:
trace com.mchange.v2.resourcepool.BasicResourcePool@e8eeca [managed: 10, unused: 2, excluded: 0] (e.g.
Is it possible to shrink the pool to the initial size again?
kind regards
Martin[/code][/list]
Login
FAQ
Search