Hi,
We currently use hibernate (3.2.0.cr5) which in turn uses c3p0 to create a connection pool(c3p0-0.9.1-pre9). We have a connection leak and i tried to track it by setting the c3p0 variable debugUnreturnedConnectionStackTraces to true. I see the following in the hibernate log,

20 Jul 2009 13:18:55,137 DEBUG main org.hibernate.cfg.Configuration - c3p0.unreturnedConnectionTimeout=5
20 Jul 2009 13:18:55,137 DEBUG main org.hibernate.cfg.Configuration - c3p0.debugUnreturnedConnectionStackTraces=true

but the c3p0 still has variable set to false. Can someone help me?

20 Jul 2009 13:18:56,443 INFO main com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@a100a15a [ connectionPoolDataSource -
> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@fd03835c [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> nu
ll, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedC
onnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 3c520, idleConnectionTestPeriod -> 10, initialPoolSize -> 10, maxAdminist
rativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1000, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 125, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nes
tedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@9ac911cb [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 8e2fb5, jdbcUrl -> jdbc:mysql://lo
calhost:3306/infibeam_old, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unr
eturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 624a40, numHelperThreads -> 3
]


thanks
Vijay

You should set the property in your code before you instantiate the SessionFactory object.