Hibernate version:2.1.4

Name and version of the database you are using:MySql 4.+

Hi

I am using Tomcat/Hibernate/MySQL. I am trying to expose HibernateService through JMX.

How can I acquire SessionFactory from HibernateService so that I can create Sessions from it.

Also do I have to restart HibernateService for changes like enable show_sql trace etc. to take effect? If yes, isn't that cumbersome as the whole point behind management is lost. Also what happens to my active clients when the hibernate service is in the process of restarting?

This is urgent and I have been struggling to get this working for a while. Any help would be appreciated.

Thanks,
-Nilesh