org.tranql.connector.jdbc
Class ConnectionWrapper

java.lang.Object
  extended by org.tranql.connector.jdbc.ConnectionWrapper
All Implemented Interfaces:
Connection, Wrapper

public class ConnectionWrapper
extends Object
implements Connection

ConnectionWrapper provides additional connection level capabilities on top of a regular connection. The current set of capabilities include: StatementCaching IsolationLevel caching

Author:
hogstrom

Field Summary
 
Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
 
Constructor Summary
ConnectionWrapper(Connection connection)
          Constructs a new ConnectionWrapper object.
ConnectionWrapper(Connection connection, int cacheSize)
          Creates a connection wrapper that adds the ability to cache prepared statements.
 
Method Summary
 void clearWarnings()
           
 void close()
           
 void commit()
           
 Array createArrayOf(String typeName, Object[] elements)
           
 Blob createBlob()
           
 Clob createClob()
           
 NClob createNClob()
           
 SQLXML createSQLXML()
           
 Statement createStatement()
          All statements after this comment are delegated to the actual connection object.
 Statement createStatement(int arg0, int arg1)
           
 Statement createStatement(int arg0, int arg1, int arg2)
           
 Struct createStruct(String typeName, Object[] attributes)
           
 boolean getAutoCommit()
           
 String getCatalog()
           
 Properties getClientInfo()
           
 String getClientInfo(String s)
           
 int getHoldability()
           
 int getMaxCacheSize()
           
 DatabaseMetaData getMetaData()
           
 int getTransactionIsolation()
           
 Map<String,Class<?>> getTypeMap()
           
 SQLWarning getWarnings()
           
 boolean isClosed()
           
 boolean isReadOnly()
           
 boolean isValid(int timeout)
           
 boolean isWrapperFor(Class<?> iface)
           
 String nativeSQL(String arg0)
           
 CallableStatement prepareCall(String arg0)
           
 CallableStatement prepareCall(String arg0, int arg1, int arg2)
           
 CallableStatement prepareCall(String arg0, int arg1, int arg2, int arg3)
           
 PreparedStatement prepareStatement(String sql)
           
 PreparedStatement prepareStatement(String sql, int autoGeneratedKeys)
           
 PreparedStatement prepareStatement(String sql, int[] columnIndexes)
           
 PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
           
 PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
           
 PreparedStatement prepareStatement(String sql, String[] columnNames)
           
 void releaseSavepoint(Savepoint arg0)
           
 void returnStatementToCache(PreparedStatementWrapper psw)
           
 void rollback()
           
 void rollback(Savepoint arg0)
           
 void setAutoCommit(boolean arg0)
           
 void setCatalog(String arg0)
           
 void setClientInfo(Properties props)
           
 void setClientInfo(String name, String value)
           
 void setHoldability(int arg0)
           
 void setReadOnly(boolean arg0)
           
 Savepoint setSavepoint()
           
 Savepoint setSavepoint(String arg0)
           
 void setTransactionIsolation(int isolationLevel)
           
 void setTypeMap(Map<String,Class<?>> map)
           
<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

ConnectionWrapper

public ConnectionWrapper(Connection connection)
Constructs a new ConnectionWrapper object. This constructor creates a connection wrapper that does not provide a prepared statement cache.

Parameters:
connection -

ConnectionWrapper

public ConnectionWrapper(Connection connection,
                         int cacheSize)
Creates a connection wrapper that adds the ability to cache prepared statements.

Parameters:
connection -
cacheSize -
Method Detail

prepareStatement

public PreparedStatement prepareStatement(String sql)
                                   throws SQLException
Specified by:
prepareStatement in interface Connection
Parameters:
sql -
Returns:
Throws:
SQLException

prepareStatement

public PreparedStatement prepareStatement(String sql,
                                          int resultSetType,
                                          int resultSetConcurrency)
                                   throws SQLException
Specified by:
prepareStatement in interface Connection
Parameters:
sql -
resultSetType -
resultSetConcurrency -
Returns:
PreparedStatementWrapper
Throws:
SQLException

prepareStatement

