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

[Simon V. (JIRA) <no...@at...>]

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..

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira