com.p6spy.engine.logging

Class LoggingEventListener

java.lang.Object

com.p6spy.engine.event.JdbcEventListener

com.p6spy.engine.event.SimpleJdbcEventListener

com.p6spy.engine.logging.LoggingEventListener

Direct Known Subclasses:

ErrorLoggingEventListener

public class LoggingEventListener
extends SimpleJdbcEventListener

This event listener is responsible for logging the SQL statements and the execution time

To use a custom implementation for logging, extend this class and add the fully qualified class name of your implementation to src/main/resources/META-INF/services/com.p6spy.engine.logging.LoggingEventListener.

Field Summary

Fields

Modifier and Type	Field and Description
static LoggingEventListener	INSTANCE

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	LoggingEventListener()

Method Summary

Modifier and Type	Method and Description
protected void	logElapsed(Loggable loggable, long timeElapsedNanos, Category category, java.sql.SQLException e)
void	onAfterAnyAddBatch(StatementInformation statementInformation, long timeElapsedNanos, java.sql.SQLException e) This callback method is executed before any Statement.addBatch* method is invoked
void	onAfterAnyExecute(StatementInformation statementInformation, long timeElapsedNanos, java.sql.SQLException e) This callback method is executed after any Statement.execute* method is invoked
void	onAfterCommit(ConnectionInformation connectionInformation, long timeElapsedNanos, java.sql.SQLException e) This callback method is executed after the Connection.commit() method is invoked.
void	onAfterExecuteBatch(StatementInformation statementInformation, long timeElapsedNanos, int[] updateCounts, java.sql.SQLException e) This callback method is executed after the Statement.executeBatch() method is invoked.
void	onAfterGetResultSet(StatementInformation statementInformation, long timeElapsedNanos, java.sql.SQLException e) This callback method is executed after the Statement.getResultSet() method is invoked.
void	onAfterResultSetClose(ResultSetInformation resultSetInformation, java.sql.SQLException e) This callback method is executed after the ResultSet.close() method is invoked.
void	onAfterResultSetGet(ResultSetInformation resultSetInformation, int columnIndex, java.lang.Object value, java.sql.SQLException e) This callback method is executed after any of the ResultSet#get*(int) methods are invoked.
void	onAfterResultSetGet(ResultSetInformation resultSetInformation, java.lang.String columnLabel, java.lang.Object value, java.sql.SQLException e) This callback method is executed after any of the ResultSet#get*(String) methods are invoked.
void	onAfterResultSetNext(ResultSetInformation resultSetInformation, long timeElapsedNanos, boolean hasNext, java.sql.SQLException e) This callback method is executed after the ResultSet.next() method is invoked.
void	onAfterRollback(ConnectionInformation connectionInformation, long timeElapsedNanos, java.sql.SQLException e) This callback method is executed after the Connection.rollback() or the Connection.rollback(Savepoint) method is invoked.
void	onBeforeResultSetNext(ResultSetInformation resultSetInformation) This callback method is executed before the ResultSet.next() method is invoked.

Methods inherited from class com.p6spy.engine.event.SimpleJdbcEventListener

onAfterAddBatch, onAfterAddBatch, onAfterExecute, onAfterExecute, onAfterExecuteQuery, onAfterExecuteQuery, onAfterExecuteUpdate, onAfterExecuteUpdate, onBeforeAddBatch, onBeforeAddBatch, onBeforeAnyAddBatch, onBeforeAnyExecute, onBeforeExecute, onBeforeExecute, onBeforeExecuteBatch, onBeforeExecuteQuery, onBeforeExecuteQuery, onBeforeExecuteUpdate, onBeforeExecuteUpdate

Methods inherited from class com.p6spy.engine.event.JdbcEventListener

onAfterCallableStatementSet, onAfterConnectionClose, onAfterGetConnection, onAfterPreparedStatementSet, onAfterSetAutoCommit, onAfterStatementClose, onBeforeCommit, onBeforeGetConnection, onBeforeRollback, onBeforeSetAutoCommit, onConnectionWrapped

Methods inherited from class java.lang.Object

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

Field Detail

INSTANCE

public static final LoggingEventListener INSTANCE

Constructor Detail

LoggingEventListener

protected LoggingEventListener()

Method Detail

onAfterAnyExecute

public void onAfterAnyExecute(StatementInformation statementInformation,
                              long timeElapsedNanos,
                              java.sql.SQLException e)

Description copied from class: SimpleJdbcEventListener

This callback method is executed after any Statement.execute* method is invoked

Overrides:

onAfterAnyExecute in class SimpleJdbcEventListener

Parameters:

