public void close() throws GenericDataSourceException {
  if (_manualTX) {
    if (Debug.verboseOn())     Debug.logVerbose("SQLProcessor:close() calling commit : _manualTX=" + _manualTX,module);
    commit();
  }
  _sql=null;
  if (_rs != null) {
    try {
      _rs.close();
      if (Debug.verboseOn())       Debug.logVerbose("SQLProcessor:close() result close : _manualTX=" + _manualTX,module);
    }
 catch (    SQLException sqle) {
      Debug.logWarning(sqle.getMessage(),module);
    }
    _rs=null;
  }
  if (_ps != null) {
    try {
      _ps.close();
      if (Debug.verboseOn())       Debug.logVerbose("SQLProcessor:close() preparedStatement close : _manualTX=" + _manualTX,module);
    }
 catch (    SQLException sqle) {
      Debug.logWarning(sqle.getMessage(),module);
    }
    _ps=null;
  }
  if ((_connection != null) && _bDeleteConnection) {
    try {
      _connection.close();
      if (Debug.verboseOn())       Debug.logVerbose("SQLProcessor:close() connection close : _manualTX=" + _manualTX,module);
    }
 catch (    SQLException sqle) {
      Debug.logWarning(sqle.getMessage(),module);
    }
    _connection=null;
  }
}

public void close ( ) throws GenericDataSourceException { if ( _manualTX ) { if ( Debug . verboseOn ( ) ) Debug . logVerbose ( "SQLProcessor:close() calling commit : _manualTX=" + _manualTX , module ) ; commit ( ) ; } _sql = null ; if ( _rs != null ) { try { _rs . close ( ) ; if ( Debug . verboseOn ( ) ) Debug . logVerbose ( "SQLProcessor:close() result close : _manualTX=" + _manualTX , module ) ; } catch ( SQLException sqle ) { Debug . logWarning ( sqle . getMessage ( ) , module ) ; } _rs = null ; } if ( _ps != null ) { try { _ps . close ( ) ; if ( Debug . verboseOn ( ) ) Debug . logVerbose ( "SQLProcessor:close() preparedStatement close : _manualTX=" + _manualTX , module ) ; } catch ( SQLException sqle ) { Debug . logWarning ( sqle . getMessage ( ) , module ) ; } _ps = null ; } if ( ( _connection != null ) && _bDeleteConnection ) { try { _connection . close ( ) ; if ( Debug . verboseOn ( ) ) Debug . logVerbose ( "SQLProcessor:close() connection close : _manualTX=" + _manualTX , module ) ; } catch ( SQLException sqle ) { Debug . logWarning ( sqle . getMessage ( ) , module ) ; } _connection = null ; } }
commit if required and remove all allocated resources
