How to use

close

method

in

jodd.db.oom.DbOomQuery

/**
 * Closes results set or whole query.
 */
protected void close(final ResultSetMapper rsm, final boolean closeQuery) {
  if (closeQuery) {
    close();
  } else {
    closeResultSet(rsm.getResultSet());
  }
}

protected <T> T find(final Class[] types, final boolean close, ResultSet resultSet) {
  if (resultSet == null) {
    resultSet = execute();
  }
  ResultSetMapper rsm = createResultSetMapper(resultSet);
  Iterator<T> iterator = new DbListIterator<>(this, types, rsm, false);
  T result = null;
  if (iterator.hasNext()) {
    result = iterator.next();
  }
  close(rsm, close);
  return result;
}

  query.close();
} else {
  query.closeResultSet(resultSetMapper.getResultSet());

close(rsm, close);
return result;

assertEquals(2, dbEntityManager.getTotalNames());
q.close();
long key = q.getGeneratedKey();
assertEquals(4, key);
q.close();
Long Key = q.findGeneratedKey(Long.class);
assertEquals(5, Key.longValue());
q.close();
q.close();
assertEquals(0, q.getOpenResultSetCount());
q.populateGeneratedKeys(g2);
q.close();
assertEquals(7, g2.id.intValue());
checkGirl4(girls.get(0));
checkGirl5(girls.get(1));
q.close();

close(rsm, close);
return result;

/**
 * Closes results set or whole query.
 */
protected void close(ResultSetMapper rsm, boolean closeQuery) {
  if (closeQuery == true) {
    close();
  } else {
    closeResultSet(rsm.getResultSet());
  }
}

query.close();
query.setMap(params);
long count = query.executeCount();
query.close();

/**
 * Closes results set or whole query.
 */
protected void close(final ResultSetMapper rsm, final boolean closeQuery) {
  if (closeQuery) {
    close();
  } else {
    closeResultSet(rsm.getResultSet());
  }
}

q.close();
q.close();
q.close();
q.close();
checkGirl3(girl);
checkBoy(badBoy);
q.close();
checkGirl3(girl);
checkBoy(badBoy);
q.close();
checkGirl3(girl);
checkBoy(badBoy);
q.close();
q.close();
f.init();
assertEquals("select Girl_.ID, Girl_.NAME, Girl_.SPECIALITY from GIRL Girl_ where (Girl_.ID=1)", f.toString());
f.close();
f = dbOom.entities().find(badGirl).aliasColumnsAs(null).query();
f.setDebugMode();
assertEquals("select BadGirl_.ID, BadGirl_.NAME, BadGirl_.SPECIALITY from GIRL BadGirl_ where (1=1)", f.toString());
f.close();

public boolean hasNext() {
  if (resultSetMapper.next() == true) {
    return true;
  }
  if (closeOnEnd == true) {
    query.close();
  } else {
    query.closeResultSet(resultSetMapper.getResultSet());
  }
  return false;
}

protected <T> T find(final Class[] types, final boolean close, ResultSet resultSet) {
  if (resultSet == null) {
    resultSet = execute();
  }
  ResultSetMapper rsm = createResultSetMapper(resultSet);
  Iterator<T> iterator = new DbListIterator<>(this, types, rsm, false);
  T result = null;
  if (iterator.hasNext()) {
    result = iterator.next();
  }
  close(rsm, close);
  return result;
}

public boolean hasNext() {
  if (resultSetMapper.next() == true) {
    return true;
  }
  if (closeOnEnd == true) {
    query.close();
  } else {
    query.closeResultSet(resultSetMapper.getResultSet());
  }
  return false;
}

@SuppressWarnings({"unchecked"})
protected <T> Set<T> listSetOne(Class<T> type, int max, boolean close) {
  Set<T> result = new LinkedHashSet<T>(initialCollectionSize(max));
  ResultSetMapper rsm = executeAndBuildResultSetMapper();
  Class[] types = (type == null ? rsm.resolveTables() : new Class[]{type});
  while (rsm.next()) {
    result.add((T) rsm.parseOneObject(types));
    max--;
    if (max == 0) {
      break;
    }
  }
  close(rsm, close);
  return result;
}

/**
 * Iterates results set, maps rows to just one class and populates the array list.
 * @param type target type
 * @param max max number of rows to collect, <code>0</code> for all
 * @param close <code>true</code> if query is closed at the end, otherwise <code> false
 * @return list of mapped entities
 */
@SuppressWarnings({"unchecked"})
protected <T> List<T> listOne(Class<T> type, int max, boolean close) {
  List<T> result = new ArrayList<T>(initialCollectionSize(max));
  ResultSetMapper rsm = executeAndBuildResultSetMapper();
  Class[] types = (type == null ? rsm.resolveTables() : new Class[]{type});
  while (rsm.next()) {
    result.add((T) rsm.parseOneObject(types));
    max--;
    if (max == 0) {
      break;
    }
  }
  close(rsm, close);
  return result;
}

@SuppressWarnings({"unchecked"})
protected <T> Set<T> listSet(Class[] types, int max, boolean close) {
  Set<T> result = new LinkedHashSet<T>(initialCollectionSize(max));
  ResultSetMapper rsm = executeAndBuildResultSetMapper();
  if (types == null) {
    types = rsm.resolveTables();
  }
  while (rsm.next()) {
    Object[] objects = rsm.parseObjects(types);
    Object row = resolveRowHints(objects);
    result.add((T) row);
    max--;
    if (max == 0) {
      break;
    }
  }
  close(rsm, close);
  return result;
}

@SuppressWarnings({"unchecked"})
protected <T> T findOne(Class<T> type, boolean close, ResultSet resultSet) {
  if (resultSet == null) {
    resultSet = execute();
  }
  ResultSetMapper rsm = createResultSetMapper(resultSet);
  if (rsm.next() == false) {
    return null;
  }
  Class[] types = (type == null ? rsm.resolveTables() : new Class[]{type});
  Object result = rsm.parseOneObject(types);
  close(rsm, close);
  return (T) result;
}

/**
 * Iterates result set, maps rows to classes and populates the array list.
 * @param types mapping types
 * @param max max number of rows to collect, <code>0</code> for all
 * @param close <code>true</code> if query is closed at the end, otherwise <code> false
 * @return list of mapped entities
 */
@SuppressWarnings({"unchecked"})
protected <T> List<T> list(Class[] types, int max, boolean close) {
  List<T> result = new ArrayList<T>(initialCollectionSize(max));
  ResultSetMapper rsm = executeAndBuildResultSetMapper();
  if (types == null) {
    types = rsm.resolveTables();
  }
  while (rsm.next()) {
    Object[] objects = rsm.parseObjects(types);
    Object row = resolveRowHints(objects);
    result.add((T) row);
    max--;
    if (max == 0) {
      break;
    }
  }
  close(rsm, close);
  return result;
}

protected Object find(Class[] types, boolean close, ResultSet resultSet) {
  if (resultSet == null) {
    resultSet = execute();
  }
  ResultSetMapper rsm = createResultSetMapper(resultSet);
  if (rsm.next() == false) {
    return null;
  }
  if (types == null) {
    types = rsm.resolveTables();
  }
  Object[] objects = rsm.parseObjects(types);
  Object result = resolveRowHints(objects);
  close(rsm, close);
  return result;
}

query.close();
query.setMap(params);
long count = query.executeCount();
query.close();