Empty Hibernate Monitor TAB

[Kirk M.]

Hello,

I am trying to use the tool and I have done what is reported as prerequisites :

1) I have hibernate.generate_statistics = true in my persistence.xml (see below my hibernateSessionFactory bean too)

2) I have declared the MBean in my persistence.xml :

<bean id="jmxExporter" class="org.springframework.jmx.export.MBeanExporter">
        <property name="beans">
            <map>
                <entry key="Hibernate:application=Statistics" value-ref="hibernateStatisticsBean"/>
            </map>
        </property>
    </bean>

    <bean id="hibernateStatisticsBean" class="org.hibernate.jmx.StatisticsService">
        <property name="statisticsEnabled" value="true"/>
        <property name="sessionFactory">
            <!-- Uncomment the following when using Hibernate directly -->
            <ref local="hibernateSessionFactory"/>
        </property>
    </bean>

Where in the same file my hibernateSessionFactoryBean is declared like :

<bean id="hibernateSessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
          p:dataSource-ref="DS">
        <property name="mappingDirectoryLocations">
            <list>
                <value>WEB-INF/conf/hibernate</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9iDialect</prop>
                <prop key="hibernate.jdbc.batch_size">30</prop>
                <prop key="hibernate.transaction.factory_class">org.springframework.orm.hibernate3.SpringTransactionFactory</prop>
                <prop key="hibernate.connection.release_mode">auto</prop>
                <prop key="hibernate.cache.provider_class">net.sf.ehcache.hibernate.SingletonEhCacheProvider</prop>
                <prop key="hibernate.cache.region.factory_class">net.sf.ehcache.hibernate.EhCacheRegionFactory</prop>
                <prop key="net.sf.ehcache.configurationResourceName">ehcache.xml</prop>
                <prop key="hibernate.cache.use_second_level_cache">true</prop>
                <prop key="hibernate.cache.use_query_cache">true</prop>
                <prop key="hibernate.cache.region_prefix"></prop>
                <prop key="hibernate.cache.use_structured_entries">true</prop>
                <prop key="hibernate.order_updates">true</prop>
                <prop key="hibernate.show_sql">false</prop>
                <prop key="hibernate.use_sql_comments">false</prop>
                <prop key="hibernate.format_sql">true</prop>
                <!-- stats -->
                <prop key="hibernate.generate_statistics">true</prop>
            </props>
        </property>
    </bean>

3) I execute the jar file like this:

java -jar hibernate-jconsole-1.0.7.jar -J-Dhibernate.classpath=/Developer/java/repository/org/hibernate/hibernate/3.2.1.ga/hibernate-3.2.1.ga.jar -J-Dhibernate.mbean=Hibernate:application=Statistics

I do see the Hibernate MBean in the MBeans Tab, but no matter what I do, the Tab "Hibernate Monitor" does not display any info, never.

I have tried various things but no luck. Can you please advise?

[Renato]

Hi, I have a similar problem, in my case I am using Hibernate 3.3.2 in JBoss 5.1. All numeric statistics are generated correctly and displayed without problems in the graphic monitor, but the String[] attributes not showed (getQueries, getSecondLevelCacheRegionNames, getCollectionRoleNames, getEntityNames), because this the result table is always empty.

The Hibernate MBean object have all numeric attributes populated, but the array attributes are showed in red with "unavaliable".

I implemented my own class StatisticService and registered properly. In debug mode, I realized that the String[] methods never are called, but the statistics lists are in the object with all informations, including the String arrays.