private void close() {
    try
        {
            if (res != null) res.close();
            if (stmt != null) stmt.close();
            if (con != null) con.close();
        }
        catch(SQLException e)
        {
            logger.debug("Error closing connections: " + e.toString());
            return;
        }
  }