com.p6spy.engine.spy.appender

Class BatchFileLogger

java.lang.Object

com.p6spy.engine.spy.appender.FormattedLogger

com.p6spy.engine.spy.appender.StdoutLogger

com.p6spy.engine.spy.appender.FileLogger

com.p6spy.engine.spy.appender.BatchFileLogger

All Implemented Interfaces:

P6Logger

public class BatchFileLogger
extends FileLogger

SQL batch file logger Private: (?) No Appender that writes a trace of JDBC activity into an SQL batch file that can be later "replayed" using a generic SQL client.

modify the spy.properties file to make p6spy use this appender by setting appender=com.p6spy.engine.spy.appender.BatchFileLogger.

Here's how it works for me: logfile = spy.sql The appender writes the text of SQL statements as well as commit and rollback commands to the specified file, each on a new line. For prepared statements the effective text resulting from substitution of parameter signs with their values is written. Other event categories are logged as SQL comments ("-- " followed by the category name). Exceptions and text are silently discarded. All SQL statements except the last one will have a delimiter character ';' appended to them. This batch format works well with WinSQL. The format is hardcoded, so if you want to make it configurable you'll have to patch my patch or write your own :)

Field Summary

Fields

Modifier and Type	Field and Description
static char	BATCH_SEPARATOR

Fields inherited from class com.p6spy.engine.spy.appender.FormattedLogger

strategy

Constructor Summary

Constructors

Constructor and Description
BatchFileLogger()

Method Summary

Modifier and Type	Method and Description
void	logException(java.lang.Exception e) Logs the stacktrace of the exception.
void	logSQL(int connectionId, java.lang.String now, long elapsed, Category category, java.lang.String prepared, java.lang.String sql, java.lang.String url) Logs the SQL.
void	logText(java.lang.String text) Logs the text.

Methods inherited from class com.p6spy.engine.spy.appender.FileLogger

getStream, setLogfile

Methods inherited from class com.p6spy.engine.spy.appender.StdoutLogger

isCategoryEnabled

Methods inherited from class com.p6spy.engine.spy.appender.FormattedLogger

setStrategy

Methods inherited from class java.lang.Object

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

Field Detail

BATCH_SEPARATOR

public static final char BATCH_SEPARATOR

See Also:

Constant Field Values

Constructor Detail

BatchFileLogger

public BatchFileLogger()

Method Detail

logException

public void logException(java.lang.Exception e)

Description copied from interface: P6Logger

Logs the stacktrace of the exception.

Specified by:

logException in interface P6Logger

Overrides:

logException in class StdoutLogger

Parameters:

e - exception holding the stacktrace to be logged.

logSQL

public void logSQL(int connectionId,
                   java.lang.String now,
                   long elapsed,
                   Category category,
                   java.lang.String prepared,
                   java.lang.String sql,
                   java.lang.String url)

Description copied from interface: P6Logger

Logs the SQL.

Specified by:

logSQL in interface P6Logger

Overrides:

logSQL in class FormattedLogger

Parameters:

connectionId - connection identifier.

now - current time.

category - the category to be used for logging.

prepared - the prepared statement to be logged.

sql - the SQL to be logged.

url - the database url where the sql statement executed

logText

public void logText(java.lang.String text)

Description copied from interface: P6Logger

Logs the text.

Specified by:

logText in interface P6Logger

Overrides:

logText in class StdoutLogger

Parameters:

text - to be logged