HibernateJMX

Here are some instructions for making the Hibernate Statistics JMX MBean available from AppFuse:

The example below has been tested with MX4J 3.0.1, JDK 1.5 Update 2 and Tomcat 5.5.7.

Note: Using JDK 1.5 with the JAVA_OPTS and JConsole is optional, most app servers already have a MBean server, and MC4J (http://mc4j.sourceforge.net/) provides a JMX Console for most of them.

Inside the tomcat startup script, ensure these JAVA_OPTS are set:

JAVA_OPTS=" -Dcom.sun.management.jmxremote.port=9002 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -Djava.awt.headless=true"

(Note: Under Windows, I started tomcat5w.exe and set the above properties in the Java tab, in the textfield entitled 'Java Options').

Then, if you are using Spring, add this to your applicationContext-hibernate.xml file:

    <bean id="jmxExporter"
        class="org.springframework.jmx.export.MBeanExporter">
        <property name="beans">
            <map>
                <entry key="Hibernate:type=statistics">
                    <ref local="statisticsBean" />
                </entry>
            </map>
        </property>
    </bean> 

    <bean id="statisticsBean" class="org.hibernate.jmx.StatisticsService">
        <property name="statisticsEnabled">
            <value>true</value>
        </property>
        <property name="sessionFactory"><ref local="sessionFactory"/></property>
    </bean>

and then set the hibernate.generate_statistics property in your applicationContext-hibernate.xml file:

	<prop key="hibernate.generate_statistics">true</prop>

When you browse the MBeans (using JConsole.exe - which lives in the bin dir of your JDK 1.5 distribution), you should see Hibernate, if you double click on that node, you should see the Statistics Bean.

Tomcat 5 already contains the MX4J libraries and your AppFuse project should already have the Hibernate libraries in the runtime classpath. Below are a couple of screenshots.

If you are not using Spring, inside StartupListener.java (inside contextInitialized method) add:

After starting up AppFuse, you should be able to attach to the server using JConsole (port 9002, as in the config above). From there, you should see the Hibernate MBean where you can view the statistics that have been collected.

How useful is this? Not sure yet! -:)

hibernatestats2.png		27366 bytes
hibernatestats1.png		26678 bytes