statementInformation - The meta information about the Statement being invoked

timeElapsedNanos - The execution time of the execute call

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterExecuteBatch

public void onAfterExecuteBatch(StatementInformation statementInformation,
                                long timeElapsedNanos,
                                int[] updateCounts,
                                java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after the Statement.executeBatch() method is invoked.

Overrides:

onAfterExecuteBatch in class SimpleJdbcEventListener

Parameters:

statementInformation - The meta information about the Statement being invoked

timeElapsedNanos - The execution time of the execute call

updateCounts - An array of update counts or null if an exception was thrown

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterCommit

public void onAfterCommit(ConnectionInformation connectionInformation,
                          long timeElapsedNanos,
                          java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after the Connection.commit() method is invoked.

Overrides:

onAfterCommit in class JdbcEventListener

Parameters:

connectionInformation - The meta information about the Connection being invoked

timeElapsedNanos - The execution time of the execute call

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterRollback

public void onAfterRollback(ConnectionInformation connectionInformation,
                            long timeElapsedNanos,
                            java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after the Connection.rollback() or the Connection.rollback(Savepoint) method is invoked.

Overrides:

onAfterRollback in class JdbcEventListener

Parameters:

connectionInformation - The meta information about the Connection being invoked

timeElapsedNanos - The execution time of the execute call

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterAnyAddBatch

public void onAfterAnyAddBatch(StatementInformation statementInformation,
                               long timeElapsedNanos,
                               java.sql.SQLException e)

Description copied from class: SimpleJdbcEventListener

This callback method is executed before any Statement.addBatch* method is invoked

Overrides:

onAfterAnyAddBatch in class SimpleJdbcEventListener

Parameters:

statementInformation - The meta information about the Statement being invoked

timeElapsedNanos - The execution time of the execute call

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterGetResultSet

public void onAfterGetResultSet(StatementInformation statementInformation,
                                long timeElapsedNanos,
                                java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after the Statement.getResultSet() method is invoked.

Overrides:

onAfterGetResultSet in class JdbcEventListener

Parameters:

statementInformation - The meta information about the Statement being invoked

timeElapsedNanos - The execution time of the execute call

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterResultSetGet

public void onAfterResultSetGet(ResultSetInformation resultSetInformation,
                                int columnIndex,
                                java.lang.Object value,
                                java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after any of the ResultSet#get*(int) methods are invoked.

Overrides:

onAfterResultSetGet in class JdbcEventListener

Parameters:

resultSetInformation - The meta information about the ResultSet being invoked

columnIndex - the first column is 1, the second is 2, ...

value - the column value; if the value is SQL NULL, the value returned is null

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterResultSetGet

public void onAfterResultSetGet(ResultSetInformation resultSetInformation,
                                java.lang.String columnLabel,
                                java.lang.Object value,
                                java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after any of the ResultSet#get*(String) methods are invoked.

Overrides:

onAfterResultSetGet in class JdbcEventListener

Parameters:

resultSetInformation - The meta information about the ResultSet being invoked

columnLabel - The label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

value - The column value; if the value is SQL NULL, the value returned is null

e - The SQLException which may be triggered by the call (null if there was no exception).

onBeforeResultSetNext

public void onBeforeResultSetNext(ResultSetInformation resultSetInformation)

Description copied from class: JdbcEventListener

This callback method is executed before the ResultSet.next() method is invoked.

Overrides:

onBeforeResultSetNext in class JdbcEventListener

Parameters:

resultSetInformation - The meta information about the ResultSet being invoked

onAfterResultSetNext

public void onAfterResultSetNext(ResultSetInformation resultSetInformation,
                                 long timeElapsedNanos,
                                 boolean hasNext,
                                 java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after the ResultSet.next() method is invoked.

Overrides:

onAfterResultSetNext in class JdbcEventListener

Parameters:

resultSetInformation - The meta information about the ResultSet being invoked

timeElapsedNanos - The execution time of the execute call

hasNext - The return value of ResultSet.next()

e - The SQLException which may be triggered by the call (null if there was no exception).

onAfterResultSetClose

public void onAfterResultSetClose(ResultSetInformation resultSetInformation,
                                  java.sql.SQLException e)

Description copied from class: JdbcEventListener

This callback method is executed after the ResultSet.close() method is invoked.

Overrides:

onAfterResultSetClose in class JdbcEventListener

Parameters:

resultSetInformation - The meta information about the ResultSet being invoked

e - The SQLException which may be triggered by the call (null if there was no exception).

logElapsed

protected void logElapsed(Loggable loggable,
                          long timeElapsedNanos,
                          Category category,
                          java.sql.SQLException e)