package nl.astraeus.jdbc; import java.sql.*; import java.util.Map; import java.util.Properties; import java.util.concurrent.Executor; /** * User: riennentjes * Date: Jul 10, 2008 * Time: 8:12:34 PM */ public class ConnectionLogger implements Connection { private Connection connection; private long milli; private long nano; private String lastSql; public ConnectionLogger(Connection connection) { this.connection = connection; this.lastSql = ""; } private void clearTime() { milli = System.currentTimeMillis(); nano = System.nanoTime(); } private void log(String sql) { long m = System.currentTimeMillis() - milli; long n = System.nanoTime() - nano; JdbcLogger.log(QueryType.UNKNOWN, sql, m, n); } public void commit() throws SQLException { clearTime(); connection.commit(); log("commit"); } public void rollback() throws SQLException { clearTime(); connection.rollback(); log("rollback"); } public void close() throws SQLException { clearTime(); connection.close(); log("close"); } public PreparedStatement prepareStatement(String sql) throws SQLException { lastSql = sql; return new PreparedStatementLogger(connection, sql); } public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException { lastSql = sql; return new PreparedStatementLogger(connection, sql, resultSetType, resultSetConcurrency); } public PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException { lastSql = sql; return new PreparedStatementLogger(connection, sql, autoGeneratedKeys); } public PreparedStatement prepareStatement(String sql, int columnIndexes[]) throws SQLException { lastSql = sql; return new PreparedStatementLogger(connection, sql, columnIndexes); } public PreparedStatement prepareStatement(String sql, String columnNames[]) throws SQLException { lastSql = sql; return new PreparedStatementLogger(connection, sql, columnNames); } public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException { lastSql = sql; return new PreparedStatementLogger(connection, sql, resultSetType, resultSetConcurrency); } public Statement createStatement() throws SQLException { return connection.createStatement(); } public CallableStatement prepareCall(String sql) throws SQLException { lastSql = sql; return connection.prepareCall(sql); } public String nativeSQL(String sql) throws SQLException { lastSql = sql; return connection.nativeSQL(sql); } public void setAutoCommit(boolean autoCommit) throws SQLException { connection.setAutoCommit(autoCommit); } public boolean getAutoCommit() throws SQLException { return connection.getAutoCommit(); } public boolean isClosed() throws SQLException { return connection.isClosed(); } public DatabaseMetaData getMetaData() throws SQLException { return connection.getMetaData(); } public void setReadOnly(boolean readOnly) throws SQLException { connection.setReadOnly(readOnly); } public boolean isReadOnly() throws SQLException { return connection.isReadOnly(); } public void setCatalog(String catalog) throws SQLException { connection.setCatalog(catalog); } public String getCatalog() throws SQLException { return connection.getCatalog(); } public void setTransactionIsolation(int level) throws SQLException { connection.setTransactionIsolation(level); } public int getTransactionIsolation() throws SQLException { return connection.getTransactionIsolation(); } public SQLWarning getWarnings() throws SQLException { return connection.getWarnings(); } public void clearWarnings() throws SQLException { connection.clearWarnings(); } public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException { return connection.createStatement(resultSetType, resultSetConcurrency); } public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException { lastSql = sql; return connection.prepareCall(sql, resultSetType, resultSetConcurrency); } public Map<String, Class<?>> getTypeMap() throws SQLException { return connection.getTypeMap(); } public void setTypeMap(Map<String, Class<?>> map) throws SQLException { connection.setTypeMap(map); } public void setHoldability(int holdability) throws SQLException { connection.setHoldability(holdability); } public int getHoldability() throws SQLException { return connection.getHoldability(); } public Savepoint setSavepoint() throws SQLException { return connection.setSavepoint(); } public Savepoint setSavepoint(String name) throws SQLException { return connection.setSavepoint(name); } public void rollback(Savepoint savepoint) throws SQLException { connection.rollback(); } public void releaseSavepoint(Savepoint savepoint) throws SQLException { connection.releaseSavepoint(savepoint); } public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException { return connection.createStatement(resultSetType, resultSetConcurrency, resultSetHoldability); } public CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException { lastSql = sql; return connection.prepareCall(sql, resultSetType, resultSetConcurrency, resultSetHoldability); } public Clob createClob() throws SQLException { return connection.createClob(); } public Blob createBlob() throws SQLException { return connection.createBlob(); } public NClob createNClob() throws SQLException { return connection.createNClob(); } public SQLXML createSQLXML() throws SQLException { return connection.createSQLXML(); } public boolean isValid(int timeout) throws SQLException { return connection.isValid(timeout); } public void setClientInfo(String name, String value) throws SQLClientInfoException { connection.setClientInfo(name, value); } public void setClientInfo(Properties properties) throws SQLClientInfoException { connection.setClientInfo(properties); } public String getClientInfo(String name) throws SQLException { return connection.getClientInfo(name); } public Properties getClientInfo() throws SQLException { return connection.getClientInfo(); } public Array createArrayOf(String typeName, Object[] elements) throws SQLException { return connection.createArrayOf(typeName, elements); } public Struct createStruct(String typeName, Object[] attributes) throws SQLException { return connection.createStruct(typeName, attributes); } @Override public void setSchema(String schema) throws SQLException { connection.setSchema(schema); } @Override public String getSchema() throws SQLException { return connection.getSchema(); } @Override public void abort(Executor executor) throws SQLException { connection.abort(executor); } @Override public void setNetworkTimeout(Executor executor, int milliseconds) throws SQLException { connection.setNetworkTimeout(executor, milliseconds); } @Override public int getNetworkTimeout() throws SQLException { return connection.getNetworkTimeout(); } public <T> T unwrap(Class<T> iface) throws SQLException { return connection.unwrap(iface); } public boolean isWrapperFor(Class<?> iface) throws SQLException { return connection.isWrapperFor(iface); } }