SimonConnection (Java Simon 4.1.4 API)

java.lang.Object
- org.javasimon.jdbc4.SimonConnection

All Implemented Interfaces:

AutoCloseable, Connection, Wrapper
```
public final class SimonConnection
extends Object
implements Connection
```
Class implements Simon JDBC proxy connection.
Every method of this connection is implemented as call of real connection method. Several methods have added work with Simons (starting, stopping, etc.) for monitoring purposes.

From all statement-return-methods (createStatement(*), prepareStatement(*), prepareCall(*)) connection returns own implementation of statement classes. Those classes are also proxies and provides additional Simons for monitoring features of JDBC driver.
Monitoring connection ensure following Simons:
- lifespan (org.javasimon.jdbc4.conn, stopwatch) - measure connection life and count
- commits (org.javasimon.jdbc4.conn.commits, counter) - measure executed commits of all connections
- rollbacks (org.javasimon.jdbc4.conn.rollbacks, counter) - measure executed rollbacks of all connections
Since:

2.4

Author:

Radovan Sninsky

See Also:
Connection

Field Summary
- 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
`SimonConnection(Connection conn, String prefix)` Class constructor, initializes Simons (lifespan, active, commits and rollbacks) related to the DB connection.

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`abort(Executor executor)`
`void`	`clearWarnings()`
`void`	`close()` Closes the real connection, stops lifespan Simon and decreases the active Simon.
`void`	`commit()` Commits the real connection and increases the commits Simon.
`Array`	`createArrayOf(String s, Object[] objects)`
`Blob`	`createBlob()`
`Clob`	`createClob()`
`NClob`	`createNClob()`
`SQLXML`	`createSQLXML()`
`Statement`	`createStatement()` Calls the real createStatement and wraps the returned statement by Simon's statement.
`Statement`	`createStatement(int rsType, int rsConcurrency)` Calls real createStatement and wraps returned statement by Simon's statement.
`Statement`	`createStatement(int rsType, int rsConcurrency, int rsHoldability)` Calls real createStatement and wraps returned statement by Simon's statement.
`Struct`	`createStruct(String s, Object[] objects)`
`boolean`	`getAutoCommit()`
`String`	`getCatalog()`
`Properties`	`getClientInfo()`
`String`	`getClientInfo(String s)`
`int`	`getHoldability()`
`DatabaseMetaData`	`getMetaData()`
`int`	`getNetworkTimeout()`
`String`	`getSchema()`
`int`	`getTransactionIsolation()`
`Map<String,Class<?>>`	`getTypeMap()`
`SQLWarning`	`getWarnings()`
`boolean`	`isClosed()`
`boolean`	`isReadOnly()`
`boolean`	`isValid(int i)`
`boolean`	`isWrapperFor(Class<?> iface)`
`String`	`nativeSQL(String s)`
`CallableStatement`	`prepareCall(String sql)` Calls real prepareCall and wraps returned statement by Simon's statement.
`CallableStatement`	`prepareCall(String sql, int rsType, int rsConcurrency)` Calls real prepareCall and wraps returned statement by Simon's statement.
`CallableStatement`	`prepareCall(String sql, int rsType, int rsConcurrency, int rsHoldability)` Calls real prepareCall and wraps returned statement by Simon's statement.
`PreparedStatement`	`prepareStatement(String sql)` Calls real prepareStatement and wraps returned statement by Simon's statement.
`PreparedStatement`	`prepareStatement(String sql, int autoGeneratedKeys)` Calls real prepareStatement and wraps returned statement by Simon's statement.
`PreparedStatement`	`prepareStatement(String sql, int[] columnIndexes)` Calls real prepareStatement and wraps returned statement by Simon's statement.
`PreparedStatement`	`prepareStatement(String sql, int rsType, int rsConcurrency)` Calls real prepareStatement and wraps returned statement by Simon's statement.
`PreparedStatement`	`prepareStatement(String sql, int rsType, int rsConcurrency, int rsHoldability)` Calls real prepareStatement and wraps returned statement by Simon's statement.
`PreparedStatement`	`prepareStatement(String sql, String[] columnNames)` Calls real prepareStatement and wraps returned statement by Simon's statement.
`void`	`releaseSavepoint(Savepoint savepoint)`
`void`	`rollback()` Rollback the real connection and increase the rollbacks Simon.
`void`	`rollback(Savepoint savepoint)` Rollbacks the real connection and increases the rollbacks Simon.
`void`	`setAutoCommit(boolean b)`
`void`	`setCatalog(String s)`
`void`	`setClientInfo(Properties properties)`
`void`	`setClientInfo(String s, String s1)`
`void`	`setHoldability(int i)`
`void`	`setNetworkTimeout(Executor executor, int milliseconds)`
`void`	`setReadOnly(boolean b)`
`Savepoint`	`setSavepoint()`
`Savepoint`	`setSavepoint(String s)`
`void`	`setSchema(String schema)`
`void`	`setTransactionIsolation(int i)`
`void`	`setTypeMap(Map<String,Class<?>> stringClassMap)`
`<T> T`	`unwrap(Class<T> iface)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - SimonConnection
```
public SimonConnection(Connection conn,
               String prefix)
