How to monitor c3p0 connections

by

You can monitor your connection pool(s) via JMX. From the documentation:

Configuring and Managing c3p0 via JMX

If JMX libraries and a JMX
MBeanServer are available in your
environment (they are include in JDK
1.5 and above), you can inspect and configure your c3p0 datasources via a
JMX administration tool (such as
jconsole, bundled with jdk 1.5). You
will find that c3p0 registers MBeans
under com.mchange.v2.c3p0, one with
statistics about the library as a
whole (called C3P0Registry), and an
MBean for each PooledDataSource you
deploy. You can view and modify your
DataSource’s configuration properties,
track the activity of Connection,
Statement, and Thread pools, and reset
pools and DataSources via the
PooledDataSource MBean. (You may
wish to view the API docs of
PooledDataSource for
documentation of the available
operations.)

By the way, there seem to be JMX plugins for Nagios, you’re not forced to use a JSP.

More Related Contents:

  1. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  2. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  3. Hibernate Annotations – Which is better, field or property access?
  4. Hibernate JPA Sequence (non-Id)
  5. How to store date/time and timestamps in UTC time zone with JPA and Hibernate
  6. Bypass GeneratedValue in Hibernate (merge data not in db?)
  7. How should equals and hashcode be implemented when using JPA and Hibernate
  8. How does the FetchMode work in Spring Data JPA
  9. Hibernate Union alternatives
  10. Location of hibernate.cfg.xml in project?
  11. Hibernate – Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1
  12. JPA entity without id
  13. Can add extra field(s) to @ManyToMany Hibernate extra table?
  14. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  15. mappedBy reference an unknown target entity property
  16. How to create database schema in hibernate first time and further update it in case of schema modification?
  17. Native query with named parameter fails with “Not all named parameters have been set”
  18. Hibernate persist entity without fetching association object. just by id
  19. HQL Hibernate INNER JOIN
  20. @BatchSize a smart or stupid use?
  21. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  22. Name attribute in @Entity and @Table
  23. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  24. Why should anybody put annotations on the getters or setters when using JPA to map the classes?
  25. Hibernate using JPA (annotated Entities) and liquibase
  26. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  27. JPA: Override Auto generated ID [duplicate]
  28. HQL recursion, how do I do this?
  29. org.dbunit.dataset.NoSuchTableException: Did not find table ‘xxx’ in schema ‘null’
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment