Can I use jmx to see jdbc pool variables/properties in Tomcat 6?

[Charles Richard]

Hi,

I am testing the jdbc pool to replace the c3p0 pool we were using for our
Tomcat connection pool. We are also using Spring 2.0 and Hibernate (and
Tomcat 6).

When I put this in my hibernate-context.xml, our application is using the
jdbc pool and appears to work:

<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
    destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://${db.host}/${db.name}" />
    <property name="username" value="${db.user}" />
    <property name="password" value="${db.pwd}" />
    <property name="initialSize" value="15" />
    <property name="maxActive" value="150" />
    <property name="removeAbandoned" value="true" />
    <property name="removeAbandonedTimeout" value="1800" />
    <property name="logAbandoned" value="true" />
    <property name="jmxEnabled" value="true" />
    <property name="jdbcInterceptors"
value="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReportJmx(threshold=10000)"
/>
</bean>

However, when using jmx locally, I don't see any beans that I can use to
monitor the connections used in the pool. I tried doing as per this article:

http://stackoverflow.com/questions/3865445/cant-see-jmx-entries-in-jconsole-when-using-tomcat-jdbc-connection-pool

This doesn't work for me.

Any suggestions on what I'm missing here?

Thanks,
Charles