```
    Class constructor, initializes Simons (lifespan, active, commits and rollbacks) related to the DB connection.
    
    Parameters:
    conn - real DB connection
    prefix - hierarchy prefix for connection Simons
- Method Detail
  - close
```
public void close()
           throws SQLException
```
    Closes the real connection, stops lifespan Simon and decreases the active Simon.
    
    Specified by:
    
    close in interface AutoCloseable
    
    Specified by:
    
    close in interface Connection
    
    Throws:
    
    SQLException - if real operation fails
  - commit
```
public void commit()
            throws SQLException
```
    Commits the real connection and increases the commits Simon.
    
    Specified by:
    
    commit in interface Connection
    
    Throws:
    
    SQLException - if real commit fails
  - rollback
```
public void rollback()
              throws SQLException
```
    Rollback the real connection and increase the rollbacks Simon.
    
    Specified by:
    
    rollback in interface Connection
    
    Throws:
    
    SQLException - if real operation fails
  - rollback
```
public void rollback(Savepoint savepoint)
              throws SQLException
```
    Rollbacks the real connection and increases the rollbacks Simon.
    
    Specified by:
    
    rollback in interface Connection
    
    Parameters:
    savepoint - the Savepoint object to roll back to
    
    Throws:
    
    SQLException - if real operation fails
  - createStatement
```
public Statement createStatement()
                          throws SQLException
```
    Calls the real createStatement and wraps the returned statement by Simon's statement.
    
    Specified by:
    
    createStatement in interface Connection
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - createStatement
```
public Statement createStatement(int rsType,
                        int rsConcurrency)
                          throws SQLException
```
    Calls real createStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    createStatement in interface Connection
    
    Parameters:
    rsType - result set type
    rsConcurrency - result set concurrency
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - createStatement
```
public Statement createStatement(int rsType,
                        int rsConcurrency,
                        int rsHoldability)
                          throws SQLException
```
    Calls real createStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    createStatement in interface Connection
    
    Parameters:
    rsType - result set type
    rsConcurrency - result set concurrency
    rsHoldability - result set holdability
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql)
                                   throws SQLException
```
    Calls real prepareStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareStatement in interface Connection
    
    Parameters:
    sql - SQL statement
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                 int autoGeneratedKeys)
                                   throws SQLException
```
    Calls real prepareStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareStatement in interface Connection
    
    Parameters:
    sql - SQL statement
    autoGeneratedKeys - auto generated keys
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                 int rsType,
                                 int rsConcurrency)
                                   throws SQLException
```
    Calls real prepareStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareStatement in interface Connection
    
    Parameters:
    sql - SQL statement
    rsType - result set type
    rsConcurrency - result set concurrency
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                 int rsType,
                                 int rsConcurrency,
                                 int rsHoldability)
                                   throws SQLException