public PreparedStatement prepareStatement(String sql,
                                          int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws SQLException
Specified by:
prepareStatement in interface Connection
Parameters:
sql -
resultSetType -
resultSetConcurrency -
resultSetHoldability -
Returns:
PreparedStatementWrapper
Throws:
SQLException

prepareStatement

public PreparedStatement prepareStatement(String sql,
                                          int autoGeneratedKeys)
                                   throws SQLException
Specified by:
prepareStatement in interface Connection
Parameters:
sql -
autoGeneratedKeys -
Returns:
PreparedStatementWrapper
Throws:
SQLException

prepareStatement

public PreparedStatement prepareStatement(String sql,
                                          int[] columnIndexes)
                                   throws SQLException
Specified by:
prepareStatement in interface Connection
Parameters:
sql -
columnIndexes -
Returns:
PreparedStatementWrapper
Throws:
SQLException

prepareStatement

public PreparedStatement prepareStatement(String sql,
                                          String[] columnNames)
                                   throws SQLException
Specified by:
prepareStatement in interface Connection
Throws:
SQLException

returnStatementToCache

public void returnStatementToCache(PreparedStatementWrapper psw)

setTransactionIsolation

public void setTransactionIsolation(int isolationLevel)
                             throws SQLException
Specified by:
setTransactionIsolation in interface Connection
Throws:
SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws SQLException
Specified by:
getTransactionIsolation in interface Connection
Throws:
SQLException

getMaxCacheSize

public int getMaxCacheSize()
Returns:
An integer that indicates the maximum number of statements that will be cached.

createStatement

public Statement createStatement()
                          throws SQLException
All statements after this comment are delegated to the actual connection object.

Specified by:
createStatement in interface Connection
Throws:
SQLException

prepareCall

public CallableStatement prepareCall(String arg0)
                              throws SQLException
Specified by:
prepareCall in interface Connection
Throws:
SQLException

nativeSQL

public String nativeSQL(String arg0)
                 throws SQLException
Specified by:
nativeSQL in interface Connection
Throws:
SQLException

setAutoCommit

public void setAutoCommit(boolean arg0)
                   throws SQLException
Specified by:
setAutoCommit in interface Connection
Throws:
SQLException

getAutoCommit

public boolean getAutoCommit()
                      throws SQLException
Specified by:
getAutoCommit in interface Connection
Throws:
SQLException

commit

public void commit()
            throws SQLException
Specified by:
commit in interface Connection
Throws:
SQLException

rollback

public void rollback()
              throws SQLException
Specified by:
rollback in interface Connection
Throws:
SQLException

close

public void close()
           throws SQLException
Specified by:
close 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 arg0)
                 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 arg0)
                throws SQLException
Specified by:
setCatalog in interface Connection
Throws:
SQLException

getCatalog

public String getCatalog()
                  throws SQLException
Specified by:
getCatalog 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

createStatement

public Statement createStatement(int arg0,
                                 int arg1)
                          throws SQLException
Specified by:
createStatement in interface Connection
Throws:
SQLException

prepareCall

public CallableStatement prepareCall(String arg0,
                                     int arg1,
                                     int arg2)
                              throws SQLException
Specified by:
prepareCall 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<?>> map)
                throws SQLException
Specified by:
setTypeMap in interface Connection
Throws:
SQLException

setHoldability

public void setHoldability(int arg0)
                    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 arg0)
                       throws SQLException
Specified by:
setSavepoint in interface Connection
Throws:
SQLException

rollback

public void rollback(Savepoint arg0)
              throws SQLException
Specified by:
rollback in interface Connection
Throws:
SQLException

releaseSavepoint

public void releaseSavepoint(Savepoint arg0)
                      throws SQLException
Specified by:
releaseSavepoint in interface Connection
Throws:
SQLException

createStatement

public Statement createStatement(int arg0,
                                 int arg1,
                                 int arg2)
                          throws SQLException
Specified by:
createStatement in interface Connection
Throws:
SQLException

prepareCall

public CallableStatement prepareCall(String arg0,
                                     int arg1,
                                     int arg2,
                                     int arg3)
                              throws SQLException
Specified by:
prepareCall 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 timeout)
                throws SQLException
Specified by:
isValid in interface Connection
Throws:
SQLException

setClientInfo

public void setClientInfo(String name,
                          String value)
                   throws SQLClientInfoException
Specified by:
setClientInfo in interface Connection
Throws:
SQLClientInfoException

setClientInfo

public void setClientInfo(Properties props)
                   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 typeName,
                           Object[] elements)
                    throws SQLException
Specified by:
createArrayOf in interface Connection
Throws:
SQLException

createStruct

public Struct createStruct(String typeName,
                           Object[] attributes)
                    throws SQLException
Specified by:
createStruct in interface Connection
Throws:
SQLException

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
Specified by:
isWrapperFor in interface Wrapper
Throws:
SQLException

unwrap

public <T> T unwrap(Class<T> iface)
         throws SQLException
Specified by:
unwrap in interface Wrapper
Throws:
SQLException


Copyright © 2004-2012 Tranql project committers. All Rights Reserved.