src/jdbc/JdbcSqlConnectionWrapper.java

   1 package csql.jdbc;
   2 import java.sql.Connection;
   3 import java.sql.SQLException;
   4 import java.sql.SQLWarning;
   5 import java.sql.DatabaseMetaData;
   6 import java.sql.Savepoint;
   7 import java.sql.Statement;
   8 import java.sql.PreparedStatement;
   9 import java.sql.CallableStatement;
  10 import java.lang.String;
  11 import java.util.LinkedList;
  12 import java.util.ListIterator;
  13 import java.util.Map;
  14 import java.util.Properties;
  15 import java.sql.Clob;
  16 import java.sql.NClob;
  17 import java.sql.Blob;
  18 import java.sql.SQLXML;
  19 import java.sql.Struct;
  20 import java.sql.Array;
  21
  22 public class JdbcSqlConnectionWrapper extends JSqlError implements Connection, JSqlErrorType
  23 {
  24     private Connection actualCon = null;
  25     private JdbcSqlPooledConnection poolcon = null;
  26     boolean isClosed=false;
  27     public JdbcSqlConnectionWrapper( JdbcSqlPooledConnection cpc,JdbcSqlConnection csqlc)
  28     {
  29         this.poolcon = cpc ;
  30         this.actualCon = csqlc ;
  31         isClosed=false;
  32     }
  33     static JdbcSqlConnectionWrapper getInstance(JdbcSqlPooledConnection cpc,JdbcSqlConnection phyCon)
  34     {
  35         return new JdbcSqlConnectionWrapper(cpc, phyCon);
  36     }
  37
  38     public void close() throws SQLException
  39     {
  40         if(isClosed) return;
  41         isClosed = true;
  42         this.poolcon.eventListentionMethod(isClosed,null);
  43     }
  44
  45     public void commit() throws SQLException
  46     {
  47           this.actualCon.commit();
  48     }
  49
  50     public Statement createStatement() throws SQLException
  51     {
  52           return this.actualCon.createStatement();
  53     }
  54     public boolean getAutoCommit() throws SQLException
  55     {
  56           return this.actualCon.getAutoCommit();
  57     }
  58
  59     public int getTransactionIsolation() throws SQLException
  60     {
  61
  62           return this.actualCon.getTransactionIsolation();
  63     }
  64
  65     public boolean isClosed() throws SQLException
  66     {
  67         return this.actualCon.isClosed();
  68     }
  69
  70     public String nativeSQL (String query) throws SQLException
  71     {
  72         return query;
  73     }
  74
  75     public PreparedStatement prepareStatement(String query) throws SQLException
  76     {
  77               return this.actualCon.prepareStatement(query);
  78     }
  79
  80     public void rollback() throws SQLException
  81     {
  82             this.actualCon.rollback();
  83     }
  84
  85     public void setAutoCommit(boolean aCommit) throws SQLException
  86     {
  87             this.actualCon.setAutoCommit(aCommit);
  88     }
  89
  90     public void setTransactionIsolation(int level) throws SQLException
  91     {
  92         this.actualCon.setTransactionIsolation(level);
  93     }
  94
  95 /*    public java.sql.Statement createAutoStatement() throws SQLException
  96     {
  97         throw getException(CSQL_NOT_SUPPORTED);
  98     }
  99 */
 100
 101     //Unsupported Methods
 102     public void clearWarnings() throws SQLException
 103     {
 104         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::clearWarnings called");
 105
 106         throw getException(CSQL_NOT_SUPPORTED);
 107     }
 108     public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException
 109     {
 110         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createStatement(int, int) called");
 111         throw getException(CSQL_NOT_SUPPORTED);
 112     }
 113     public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
 114     {
 115         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createStatement(int, int, int) called");
 116         throw getException(CSQL_NOT_SUPPORTED);
 117     }
 118     public String getCatalog() throws SQLException
 119     {
 120         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::getCatalog called");
 121         throw getException(CSQL_NOT_SUPPORTED);
 122     }
 123     public int getHoldability() throws SQLException
 124     {
 125         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::getHoldability called");
 126         throw getException(CSQL_NOT_SUPPORTED);
 127     }
 128     public DatabaseMetaData getMetaData() throws SQLException
 129     {
 130         return this.actualCon.getMetaData();
 131     }
 132     public Map getTypeMap() throws SQLException
 133     {
 134         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::getTypeMap called");
 135         throw getException(CSQL_NOT_SUPPORTED);
 136     }
 137     public SQLWarning getWarnings() throws SQLException
 138     {
 139         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::getWarnings called");
 140         throw getException(CSQL_NOT_SUPPORTED);
 141     }
 142     public boolean isReadOnly() throws SQLException
 143     {
 144         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::isReadOnly called");
 145         throw getException(CSQL_NOT_SUPPORTED);
 146     }
 147     public CallableStatement prepareCall(String query ) throws SQLException
 148     {
 149         return this.actualCon.prepareCall( query);
 150     }
 151     public CallableStatement prepareCall(String query, int resultSetType,
 152                              int resultSetConcurrency) throws SQLException
 153     {
 154         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareCall(String, int, int) called");
 155         throw getException(CSQL_NOT_SUPPORTED);
 156     }
 157     public CallableStatement prepareCall(String query, int resultSetType,
 158         int resultSetConcurrency, int resultSetHoldability) throws SQLException
 159     {
 160         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareCall(String, int, int, int) called");
 161         throw getException(CSQL_NOT_SUPPORTED);
 162     }
 163     public PreparedStatement prepareStatement(String query, int autoGeneratedKeys) throws SQLException
 164     {
 165         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareStatement(String, int) called");
 166         throw getException(CSQL_NOT_SUPPORTED);
 167     }
 168     public PreparedStatement prepareStatement(String query, int[] columnIndexes) throws SQLException
 169     {
 170         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareStatement(String, int[]) called");
 171         throw getException(CSQL_NOT_SUPPORTED);
 172     }
 173     public PreparedStatement prepareStatement( String query, int resultSetType,
 174                                   int resultSetConcurrency) throws SQLException
 175     {
 176         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareStatement(String, int, int) called");
 177         throw getException(CSQL_NOT_SUPPORTED);
 178     }
 179     public PreparedStatement prepareStatement( String query, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
 180     {
 181         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareStatement(String, int, int, int) called");
 182         throw getException(CSQL_NOT_SUPPORTED);
 183     }
 184     public PreparedStatement prepareStatement(String query, String[] columnNames) throws SQLException
 185     {
 186         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::prepareStatement(String, String[]) called");
 187         throw getException(CSQL_NOT_SUPPORTED);
 188     }
 189     public void releaseSavepoint(Savepoint savepoint) throws SQLException
 190     {
 191         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::releaseSavepoint called");
 192         throw getException(CSQL_NOT_SUPPORTED);
 193     }
 194     public void rollback(Savepoint savepoint) throws SQLException
 195     {
 196         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::rollback called");
 197         throw getException(CSQL_NOT_SUPPORTED);
 198     }
 199     public void setCatalog(String catalog) throws SQLException
 200     {
 201         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::setCatalog called");
 202         throw getException(CSQL_NOT_SUPPORTED);
 203     }
 204     public void setHoldability(int holdability) throws SQLException
 205     {
 206         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::setHoldability called");
 207         throw getException(CSQL_NOT_SUPPORTED);
 208     }
 209     public void setReadOnly(boolean rOnly) throws SQLException
 210     {
 211         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::setReadOnly called");
 212         throw getException(CSQL_NOT_SUPPORTED);
 213     }
 214     public Savepoint setSavepoint() throws SQLException
 215     {
 216         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::setSavepoint called");
 217         throw getException(CSQL_NOT_SUPPORTED);
 218     }
 219     public Savepoint setSavepoint(String query) throws SQLException
 220     {
 221         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::setSavepoint(String) called");
 222         throw getException(CSQL_NOT_SUPPORTED);
 223     }
 224     public void setTypeMap(Map map) throws SQLException
 225     {
 226         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::setTypeMpa called");
 227         throw getException(CSQL_NOT_SUPPORTED);
 228     }
 229     //Java 1.6 methods
 230     public Struct createStruct(String typeName, Object[] attributes) throws SQLException
 231     {
 232         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createStruct called");
 233         throw getException(CSQL_NOT_SUPPORTED);
 234     }
 235     public Array createArrayOf(String typeName, Object[] elements) throws SQLException
 236     {
 237         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createArrayOf called");
 238         throw getException(CSQL_NOT_SUPPORTED);
 239     }
 240     public Blob createBlob() throws SQLException
 241     {
 242         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createBlob called");
 243         throw getException(CSQL_NOT_SUPPORTED);
 244     }
 245     public Clob createClob() throws SQLException
 246     {
 247         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createClob called");
 248         throw getException(CSQL_NOT_SUPPORTED);
 249     }
 250     public NClob createNClob() throws SQLException
 251     {
 252         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createNClob called");
 253         throw getException(CSQL_NOT_SUPPORTED);
 254     }
 255     public SQLXML createSQLXML() throws SQLException
 256     {
 257         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::createSQLXML called");
 258         throw getException(CSQL_NOT_SUPPORTED);
 259     }
 260     public Properties getClientInfo() throws SQLException
 261     {
 262         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::getClientInfo called");
 263         throw getException(CSQL_NOT_SUPPORTED);
 264     }
 265     public String getClientInfo(String name) throws SQLException
 266     {
 267         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::getClientInfo(String) called");
 268         throw getException(CSQL_NOT_SUPPORTED);
 269     }
 270     public void setClientInfo(String name , String value)
 271     {
 272         return;
 273     }
 274     public void setClientInfo(Properties properties)
 275     {
 276         return;
 277     }
 278     public boolean isValid(int timeout) throws SQLException
 279     {
 280         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::isValid called");
 281         throw getException(CSQL_NOT_SUPPORTED);
 282     }
 283     public boolean isWrapperFor(Class ifact) throws SQLException
 284     {
 285         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::isWrapperFor called");
 286         throw getException(CSQL_NOT_SUPPORTED);
 287     }
 288     public Class unwrap(Class iface) throws SQLException
 289     {
 290         if (JSqlError.isDebug) System.out.println("JdbcSqlConnectionWrapper::unwrap called");
 291         throw getException(CSQL_NOT_SUPPORTED);
 292     }
 293 }