How to monitor current Connection Pool Usage in a Corticon 5

Posted by Karthikeyan Bhaskaran on 03-Jan-2014 00:42

Hello Everyone,

Is there any tool / API that can be used to monitor current Connection Pool usage of Corticon 5.3.3 + EDC running on Tomcat?

Thank you.

Posted by mcicel on 03-Jan-2014 07:35

Corticon 5.3.3 is by default using c3p0 connection pooling, which uses JMX for its configuration and monitoring. You can use any JMX administration tool such as jconsole which is included in jdk since version 1.5 (http://docs.oracle.com/javase/6/docs/technotes/guides/management/jconsole.html).

jconsole allows you to connect to local or remote Corticon Server or Corticon Studio processes. When a database connection is created, c3p0 creates a JMX MBean. Bellow is an example of jconsole connected to a Corticon Studio with 3 database connections.

For more information about c3p0 JMX configuration and management see this documentation: http://www.mchange.com/projects/c3p0/index.html#jmx_configuration_and_management

 

Marian

All Replies

Posted by mcicel on 03-Jan-2014 07:35

Corticon 5.3.3 is by default using c3p0 connection pooling, which uses JMX for its configuration and monitoring. You can use any JMX administration tool such as jconsole which is included in jdk since version 1.5 (http://docs.oracle.com/javase/6/docs/technotes/guides/management/jconsole.html).

jconsole allows you to connect to local or remote Corticon Server or Corticon Studio processes. When a database connection is created, c3p0 creates a JMX MBean. Bellow is an example of jconsole connected to a Corticon Studio with 3 database connections.

For more information about c3p0 JMX configuration and management see this documentation: http://www.mchange.com/projects/c3p0/index.html#jmx_configuration_and_management

 

Marian

This thread is closed