```
    Calls real prepareStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareStatement in interface Connection
    
    Parameters:
    sql - SQL statement
    rsType - result set type
    rsConcurrency - result set concurrency
    rsHoldability - result set holdability
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                 int[] columnIndexes)
                                   throws SQLException
```
    Calls real prepareStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareStatement in interface Connection
    
    Parameters:
    sql - SQL statement
    columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row or rows
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareStatement
```
public PreparedStatement prepareStatement(String sql,
                                 String[] columnNames)
                                   throws SQLException
```
    Calls real prepareStatement and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareStatement in interface Connection
    
    Parameters:
    sql - SQL statement
    columnNames - an array of column names indicating the columns that should be returned from the inserted row or rows
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareCall
```
public CallableStatement prepareCall(String sql)
                              throws SQLException
```
    Calls real prepareCall and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareCall in interface Connection
    
    Parameters:
    sql - an SQL statement, typically a JDBC function call escape string
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareCall
```
public CallableStatement prepareCall(String sql,
                            int rsType,
                            int rsConcurrency)
                              throws SQLException
```
    Calls real prepareCall and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareCall in interface Connection
    
    Parameters:
    sql - an SQL statement, typically a JDBC function call escape string
    rsType - result set type
    rsConcurrency - result set concurrency
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - prepareCall
```
public CallableStatement prepareCall(String sql,
                            int rsType,
                            int rsConcurrency,
                            int rsHoldability)
                              throws SQLException
```
    Calls real prepareCall and wraps returned statement by Simon's statement.
    
    Specified by:
    
    prepareCall in interface Connection
    
    Parameters:
    sql - an SQL statement, typically a JDBC function call escape string
    rsType - result set type
    rsConcurrency - result set concurrency
    rsHoldability - result set holdability
    
    Returns:
    Simon's statement with wrapped real statement
    
    Throws:
    
    SQLException - if real operation fails
  - nativeSQL
```
public String nativeSQL(String s)
                 throws SQLException
```
    Specified by:
    
    nativeSQL in interface Connection
    
    Throws:
    
    SQLException
  - setAutoCommit
```
public void setAutoCommit(boolean b)
                   throws SQLException
```
    Specified by:
    
    setAutoCommit in interface Connection
    
    Throws:
    
    SQLException
  - getAutoCommit
```
public boolean getAutoCommit()
                      throws SQLException
```
    Specified by:
    
    getAutoCommit in interface Connection
    
    Throws:
    
    SQLException
  - isClosed
```
public boolean isClosed()
                 throws SQLException
```
    Specified by:
    
    isClosed in interface Connection
    
    Throws:
    
    SQLException
  - getMetaData
```
public DatabaseMetaData getMetaData()
                             throws SQLException
```
    Specified by:
    
    getMetaData in interface Connection
    
    Throws:
    
    SQLException
  - setReadOnly
```
public void setReadOnly(boolean b)
                 throws SQLException
```
    Specified by:
    
    setReadOnly in interface Connection
    
    Throws:
    
    SQLException
  - isReadOnly
```
public boolean isReadOnly()
                   throws SQLException
```
    Specified by:
    
    isReadOnly in interface Connection
    
    Throws:
    
    SQLException
  - setCatalog
```
public void setCatalog(String s)
                throws SQLException
```
    Specified by:
    
    setCatalog in interface Connection
    
    Throws:
    
    SQLException
  - getCatalog
```
public String getCatalog()
                  throws SQLException
```
    Specified by:
    
    getCatalog in interface Connection
    
    Throws:
    
    SQLException
  - setTransactionIsolation
```
public void setTransactionIsolation(int i)
                             throws SQLException
```
    Specified by:
    
    setTransactionIsolation in interface Connection
    
    Throws:
    
    SQLException
  - getTransactionIsolation
```
public int getTransactionIsolation()
                            throws SQLException
```
    Specified by:
    
    getTransactionIsolation in interface Connection
    
    Throws:
    
    SQLException
  - getWarnings
```
public SQLWarning getWarnings()
                       throws SQLException
```
    Specified by:
    
    getWarnings in interface Connection
    
    Throws:
    
    SQLException
  - clearWarnings
```
public void clearWarnings()
                   throws SQLException
```
    Specified by:
    
    clearWarnings in interface Connection
    
    Throws:
    
    SQLException
  - getTypeMap
```
public Map<String,Class<?>> getTypeMap()
                                throws SQLException
```
    Specified by:
    
    getTypeMap in interface Connection
    
    Throws:
    
    SQLException
  - setTypeMap
```
public void setTypeMap(Map<String,Class<?>> stringClassMap)
                throws SQLException
```
    Specified by:
    
    setTypeMap in interface Connection
    
    Throws:
    
    SQLException
  - setHoldability
```
public void setHoldability(int i)
                    throws SQLException
```
    Specified by:
    
    setHoldability in interface Connection
    
    Throws:
    
    SQLException
  - getHoldability
```
public int getHoldability()
                   throws SQLException
```
    Specified by:
    
    getHoldability in interface Connection
    
    Throws:
    
    SQLException
  - setSavepoint
```
public Savepoint setSavepoint()
                       throws SQLException
```
    Specified by:
    
    setSavepoint in interface Connection
    
    Throws:
    
    SQLException
  - setSavepoint
```
public Savepoint setSavepoint(String s)
                       throws SQLException
```
    Specified by:
    
    setSavepoint in interface Connection
    
    Throws:
    
    SQLException
  - releaseSavepoint
