com.ibm.tivoli.maximo.dbmanage.connection

Class LoggingConnection

java.lang.Object

com.ibm.tivoli.maximo.dbmanage.connection.LoggingConnection

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.Connection, java.sql.Wrapper

public class LoggingConnection
extends java.lang.Object
implements java.sql.Connection

This class wraps around a connection object so that we can log the SQL and the result of executing that SQL. The Logging*Statement classes are used to log SQL executed from Statements created from the connection. Logging:
SQLlog.execute - passes the SQL statement about to be executed.
SQLlog.query - passes the SQL before querying.
SQLlog.result - message is TRUE, FALSE, or a count of the # of rows affected. SQLlog.unsupported - warning given with the name of the method not supported.

Author:

John Neville

See Also:

LoggingStatement, LoggingPreparedStatement, LoggingCallableStatement

Field Summary

Fields

Modifier and Type	Field and Description
static org.apache.log4j.Logger	sqlExecuteLogger
static java.lang.String	SQLLOG_CLOSE Used when the connection is closed.
static java.lang.String	SQLLOG_Execute Used to log executed statement, meaning everything but select statements.
static java.lang.String	SQLLOG_OPEN Used when the connection is opened.
static java.lang.String	SQLLOG_PARAMETERS Used to log parameters used in the following SQL statement.
static java.lang.String	SQLLOG_Query Used to log a query.
static java.lang.String	SQLLOG_Result Used to log the result of a SQL statement execution, including queries.
static java.lang.String	SQLLOG_UNSUPPORTED Used to log unsupported operations.
static org.apache.log4j.Logger	sqlQueryLogger
static org.apache.log4j.Logger	sqlResultLogger

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

Constructors

Constructor and Description
LoggingConnection(java.sql.Connection con) Constructor takes a connection & logger.

Method Summary

Methods

Modifier and Type	Method and Description
void	abort(java.util.concurrent.Executor executor)
void	clearWarnings()
void	close()
void	commit()
java.sql.Array	createArrayOf(java.lang.String typeName, java.lang.Object[] elements)
java.sql.Blob	createBlob()
java.sql.Clob	createClob()
java.sql.NClob	createNClob()
java.sql.SQLXML	createSQLXML()
java.sql.Statement	createStatement()
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.Struct	createStruct(java.lang.String typeName, java.lang.Object[] attributes)
boolean	getAutoCommit()
java.lang.String	getCatalog()
java.util.Properties	getClientInfo()
java.lang.String	getClientInfo(java.lang.String name)
int	getHoldability()
java.sql.DatabaseMetaData	getMetaData()
int	getNetworkTimeout()
java.lang.String	getSchema()
int	getTransactionIsolation()
java.util.Map<java.lang.String,java.lang.Class<?>>	getTypeMap()
java.sql.SQLWarning	getWarnings()
boolean	isClosed()
boolean	isReadOnly()
boolean	isValid(int timeout)
boolean	isWrapperFor(java.lang.Class<?> iface)
java.lang.String	nativeSQL(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int autoGeneratedKeys)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int[] columnIndexes)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, java.lang.String[] columnNames)
void	releaseSavepoint(java.sql.Savepoint savepoint)
void	rollback()
void	rollback(java.sql.Savepoint savepoint)
void	setAutoCommit(boolean autoCommit)
void	setCatalog(java.lang.String catalog)
void	setClientInfo(java.util.Properties properties)
void	setClientInfo(java.lang.String name, java.lang.String value)
void	setHoldability(int holdability)
void	setNetworkTimeout(java.util.concurrent.Executor executor, int milliseconds)
void	setReadOnly(boolean readOnly)
java.sql.Savepoint	setSavepoint()
java.sql.Savepoint	setSavepoint(java.lang.String name)
void	setSchema(java.lang.String schema)
void	setTransactionIsolation(int level)
void	setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
<T> T	unwrap(java.lang.Class<T> iface)

Methods inherited from class java.lang.Object

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

Field Detail

SQLLOG_Execute

public static final java.lang.String SQLLOG_Execute

Used to log executed statement, meaning everything but select statements.

See Also:

Constant Field Values

SQLLOG_Query

public static final java.lang.String SQLLOG_Query

Used to log a query.

See Also:

Constant Field Values

SQLLOG_Result

public static final java.lang.String SQLLOG_Result

Used to log the result of a SQL statement execution, including queries. Message object maybe TRUE, FALSE, or a count of the number or rows affected.

See Also:

Constant Field Values

SQLLOG_OPEN

public static final java.lang.String SQLLOG_OPEN

Used when the connection is opened.

See Also:

Constant Field Values

SQLLOG_CLOSE

public static final java.lang.String SQLLOG_CLOSE

Used when the connection is closed.

See Also:

Constant Field Values

SQLLOG_UNSUPPORTED

public static final java.lang.String SQLLOG_UNSUPPORTED

Used to log unsupported operations.

See Also:

Constant Field Values

SQLLOG_PARAMETERS

public static final java.lang.String SQLLOG_PARAMETERS

Used to log parameters used in the following SQL statement. Parameter is a List