All,

Am attempting to detect cases where I have Hibernate session objects which have been opened and not closed. I wrote the following method:

public static String getOpenSessionsMsgString(Session sess) {
Statistics stats = sess.getSessionFactory().getStatistics();
long num_sessions = stats.getSessionOpenCount();
if (num_sessions > 0) {
return "Open sessions after close: " + num_sessions;
}
else {
return null;
}
}

which I am calling everywhere I do a close in the hopes of discovering when the "opened but not closed" sessions are being generated.

I call the above method and if the # of open sessions is > 0, I'll return a string which I'll print, like so:

ca.getSession().close();
sess_message = GeneralUtils.getOpenSessionsMsgString(ca.getSession());
if (sess_message != null) {
System.out.println("InvoiceService.queue: " + sess_message);
}

My questions are:

1) Should I expect to be able to get at the session open count through the session which I just closed?

2) Is there a way to look at the set of sessions that are managed by the session factory or can I just use this statistics object to look at the runtime state of the sessions.

Thanks,
Wes

Apparently, from looking at my log file, my statistics are disabled. How do I enable them?

FYI, I am comfortable with Hibernate concepts (big ActiveRecord user in the Ruby world), but have not implemented anything with it.

Thanks,
Wes

I know it's totally uncool to reply to your own post, but it feels like the correct thing to do to keep all of the info. together.

I got my statistics enabled, and I'm looking at this:

Statistics stats = sess.getSessionFactory().getStatistics();
long num_sessions_opened = stats.getSessionOpenCount();
long num_sessions_closed = stats.getSessionCloseCount();

long num_stranded_sessions = num_sessions_closed - num_sessions_opened;

Would num_stranded_sessions above be the correct value to look at for sessions which are causing the "unclosed connection - forgot to call close() on your session?" warnings?

Thanks,
WG