Hi,
I have the following problem, I have been assign a project in which the connections are really badly managed, most times they are not closed. Since there are lots of places where the connections are open and not closed, I have configured hiberanate so it closses all idle connections while I change all the code, the thing is that right now there are over 200 connections open for over 8000 seconds, and hibernate does not close them.
This is my configuration:


hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
hibernate.connection.driver_class = org.gjt.mm.mysql.Driver
hibernate.connection.url = jdbc:mysql://localhost/opencms?autoReconnect=true&characterEncoding\=UTF-hibernate.connection.username = ***
hibernate.connection.password = ***

hibernate.connection.autoReconnect = true
hibernate.connection.autoReconnectForPools = true
hibernate.connection.is-connection-validation-required = true
hibernate.connection.charset = UTF-8
#hibernate.c3p0.min_size = 10
#hibernate.c3p0.max_size = 100
hibernate.c3p0.timeout = 100
#hibernate.c3p0.acquireRetryAttempts = 30
#hibernate.c3p0.idleConnectionTestPeriod = 36000
hibernate.c3p0.initialPoolSize = 20
hibernate.c3p0.maxPoolSize = 200
hibernate.c3p0.maxIdleTime = 100
hibernate.c3p0.maxStatements = 50
hibernate.c3p0.minPoolSize = 10
hibernate.dbcp.maxIdle=10
hibernate.c3p0.idle_test_period=100


Any ideas?

Regards