Class SqlStatistic

java.lang.Object

java.lang.Thread

clazzfish.core.util.ShutdownHook

clazzfish.monitor.AbstractMonitor

clazzfish.jdbc.AbstractStatistic

clazzfish.jdbc.SqlStatistic

All Implemented Interfaces:

Shutdownable, AbstractStatisticMBean, SqlStatisticMBean, AbstractMonitorMBean, 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

Method Summary

Modifier and Type	Method	Description
URI	exportCSV()	Exports the SQL statistic as CSV.
URI	getExportURI()	Returns the URI where the statistic should be exported to.
static SqlStatistic	getInstance()
CsvXPorter	getXPorter()
void	importCSV(URI csvURI)	Imports the statistics from the given URI.
void	reset()	To start a new statistic call this method.
void	setXPorter(CsvXPorter xPorter)
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.
String	toString()	As the toString implementation the name of the registered MBean is used.

Methods inherited from class clazzfish.jdbc.AbstractStatistic

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

Methods inherited from class clazzfish.monitor.AbstractMonitor

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

Methods inherited from class clazzfish.core.util.ShutdownHook

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.core.util.Shutdownable

addMeAsShutdownHook, isShutdownHook, removeMeAsShutdownHook

Method Details

getInstance

public static SqlStatistic getInstance()

getXPorter

public CsvXPorter getXPorter()

setXPorter

public void setXPorter(CsvXPorter xPorter)

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

exportCSV

public URI exportCSV()
              throws IOException

Exports the SQL statistic as CSV.

Overrides:

exportCSV in class AbstractMonitor

Returns:

the URI where the statistic is exported

Throws:

IOException - in case of IO problems

Since:

3.0

getExportURI

public URI getExportURI()

Description copied from interface: SqlStatisticMBean

Returns the URI where the statistic should be exported to.

Specified by:

getExportURI in interface SqlStatisticMBean

Returns:

export URI

importCSV

public void importCSV(URI csvURI)

Imports the statistics from the given URI.

Parameters:

csvURI - URI where the statistic should be imported from

toString

public String toString()

Description copied from class: AbstractMonitor

As the toString implementation the name of the registered MBean is used.

Overrides:

toString in class AbstractMonitor

Returns:

the registered MBean name