Our automation test uses Hibernate 2 and Java to persist test results into our Oracle 9i DB. We recently discovered several cases where the persistence of data hang. We have no clue as to what might cause this problem. I was wondering if there is any way in Hibernate we can check the status of database connections, like how many connections are active, what is the connection pool usage, etc.

Thanks.

Which connection pool do you use in your Hibernate application?
Is it C3P0?
If you use C3P0 version >= 0.9.1.2 then you can introspect the informations you look for
through attaching your jvm via jconsole and going to the MBean folder:
here there will be a bmean for C3P0 where you can get informations and else do perform some operations on the session pool.

Yes, I'm using C3P0. I'll try that. Thanks.