```
public void releaseSavepoint(Savepoint savepoint)
                      throws SQLException
```
    Specified by:
    
    releaseSavepoint in interface Connection
    
    Throws:
    
    SQLException
  - createClob
```
public Clob createClob()
                throws SQLException
```
    Specified by:
    
    createClob in interface Connection
    
    Throws:
    
    SQLException
  - createBlob
```
public Blob createBlob()
                throws SQLException
```
    Specified by:
    
    createBlob in interface Connection
    
    Throws:
    
    SQLException
  - createNClob
```
public NClob createNClob()
                  throws SQLException
```
    Specified by:
    
    createNClob in interface Connection
    
    Throws:
    
    SQLException
  - createSQLXML
```
public SQLXML createSQLXML()
                    throws SQLException
```
    Specified by:
    
    createSQLXML in interface Connection
    
    Throws:
    
    SQLException
  - isValid
```
public boolean isValid(int i)
                throws SQLException
```
    Specified by:
    
    isValid in interface Connection
    
    Throws:
    
    SQLException
  - setClientInfo
```
public void setClientInfo(String s,
                 String s1)
                   throws SQLClientInfoException
```
    Specified by:
    
    setClientInfo in interface Connection
    
    Throws:
    
    SQLClientInfoException
  - setClientInfo
```
public void setClientInfo(Properties properties)
                   throws SQLClientInfoException
```
    Specified by:
    
    setClientInfo in interface Connection
    
    Throws:
    
    SQLClientInfoException
  - getClientInfo
```
public String getClientInfo(String s)
                     throws SQLException
```
    Specified by:
    
    getClientInfo in interface Connection
    
    Throws:
    
    SQLException
  - getClientInfo
```
public Properties getClientInfo()
                         throws SQLException
```
    Specified by:
    
    getClientInfo in interface Connection
    
    Throws:
    
    SQLException
  - createArrayOf
```
public Array createArrayOf(String s,
                  Object[] objects)
                    throws SQLException
```
    Specified by:
    
    createArrayOf in interface Connection
    
    Throws:
    
    SQLException
  - createStruct
```
public Struct createStruct(String s,
                  Object[] objects)
                    throws SQLException
```
    Specified by:
    
    createStruct in interface Connection
    
    Throws:
    
    SQLException
  - setSchema
```
public void setSchema(String schema)
               throws SQLException
```
    Specified by:
    
    setSchema in interface Connection
    
    Throws:
    
    SQLException
  - getSchema
```
public String getSchema()
                 throws SQLException
```
    Specified by:
    
    getSchema in interface Connection
    
    Throws:
    
    SQLException
  - abort
```
public void abort(Executor executor)
           throws SQLException
```
    Specified by:
    
    abort in interface Connection
    
    Throws:
    
    SQLException
  - setNetworkTimeout
```
public void setNetworkTimeout(Executor executor,
                     int milliseconds)
                       throws SQLException
```
    Specified by:
    
    setNetworkTimeout in interface Connection
    
    Throws:
    
    SQLException
  - getNetworkTimeout
```
public int getNetworkTimeout()
                      throws SQLException
```
    Specified by:
    
    getNetworkTimeout in interface Connection
    
    Throws:
    
    SQLException
  - unwrap
```
public <T> T unwrap(Class<T> iface)
         throws SQLException
```
    Specified by:
    
    unwrap in interface Wrapper
    
    Throws:
    
    SQLException
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Specified by:
    
    isWrapperFor in interface Wrapper
    
    Throws:
    
    SQLException

Class SimonConnection

Field Summary

Fields inherited from interface java.sql.Connection

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

SimonConnection

Method Detail

close

commit

rollback

rollback

createStatement

createStatement

createStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareStatement

prepareCall

prepareCall

prepareCall

nativeSQL

setAutoCommit

getAutoCommit

isClosed

getMetaData

setReadOnly

isReadOnly

setCatalog

getCatalog

setTransactionIsolation

getTransactionIsolation

getWarnings

clearWarnings

getTypeMap

setTypeMap

setHoldability

getHoldability

setSavepoint

setSavepoint

releaseSavepoint

createClob

createBlob

createNClob

createSQLXML

isValid

setClientInfo

setClientInfo

getClientInfo

getClientInfo

createArrayOf

createStruct

setSchema

getSchema

abort

setNetworkTimeout

getNetworkTimeout

unwrap

isWrapperFor