How to dectect jdbc connection leak?

asklxf · **Joined:** Fri Feb 17, 2006 12:18 am **Posts:** 11

hi, i'm using Hibernate 3.1 and i want to check if my web app has connection leak so i set

log4j.logger.org.hibernate.transaction=debug, stdout
log4j.logger.org.hibernate.jdbc=debug, stdout

and hibernate output:

10:11:22,390 DEBUG ConnectionManager:398 - aggressively releasing JDBC connectio
n
10:11:22,390 DEBUG ConnectionManager:398 - aggressively releasing JDBC connectio
n

...

10:11:22,390 DEBUG ConnectionManager:369 - connection already null in cleanup :
no action
10:11:22,390 DEBUG ConnectionManager:369 - connection already null in cleanup :
no action

Is these log correct? and what is "aggressively releasing" means? thanks!

batmat · **Posted:** Thu Jul 06, 2006 5:39 am

Why are you trying to do that by yourself ? It's the work of a connection pool.

To do, I'd try to send a query to the db surrounded by a "try catch", if I receive an error, I'd dismiss the connection.

But as I said, this is typically the kind of work a pool connection is designed for. For example, you usually define sql queries that have no impact in perfs and lets you test that the db answers correctly (on oracle, for example, "select * from dual"). Then the pool sends this query regularly to the db into each connection to test.