I am using an Oracle connection pool by using the following Spring configuration for my datasource:
<bean id="dataSource" class="oracle.jdbc.pool.OracleDataSource">
<property name="connectionCachingEnabled" value="true" />
<property name="URL" value="myUrl" />
<property name="user" value="myUserName" />
<property name="password" value="myPassword" />
<property name="connectionCacheProperties">
<util:properties>
<prop key="InitialLimit">5</prop>
<prop key="MinLimit">5</prop>
<prop key="MaxLimit">30</prop>
<prop key="MaxStatementsLimit">20</prop>
</util:properties>
</property>
</bean>
I would like to expose the statistics of this pool via JMX so that I can monitor the pool to see how many connections are in the pool, how many are busy, etc.
I am connecting to an Oracle 10g server with the oracle 11.2.0.3.0 jdbc driver.
How do I do this?