[
https://issues.apache.org/jira/browse/DBCP-292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12934701#action_12934701
]
Cyrille Le Clerc commented on DBCP-292:
---------------------------------------
For those who are using Spring, we packaged a JMX enabled extension of DBCP
BasicDataSource at [Google Code - XebiaManagementExtras -
ManagedBasicDataSource|http://code.google.com/p/xebia-france/wiki/ManagedBasicDataSource].
A Spring XML namespace configuration allows a compact datasource declaration
looking like:
{code:xml}
<beans ...>
<!-- MBeanExporter is in charge of registering the DBCP DataSource MBean -->
<context:mbean-export />
<management:dbcp-datasource id="myDataSource">
<management:url value="jdbc:h2:mem:dbcp-test" />
<management:driver-class-name value="org.h2.Driver" />
<management:username value="sa" />
<management:password value="" />
<management:max-active value="10" />
<!-- ... any other useful configuration param -->
</management:dbcp-datasource>
</beans>
{code}
> Adds an mbean for exposing metrics around a BasicDataSource via JMX
> -------------------------------------------------------------------
>
> Key: DBCP-292
> URL: https://issues.apache.org/jira/browse/DBCP-292
> Project: Commons Dbcp
> Issue Type: New Feature
> Affects Versions: 1.2.2
> Reporter: David Horne
> Priority: Minor
> Fix For: 2.0
>
> Attachments: BasicDataSourceMBean.patch
>
>
> The attached patch adds an mbean that exposes the following metrics of a
> BasicDataSource via jmx: numActive, numIdle, maxActive, maxIdle, minIdle &
> maxWait.
> I have put it in a new package: org.apache.commons.dbcp.management but feel
> free to put it in any package you see fit.
> If using Spring the bean can be configured a little something like this:
> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
> ...
> </bean>
> <bean id="dataSourceMBean"
> class="org.apache.commons.dbcp.management.BasicDataSourceMBean">
> <constructor-arg ref="dataSource"/>
> </bean>
> <bean id="mbeanExporter" class="org.springframework.jmx.export.MBeanExporter">
> <property name="beans">
> <map>
> <entry key="DBCP:name=dataSource"
> value-ref="dataSourceMBean"/>
> </map>
> </property>
> </bean>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
