I've gathered a JSF component that collects most of the stats&infos from a given sessionFactory and visualizes them on page. It's called HibernateTrace, it's the statistician of your hibernate-based jsf applications.

The component is formed from 6 parts. They are,

1. General statistics
2. Statistics per Query
3. Statistics per Entity
4. Statistics per Collection
5. Second Level Cache Statistics
6. Generated SQLs from logging mechanism (if available)

Here is a screenshot:




You can download the component and a sample-webapp from jsf-comp at sourceforge.

http://sourceforge.net/project/showfiles.php?group_id=137466&package_id=215840

Regards,

Mert..
http://www.jroller.com/page/mert

Hi,

the component looks good.

One question about the source though - why do you copy all the values when you can just access them directly or delegate to them ?

p.s. did you consider contributing it to hibernate tools which has a (not yet very documented) swingbased statistics browser ?

Hi Max,

Yes, these are the wrapper classes for now, but i'll also assign to them other duties like tooltip-info collecting and calculation stuff about some pie charts. Those ones are also serializable so I thought it would be better to abstract these implementations from hibernate impl.

I'll be willing to make a contribution to hibernate_tools. Any procedure for this?

Mert..
http://www.jroller.com/page/mert

ok - fair enough about the additional func; but you do know the statistics them selves are serializable ?

Regarding contributions then it might make more sense to have them in jboss seam or similar - but lets see. The biggest issue in hibernate tools is that we would need to beef up with the jsf dependencies.

In any way you will need to sign a contributor agreement (its just a click through), but let see if/were we can find room for it.

Have you considerede session statistics too ?

in 3.2.1ga StatisticsImpl and SessionStatisticsImpl are not serializable. Am I wrong?

You can ping me for the agreement.

Yes I looked into session statistics but I've got exception while retrieving them, I'll be working on it..

whoops sorry - yes, the statistics is not serializable. my bad.

I want them to be serializable (or at least able to take snapshot for later comparison)

I'll ping you some time in the new year.

What was the exception you got ?

I also want them to be serializable :)

Ok, looking forward to hear from you...

Actually when i tried to get the current session from sessionFactory, I got the usual exception...
"No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here".

The "usual" exception ?

That exception should not occur - when are you calling getStatistics ?

Maybe it is just because you have a guarded session where we need to allow getStatistics to be called out of txn boundaries (we had to do the same for getSessionFactory)

a "known" exception would be more suitable..
The statistics (also the ones in session) are accessed from uiComponent class and the code is not enclosed in a txn environment. In the sample webapp I only used transactionInterceptor with the beans named *ServiceImpl. and the component accesses the sessionFactory with a valueBinding. It seem to me that there is no problem with the txns. or is it..

I am happy with inbuilt JMX mbean for now ... :)

suit yourself.. :)

i've changed the formRenderer in my projects so at the end of each page, hibernateTrace gets rendered..

And what should be done to get statistics for criterias?
haven't seen any implementation for this.
I also don't wanna live them out.

well the exception occurs on all methods that is not allowed/supposed to be accessed outside of a txn when you use sf.getCurrentSession().

And i'm saying maybe we are too restrictice about giving access to the statistics....sounds like a bug to me. You should be able to access it inside a tx though ?

Max,

Yes, I am getting the statistics in a tx environment.

but if you were running under a tx then you would not get an exception that says: ""No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here"."

could you show the full trace ?