debug « Connection « JPA Q&A

1. c3p0 unreturned connection debugging not activating

Hello, I am using hibernate 3.6.1 with hibernate-c3p0-3.6.1.Final.jar and c3p0-0.9.1. The managed c3p0 connections gradually increases until it reaches it's max limit. This can be seen in the c3p0 logs, e.g. trace com.mchange.v2.resourcepool.BasicResourcePool@26193229 [managed: 72, unused: 2, excluded: 0] (e.g. com.mchange.v2.c 3p0.impl.NewPooledConnection@3088890d) These are the c3p0 properties: hibernate.c3p0.min_size=5 hibernate.c3p0.max_size=80 The application is not in a production environment and does not require ...

2. Debugging Connection Leaks with C3P0

This is a pretty general question and I apologize in advance if it's been covered here before. I'm having problems using hibernate and c3p0 wherein my c3p0 connection pool becomes exhausted. I'm trying to debug this problem by putting stacktrace logging calls into the c3p0 source on checkin/checkout of connections. I'm sure there's a better way to do this, can anyone ...

3. Showing connection pool debug info

Currently we're using c3po for connection pooling. Is there a way to show debug information about the pool? Like how many open connections, etc. I'd like to make a test jsp that shows that information on demand. If not with c3po, is there a way using any of the other pools? Thanks in advance.