Trying to access Hibernate Statistics

krawling · **Posted:** Fri Feb 16, 2007 5:41 pm

Hello All,

I am currently using Hibernate 3.2, JPA annotations, EJB 3 in Glassfish.

I am interested in gathering the hibernate statistics through the Hibernate Statistics object to monitor 2nd level cache usage. I know this is supported by JMX but trying to dump out statistics in the app at the moment and currently using an injected entity manager.

Any clues on how to get access to these stats?

Thanks alot.

Regards,
Kurt

emmanuel · **Posted:** Tue Feb 20, 2007 7:35 pm

((Session) em.getDelegate()).getSessionFactory().getStatistics();

krawling · **Posted:** Tue Feb 20, 2007 7:59 pm

Hi Emmanuel,

Thanks alot for the answer on this one!

Regards,
Kurt

krawling · **Posted:** Wed Feb 21, 2007 10:26 am

Emmanual,

I have one follow-up question. I assume this should work with an injected entity manager in Ejb 3 environment but receiving a class cast exception when casting to hibernate session object using Glassfish :

Code:

Statistics statistics =
                ((org.hibernate.Session) em.getDelegate())
                    .getSessionFactory()
                    .getStatistics();

Regards,
Kurt

krawling · **Posted:** Wed Feb 21, 2007 2:04 pm

Emmanual,

I did get it working with the following :

Code:

HibernateEntityManager hem = ((HibernateEntityManager)em.getDelegate());
            Statistics stats = hem.getSession().getSessionFactory().getStatistics();

I had to enable the statistics gathering in code, not sure why it is not being picked up from persistence.xml :

<property name="hibernate.generate.statistics" value="true" />

Thanks,
Kurt

emmanuel · **Posted:** Tue Feb 27, 2007 6:56 pm

Code:

emmanuel · **Posted:** Tue Feb 27, 2007 6:57 pm

BTW, can you open a Glassfish issue,
They really should delegate getDelegate() to the underlying persistence provider for consistency with Java SE

krawling · **Posted:** Tue Feb 27, 2007 7:21 pm

Emmanuel,

Thanks for the reply. I will look into opening glassfish issue.

Regards,
Kurt