com.ora.jsp.sql
Class ConnectionWrapper

java.lang.Object
  extended bycom.ora.jsp.sql.ConnectionWrapper
All Implemented Interfaces:
java.sql.Connection

public class ConnectionWrapper
extends java.lang.Object
implements java.sql.Connection

This class is a wrapper around a Connection, overriding the close method to just inform the DataSourceWrapper that it's available for reuse again, and the isClosed method to return the state of the wrapper instead of the Connection.

Version:
2.0
Author:
Hans Bergsten, Gefion software

Field Summary
private  DataSourceWrapper dsw
           
private  boolean isClosed
           
private  java.sql.Connection realConn
           
 
Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
 
Constructor Summary
ConnectionWrapper(java.sql.Connection realConn, DataSourceWrapper dsw)
           
 
Method Summary
 void clearWarnings()
           
 void close()
          Inform the DataSourceWrapper that the ConnectionWrapper is closed.
 void commit()
          Calls the corresponding method on the wrapped Connection.
 java.sql.Statement createStatement()
          Calls the corresponding method on the wrapped Connection.
 java.sql.Statement createStatement(int resultSetType, int resultSetConcurrency)
          Calls the corresponding method on the wrapped Connection.
 java.sql.Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
          Calls the corresponding method on the wrapped Connection.
 boolean getAutoCommit()
          Calls the corresponding method on the wrapped Connection.
 java.lang.String getCatalog()
          Calls the corresponding method on the wrapped Connection.
 int getHoldability()
          Calls the corresponding method on the wrapped Connection.
 java.sql.DatabaseMetaData getMetaData()
          Calls the corresponding method on the wrapped Connection.
 int getTransactionIsolation()
          Calls the corresponding method on the wrapped Connection.
 java.util.Map getTypeMap()
          Calls the corresponding method on the wrapped Connection.
 java.sql.SQLWarning getWarnings()
          Calls the corresponding method on the wrapped Connection.
 boolean isClosed()
          Returns true if the ConnectionWrapper is closed, false otherwise.
 boolean isReadOnly()
          Calls the corresponding method on the wrapped Connection.
 java.lang.String nativeSQL(java.lang.String sql)
          Calls the corresponding method on the wrapped Connection.
 java.sql.CallableStatement prepareCall(java.lang.String sql)
          Calls the corresponding method on the wrapped Connection.
 java.sql.CallableStatement prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency)
          Calls the corresponding method on the wrapped Connection.
 java.sql.CallableStatement prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
          Calls the corresponding method on the wrapped Connection.
 java.sql.PreparedStatement prepareStatement(java.lang.String sql)
          Calls the corresponding method on the wrapped Connection.
 java.sql.PreparedStatement prepareStatement(java.lang.String sql, int autoGeneratedKeys)
          Calls the corresponding method on the wrapped Connection.
 java.sql.PreparedStatement prepareStatement(java.lang.String sql, int[] columnIndexes)
          Calls the corresponding method on the wrapped Connection.
 java.sql.PreparedStatement prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
          Calls the corresponding method on the wrapped Connection.
 java.sql.PreparedStatement prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
          Calls the corresponding method on the wrapped Connection.
 java.sql.PreparedStatement prepareStatement(java.lang.String sql, java.lang.String[] columnNames)
          Calls the corresponding method on the wrapped Connection.
 void releaseSavepoint(java.sql.Savepoint savepoint)
          Calls the corresponding method on the wrapped Connection.
 void rollback()
          Calls the corresponding method on the wrapped Connection.
 void rollback(java.sql.Savepoint savepoint)
          Calls the corresponding method on the wrapped Connection.
 void setAutoCommit(boolean autoCommit)
          Calls the corresponding method on the wrapped Connection.
 void setCatalog(java.lang.String catalog)
          Calls the corresponding method on the wrapped Connection.
 void setHoldability(int holdability)
          Calls the corresponding method on the wrapped Connection.
 void setReadOnly(boolean readOnly)
          Calls the corresponding method on the wrapped Connection.
 java.sql.Savepoint setSavepoint()
          Calls the corresponding method on the wrapped Connection.
 java.sql.Savepoint setSavepoint(java.lang.String name)
          Calls the corresponding method on the wrapped Connection.
 void setTransactionIsolation(int level)
          Calls the corresponding method on the wrapped Connection.
 void setTypeMap(java.util.Map map)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

