[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1946) Query.iterate() results differ from Query.list().iterator()

Query.iterate() results differ from Query.list().iterator() ----------------------------------------------------------- Key: HHH-1946 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1946 Project: Hibernate3 Type: Bug

Components: query-hql Versions: 3.1.3 Environment: Hibernate 3.1.3 Sun JVM 1.5.0_06 Windows XP Reporter: Simon Vos Priority: Critical

While trying to migrate our code base from hibernate 2.1.8 to hibernate 3.1.3 I came across a weird problem. In one method a hibernate query is created to retrieve some results from the database, I know that there are three corresponding results in the database for this query. The code used for this is: rsIterator = query.iterate(); while (rsIterator.hasNext()) { Relationship current = (Relationship) rsIterator.next(); NaturalPerson person = (NaturalPerson) sess.get(NaturalPerson.class, new Niss(current.getSpouseNiss()).toLong()); if (person != null) { current.setSpouseFirstName(person.getFirstName()); current.setSpouseLastName(person.getLastName()); } else log.info("No naturalPerson object could be retrieved for the person with niss number " + current.getSpouseNiss().toString()); relations.add(current); } In hibernate 2.1.8 this method worked correctly and it added 3 results to the relations object. But while migrating one of my tests failed, because this method returned only 2 results. Then I tried using query.list().iterator() instead of query.iterate() and this gave me the correct three results..