at.rseiler.spbee.demo

Class SpLogger

java.lang.Object

at.rseiler.spbee.demo.SpLogger

public final class SpLogger
extends Object

Logs the stored procedure execution durations.

If the stored procedure call exceed 200 ms (default value) then the call is logged as WARNING like: n ms sp_name[sp_arguments]#sp_call_count. Example: 17 ms sp_get_user[3]#1

The default value can be changed with the interceptor.splogger.slow.query.duration property in /spbee.properties.

The logger name is: spLogger If TRACE is enabled then every stored procedure call is logged.

Author:

Reinhard Seiler <rseiler.developer@gmail.com>

Method Summary

Modifier and Type	Method and Description
static void	after(Object id, String spName, Object... arguments) Logs the execution duration of the stored procedure call.
static Object	before(String spName, Object... arguments) Logs the invocation of the stored procedure call.

Methods inherited from class java.lang.Object

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

Method Detail

before

public static Object before(String spName,
                            Object... arguments)

Logs the invocation of the stored procedure call. This method will be called before the invocation of the stored procedure.

Parameters:

spName - the name of the stored procedure

arguments - the arguments of the stored procedure

Returns:

the ID object to identify the call in the after(java.lang.Object, java.lang.String, java.lang.Object...) method

after

public static void after(Object id,
                         String spName,
                         Object... arguments)

Logs the execution duration of the stored procedure call. This method will be called after the invocation of the stored procedure.

Parameters:

id - the ID object

spName - the name of the stored procedure

arguments - the arguments of the stored procedure