Hibernate version:
Hibernate 3.2.2 GA

Name and version of the database you are using:
MySQL Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2


I know Hibernate offers plenty of statistics for the session factory, but I was wondering whether it is possible to get a hold of similar information for one single session. More specifically; I'm asking about the number of queries performed on the sql backend database. I'm reusing my session factory so that I have to make it only once and then spawn sessions off that, but I'd still like to know how many mysql queries were used in one session between its creation and its committing.

Is there a way to do this? I know there are SessionStatistics but these appear to only contain information on the number of cached entities and such.

Thanks in advance.

Any ideas, anyone?

Sorry for the bump.

bump...

try

http://www.javalobby.org/java/forums/m9 ... l#91839946

I've come along that article before (I do use Google) and I'm quite impressed by Hibernate's rich statistics API. But as I've stated in the OP, these statistics are all based on session factories, which means that they accumulate. What I need is the number of sql queries that were performed in a single session, starting with the session being opened to the point where it is closed. I'm building a web application and I'm using the "one session per page request" pattern and I'd really like to be able to see how much queries each request costs.

Is my requirement that exotic that nobody has encountered something like this before?