LoggingConnection (Maximo API)

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.

See Also:

LoggingStatement, LoggingPreparedStatement, LoggingCallableStatement

Field Summary

Fields
Modifier and Type	Field and Description
`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.

Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Method Summary

All Methods Static Methods Instance Methods Concrete 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()`
`static java.sql.Connection`	`getLoggingConnection(java.sql.Connection con)`
`static java.sql.Connection`	`getLoggingConnection(java.sql.Connection con, LogSQL logger)`
`java.sql.DatabaseMetaData`	`getMetaData()`
`int`	`getNetworkTimeout()`
`java.lang.String`	`getSchema()`
`int`	`getTransactionIsolation()`
`java.util.Map`	`getTypeMap()`
`java.sql.SQLWarning`	`getWarnings()`
`boolean`	`isClosed()`
`boolean`	`isReadOnly()`
`boolean`	`isValid(int timeout)`
`boolean`	`isWrapperFor(java.lang.Class iface)`
`static void`	`log(java.lang.String loggerName, java.lang.Object msg)`
`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`	`setSQLLogger(LogSQL logger)`
`void`	`setTransactionIsolation(int level)`
`void`	`setTypeMap(java.util.Map map)`
`java.lang.Object`	`unwrap(java.lang.Class iface)`

Methods inherited from class java.lang.Object
clone, equals, finalize, 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

Fields inherited from interface java.sql.Connection

Methods inherited from class java.lang.Object

SQLLOG_Execute

SQLLOG_Query

SQLLOG_Result

SQLLOG_OPEN

SQLLOG_CLOSE

SQLLOG_UNSUPPORTED

SQLLOG_PARAMETERS

Method Detail

log

getLoggingConnection

getLoggingConnection

setSQLLogger

clearWarnings

close

commit

createArrayOf

createBlob

createClob

createNClob

createSQLXML

createStatement

createStatement

createStatement

createStruct

getAutoCommit

getCatalog

getClientInfo

getClientInfo

getHoldability

getMetaData

getTransactionIsolation

getTypeMap

getWarnings

isClosed

isReadOnly

isValid

nativeSQL

prepareCall

prepareCall

prepareCall

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

releaseSavepoint

rollback

rollback

setAutoCommit

setCatalog

setClientInfo

setClientInfo

setHoldability

setReadOnly

setSavepoint

setSavepoint

setTransactionIsolation

setTypeMap

isWrapperFor

unwrap

setNetworkTimeout

getNetworkTimeout

setSchema

getSchema

abort