realConn

private java.sql.Connection realConn

dsw

private DataSourceWrapper dsw

isClosed

private boolean isClosed
Constructor Detail

ConnectionWrapper

public ConnectionWrapper(java.sql.Connection realConn,
                         DataSourceWrapper dsw)
Method Detail

close

public void close()
           throws java.sql.SQLException
Inform the DataSourceWrapper that the ConnectionWrapper is closed.

Specified by:
close in interface java.sql.Connection
Throws:
java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException
Returns true if the ConnectionWrapper is closed, false otherwise.

Specified by:
isClosed in interface java.sql.Connection
Throws:
java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
Specified by:
clearWarnings in interface java.sql.Connection
Throws:
java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
commit in interface java.sql.Connection
Throws:
java.sql.SQLException

createStatement

public java.sql.Statement createStatement()
                                   throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
createStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency)
                                   throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
createStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
createStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getAutoCommit in interface java.sql.Connection
Throws:
java.sql.SQLException

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getCatalog in interface java.sql.Connection
Throws:
java.sql.SQLException

getHoldability

public int getHoldability()
                   throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getHoldability in interface java.sql.Connection
Throws:
java.sql.SQLException

getMetaData

public java.sql.DatabaseMetaData getMetaData()
                                      throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getMetaData in interface java.sql.Connection
Throws:
java.sql.SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getTransactionIsolation in interface java.sql.Connection
Throws:
java.sql.SQLException

getTypeMap

public java.util.Map getTypeMap()
                         throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getTypeMap in interface java.sql.Connection
Throws:
java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
getWarnings in interface java.sql.Connection
Throws:
java.sql.SQLException

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
isReadOnly in interface java.sql.Connection
Throws:
java.sql.SQLException

nativeSQL

public java.lang.String nativeSQL(java.lang.String sql)
                           throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
nativeSQL in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql)
                                       throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareCall in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency)
                                       throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareCall in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency,
                                              int resultSetHoldability)
                                       throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareCall in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int autoGeneratedKeys)
                                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int[] columnIndexes)
                                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   java.lang.String[] columnNames)
                                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency)
                                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency,
                                                   int resultSetHoldability)
                                            throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
prepareStatement in interface java.sql.Connection
Throws:
java.sql.SQLException

releaseSavepoint

public void releaseSavepoint(java.sql.Savepoint savepoint)
                      throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
releaseSavepoint in interface java.sql.Connection
Throws:
java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
rollback in interface java.sql.Connection
Throws:
java.sql.SQLException

rollback

public void rollback(java.sql.Savepoint savepoint)
              throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
rollback in interface java.sql.Connection
Throws:
java.sql.SQLException

setAutoCommit

public void setAutoCommit(boolean autoCommit)
                   throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setAutoCommit in interface java.sql.Connection
Throws:
java.sql.SQLException

setCatalog

public void setCatalog(java.lang.String catalog)
                throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setCatalog in interface java.sql.Connection
Throws:
java.sql.SQLException

setHoldability

public void setHoldability(int holdability)
                    throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setHoldability in interface java.sql.Connection
Throws:
java.sql.SQLException

setReadOnly

public void setReadOnly(boolean readOnly)
                 throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setReadOnly in interface java.sql.Connection
Throws:
java.sql.SQLException

setSavepoint

public java.sql.Savepoint setSavepoint()
                                throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setSavepoint in interface java.sql.Connection
Throws:
java.sql.SQLException

setSavepoint

public java.sql.Savepoint setSavepoint(java.lang.String name)
                                throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setSavepoint in interface java.sql.Connection
Throws:
java.sql.SQLException

setTransactionIsolation

public void setTransactionIsolation(int level)
                             throws java.sql.SQLException
Calls the corresponding method on the wrapped Connection.

Specified by:
setTransactionIsolation in interface java.sql.Connection
Throws:
java.sql.SQLException

setTypeMap

public void setTypeMap(java.util.Map map)
                throws java.sql.SQLException
Specified by:
setTypeMap in interface java.sql.Connection
Throws:
java.sql.SQLException