org.javasimon.jdbc.SimonConnection Maven / Gradle / Ivy
The newest version!
package org.javasimon.jdbc;
import org.javasimon.SimonManager;
import org.javasimon.Counter;
import org.javasimon.Split;
import java.util.Map;
import java.sql.*;
/**
* 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, stoping, 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.jdbc.conn, stopwatch) - measure connection life and count
* - commits (
org.javasimon.jdbc.conn.commits, counter) - measure executed commits of all connections
* - rollbacks (
org.javasimon.jdbc.conn.rollbacks, counter) - measure executed rollbacks of all connections
*
*
* @author Radovan Sninsky
* @version $Revision: 304 $ $Date: 2011-04-08 10:39:02 +0200 (Fri, 08 Apr 2011) $
* @see java.sql.Connection
* @since 1.0
*/
public final class SimonConnection implements Connection {
private Connection conn;
private String suffix;
private Split life;
private Counter commits;
private Counter rollbacks;
/**
* Class constructor, initializes Simons (lifespan, active, commits
* and rollbacks) related to DB connection.
*
* @param conn real DB connection
* @param prefix hierarchy prefix for connection Simons
*/
public SimonConnection(Connection conn, String prefix) {
this.conn = conn;
this.suffix = prefix;
commits = SimonManager.getCounter(prefix + ".conn.commits");
rollbacks = SimonManager.getCounter(prefix + ".conn.rollbacks");
life = SimonManager.getStopwatch(prefix + ".conn").start();
}
/**
* Closes real connection, stops lifespan Simon and decrease active Simon.
*
* @throws SQLException if real operation fails
*/
public void close() throws SQLException {
conn.close();
life.stop();
}
/**
* Commits real connection and increase commits Simon.
*
* @throws SQLException if real commit fails
*/
public void commit() throws SQLException {
conn.commit();
commits.increase();
}
/**
* Rollback real connection and increase rollbacks Simon.
*
* @throws SQLException if real operation fails
*/
public void rollback() throws SQLException {
conn.rollback();
rollbacks.increase();
}
/**
* Rollback real connection and increase rollbacks Simon.
*
* @param savepoint the Savepoint object to roll back to
* @throws SQLException if real operation fails
*/
public void rollback(Savepoint savepoint) throws SQLException {
conn.rollback(savepoint);
rollbacks.increase();
}
/**
* Calls real createStatement and wraps returned statement by Simon's statement.
*
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public Statement createStatement() throws SQLException {
return new SimonStatement(this, conn.createStatement(), suffix);
}
/**
* Calls real createStatement and wraps returned statement by Simon's statement.
*
* @param rsType result set type
* @param rsConcurrency result set concurrency
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public Statement createStatement(int rsType, int rsConcurrency) throws SQLException {
return new SimonStatement(this, conn.createStatement(rsType, rsConcurrency), suffix);
}
/**
* Calls real createStatement and wraps returned statement by Simon's statement.
*
* @param rsType result set type
* @param rsConcurrency result set concurrency
* @param rsHoldability result set holdability
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public Statement createStatement(int rsType, int rsConcurrency, int rsHoldability) throws SQLException {
return new SimonStatement(this, conn.createStatement(rsType, rsConcurrency, rsHoldability), suffix);
}
/**
* Calls real prepareStatement and wraps returned statement by Simon's statement.
*
* @param sql SQL statement
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public PreparedStatement prepareStatement(String sql) throws SQLException {
return new SimonPreparedStatement(this, conn.prepareStatement(sql), sql, suffix);
}
/**
* Calls real prepareStatement and wraps returned statement by Simon's statement.
*
* @param sql SQL statement
* @param autoGeneratedKeys auto generated keys
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException {
return new SimonPreparedStatement(this, conn.prepareStatement(sql, autoGeneratedKeys), sql, suffix);
}
/**
* Calls real prepareStatement and wraps returned statement by Simon's statement.
*
* @param sql SQL statement
* @param rsType result set type
* @param rsConcurrency result set concurrency
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public PreparedStatement prepareStatement(String sql, int rsType, int rsConcurrency) throws SQLException {
return new SimonPreparedStatement(this, conn.prepareStatement(sql, rsType, rsConcurrency), sql, suffix);
}
/**
* Calls real prepareStatement and wraps returned statement by Simon's statement.
*
* @param sql SQL statement
* @param rsType result set type
* @param rsConcurrency result set concurrency
* @param rsHoldability result set holdability
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public PreparedStatement prepareStatement(String sql, int rsType, int rsConcurrency, int rsHoldability) throws SQLException {
return new SimonPreparedStatement(this, conn.prepareStatement(sql, rsType, rsConcurrency, rsHoldability), sql, suffix);
}
/**
* Calls real prepareStatement and wraps returned statement by Simon's statement.
*
* @param sql SQL statement
* @param columnIndexes an array of column indexes indicating the columns
* that should be returned from the inserted row or rows
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public PreparedStatement prepareStatement(String sql, int[] columnIndexes) throws SQLException {
return new SimonPreparedStatement(this, conn.prepareStatement(sql, columnIndexes), sql, suffix);
}
/**
* Calls real prepareStatement and wraps returned statement by Simon's statement.
*
* @param sql SQL statement
* @param columnNames an array of column names indicating the columns
* that should be returned from the inserted row or rows
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public PreparedStatement prepareStatement(String sql, String[] columnNames) throws SQLException {
return new SimonPreparedStatement(this, conn.prepareStatement(sql, columnNames), sql, suffix);
}
/**
* Calls real prepareCall and wraps returned statement by Simon's statement.
*
* @param sql an SQL statement, typically a JDBC function call escape string
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public CallableStatement prepareCall(String sql) throws SQLException {
return new SimonCallableStatement(conn, conn.prepareCall(sql), sql, suffix);
}
/**
* Calls real prepareCall and wraps returned statement by Simon's statement.
*
* @param sql an SQL statement, typically a JDBC function call escape string
* @param rsType result set type
* @param rsConcurrency result set concurrency
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public CallableStatement prepareCall(String sql, int rsType, int rsConcurrency) throws SQLException {
return new SimonCallableStatement(conn, conn.prepareCall(sql, rsType, rsConcurrency), sql, suffix);
}
/**
* Calls real prepareCall and wraps returned statement by Simon's statement.
*
* @param sql an SQL statement, typically a JDBC function call escape string
* @param rsType result set type
* @param rsConcurrency result set concurrency
* @param rsHoldability result set holdability
* @return Simon's statement with wraped real statement
* @throws SQLException if real operation fails
*/
public CallableStatement prepareCall(String sql, int rsType, int rsConcurrency, int rsHoldability) throws SQLException {
return new SimonCallableStatement(conn, conn.prepareCall(sql, rsType, rsConcurrency, rsHoldability), sql, suffix);
}
/////////////////// Not interesting methods for monitoring
/**
* {@inheritDoc}
*/
public String nativeSQL(String s) throws SQLException {
return conn.nativeSQL(s);
}
/**
* {@inheritDoc}
*/
public void setAutoCommit(boolean b) throws SQLException {
conn.setAutoCommit(b);
}
/**
* {@inheritDoc}
*/
public boolean getAutoCommit() throws SQLException {
return conn.getAutoCommit();
}
/**
* {@inheritDoc}
*/
public boolean isClosed() throws SQLException {
return conn.isClosed();
}
/**
* {@inheritDoc}
*/
public DatabaseMetaData getMetaData() throws SQLException {
return conn.getMetaData();
}
/**
* {@inheritDoc}
*/
public void setReadOnly(boolean b) throws SQLException {
conn.setReadOnly(b);
}
/**
* {@inheritDoc}
*/
public boolean isReadOnly() throws SQLException {
return conn.isReadOnly();
}
/**
* {@inheritDoc}
*/
public void setCatalog(String s) throws SQLException {
conn.setCatalog(s);
}
/**
* {@inheritDoc}
*/
public String getCatalog() throws SQLException {
return conn.getCatalog();
}
/**
* {@inheritDoc}
*/
public void setTransactionIsolation(int i) throws SQLException {
conn.setTransactionIsolation(i);
}
/**
* {@inheritDoc}
*/
public int getTransactionIsolation() throws SQLException {
return conn.getTransactionIsolation();
}
/**
* {@inheritDoc}
*/
public SQLWarning getWarnings() throws SQLException {
return conn.getWarnings();
}
/**
* {@inheritDoc}
*/
public void clearWarnings() throws SQLException {
conn.clearWarnings();
}
/**
* {@inheritDoc}
*/
public Map> getTypeMap() throws SQLException {
return conn.getTypeMap();
}
/**
* {@inheritDoc}
*/
public void setTypeMap(Map> stringClassMap) throws SQLException {
conn.setTypeMap(stringClassMap);
}
/**
* {@inheritDoc}
*/
public void setHoldability(int i) throws SQLException {
conn.setHoldability(i);
}
/**
* {@inheritDoc}
*/
public int getHoldability() throws SQLException {
return conn.getHoldability();
}
/**
* {@inheritDoc}
*/
public Savepoint setSavepoint() throws SQLException {
return conn.setSavepoint();
}
/**
* {@inheritDoc}
*/
public Savepoint setSavepoint(String s) throws SQLException {
return conn.setSavepoint(s);
}
/**
* {@inheritDoc}
*/
public void releaseSavepoint(Savepoint savepoint) throws SQLException {
conn.releaseSavepoint(savepoint);
}
//////// from JDK 6, JDBC 4
/*
public Clob createClob() throws SQLException {
return conn.createClob();
}
public Blob createBlob() throws SQLException {
return conn.createBlob();
}
public NClob createNClob() throws SQLException {
return conn.createNClob();
}
public SQLXML createSQLXML() throws SQLException {
return conn.createSQLXML();
}
public boolean isValid(int i) throws SQLException {
return conn.isValid(i);
}
public void setClientInfo(String s, String s1) throws SQLClientInfoException {
conn.setClientInfo(s, s1);
}
public void setClientInfo(Properties properties) throws SQLClientInfoException {
conn.setClientInfo(properties);
}
public String getClientInfo(String s) throws SQLException {
return conn.getClientInfo(s);
}
public Properties getClientInfo() throws SQLException {
return conn.getClientInfo();
}
public Array createArrayOf(String s, Object[] objects) throws SQLException {
return conn.createArrayOf(s, objects);
}
public Struct createStruct(String s, Object[] objects) throws SQLException {
return conn.createStruct(s, objects);
}
public T unwrap(Class tClass) throws SQLException {
throw new SQLException("not implemented");
}
public boolean isWrapperFor(Class aClass) throws SQLException {
throw new SQLException("not implemented");
}
*/
}