Monitoring JDBC Performance with JDbMonitor
Monitoring JDBC Performance with JDbMonitor
Join the DZone community and get the full member experience.
Join For FreexMatters delivers integration-driven collaboration that relays data between systems, while engaging the right people to proactively resolve issues. Read the Monitoring in a Connected Enterprise whitepaper and learn about 3 tools for resolving incidents quickly.
There may be some situations where we need to monitor our JDBC calls. There are few mechanisms available for monitoring JDBC calls. I have tried JDbMonitor in some of my projects because it is easy to use and remove without any code change.
In the current version(1.1) it supports
- Statemt
- PreparedStatement
Lets have a look on how to configure JDbMonitor to monitor our JDBC calls in step by step.
package com.kani;
import java.sql.Connection;
import java.sql.DriverManager;
public class ConnectionManager {
private static final String HOST="localhost";
private static final String DBNAME="test_db";
private static final String USERNAME="root";
private static final String PASSWORD="";
public static Connection getNewDBConnection() {
Connection conn = null;
try {
Class.forName("com.jdbmonitor.MonitorDriver");
conn = DriverManager.getConnection("jdbc:mysql://"+HOST+"/"+DBNAME, USERNAME, PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}
it should show all the supported JDBC operations if it is connected successfully.
Note : If you are using a property file you can remove JDBmonitor without any code change. And it is possible to monitor underlying Hibernate JDBC operations easily.
Discovering, responding to, and resolving incidents is a complex endeavor. Read this narrative to learn how you can do it quickly and effectively by connecting AppDynamics, Moogsoft and xMatters to create a monitoring toolchain.
Like This Article? Read More From DZone
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}