public void close(){
  namedParamSqlCache.clear();
  namedParamIndexPropCache.clear();
  clearStatementCache();
  if (useConnection != null) {
    try {
      useConnection.close();
    }
 catch (    SQLException e) {
      LOG.finest("Caught exception closing connection: " + e.getMessage());
    }
  }
}

public void close ( ) { namedParamSqlCache . clear ( ) ; namedParamIndexPropCache . clear ( ) ; clearStatementCache ( ) ; if ( useConnection != null ) { try { useConnection . close ( ) ; } catch ( SQLException e ) { LOG . finest ( "Caught exception closing connection: " + e . getMessage ( ) ) ; } } }
if this sql object was created with a connection then this method closes the connection . if this sql object was created from a datasource then this method only frees any cached objects ( statements in particular ) .
