Class SqlStatistic

java.lang.Object

java.lang.Thread

clazzfish.monitor.util.Shutdowner

clazzfish.monitor.AbstractMonitor

clazzfish.jdbc.AbstractStatistic

clazzfish.jdbc.SqlStatistic

All Implemented Interfaces:

AbstractStatisticMBean, SqlStatisticMBean, AbstractMonitorMBean, Shutdownable, Runnable

public class SqlStatistic
extends AbstractStatistic
implements SqlStatisticMBean

This class monitors and measures SQL statements.

Since:

0.9

Author:

oliver

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Thread

Thread.Builder, Thread.State, Thread.UncaughtExceptionHandler

Field Summary

Fields inherited from class java.lang.Thread

MAX_PRIORITY, MIN_PRIORITY, NORM_PRIORITY

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SqlStatistic()

Method Summary

Modifier and Type	Method	Description
static void	addAsShutdownHook()	You can register the instance as shutdown hook.
static SqlStatistic	getInstance()	Gets the single instance of SqlStatistic.
static void	registerAsMBean(String name)	With this method you can register the monitor with your own name.
void	reset()	To start a new statistic call this method.
static ProfileMonitor	start(String sql)	Start the monitor for the given SQL statement.
static void	stop(ProfileMonitor mon, String command)	Stops the given 'mon' and logs the given command with the needed time if debug is enabled.
static void	stop(ProfileMonitor mon, String command, Object returnValue)	Stops the given 'mon' and logs the given command with the needed time if debug is enabled.

Methods inherited from class clazzfish.jdbc.AbstractStatistic

dumpMe, dumpMe, getMaxAvg, getMaxAvgLabel, getMaxAvgStatistic, getMaxHits, getMaxHitsLabel, getMaxHitsStatistic, getMaxMax, getMaxMaxLabel, getMaxMaxStatistic, getMaxSize, getMaxTotal, getMaxTotalLabel, getMaxTotalStatistic, getMonitor, getMonitors, getRootMonitor, getSortedMonitors, getStatistics, logMe, resetRootMonitor, setMaxSize, startProfileMonitorFor

Methods inherited from class clazzfish.monitor.AbstractMonitor

copyResource, dump, dump, dumpArray, dumpArray, dumpHeadline, dumpMe, getDumpDir, isMBean, registerMeAsMBean, registerMeAsMBean, registerMeAsMBean, run, toString, toStringArray, unregisterMeAsMBean

Methods inherited from class clazzfish.monitor.util.Shutdowner

addMeAsShutdownHook, isShutdownHook, removeMeAsShutdownHook

Methods inherited from class java.lang.Thread

activeCount, checkAccess, clone, currentThread, dumpStack, enumerate, getAllStackTraces, getContextClassLoader, getDefaultUncaughtExceptionHandler, getId, getName, getPriority, getStackTrace, getState, getThreadGroup, getUncaughtExceptionHandler, holdsLock, interrupt, interrupted, isAlive, isDaemon, isInterrupted, isVirtual, join, join, join, join, ofPlatform, ofVirtual, onSpinWait, setContextClassLoader, setDaemon, setDefaultUncaughtExceptionHandler, setName, setPriority, setUncaughtExceptionHandler, sleep, sleep, sleep, start, startVirtualThread, stop, threadId, yield

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface clazzfish.jdbc.AbstractStatisticMBean

getMaxAvg, getMaxAvgLabel, getMaxAvgStatistic, getMaxHits, getMaxHitsLabel, getMaxHitsStatistic, getMaxMax, getMaxMaxLabel, getMaxMaxStatistic, getMaxSize, getMaxTotal, getMaxTotalLabel, getMaxTotalStatistic, getStatistics, setMaxSize

Methods inherited from interface clazzfish.monitor.util.Shutdownable

addMeAsShutdownHook, isShutdownHook, removeMeAsShutdownHook

Constructor Details

SqlStatistic

protected SqlStatistic()

Method Details

getInstance

public static SqlStatistic getInstance()

Gets the single instance of SqlStatistic.

Returns:

single instance of SqlStatistic

reset

public void reset()

To start a new statistic call this method. In contradiction to AbstractStatistic.reset() old ProfileMonitors will removed.

Specified by:

reset in interface AbstractStatisticMBean

Overrides:

reset in class AbstractStatistic

start

public static ProfileMonitor start(String sql)

Start the monitor for the given SQL statement.

Parameters:

sql - the SQL statement to be monitored

Returns:

the started profile monitor

stop

public static void stop(ProfileMonitor mon,
 String command)

Stops the given 'mon' and logs the given command with the needed time if debug is enabled.

Parameters:

mon - the mon

command - the command

stop

public static void stop(ProfileMonitor mon,
 String command,
 Object returnValue)

Stops the given 'mon' and logs the given command with the needed time if debug is enabled.

Parameters:

mon - the monitor

command - the SQL command

returnValue - the monitored return value

addAsShutdownHook

public static void addAsShutdownHook()

You can register the instance as shutdown hook. If the VM is terminated the profile values are logged and dumped to a CSV file in the tmp directory.

registerAsMBean

public static void registerAsMBean(String name)

With this method you can register the monitor with your own name. This is e.g. useful if you have an application server with several applications.

You can only register the monitor only once. If you want to register it with another name you have to first unregister it.

Parameters:

name - the MBean name (e.g. "my.class.Monitor")