[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7218) Result is closed; invalid operation

[Pranav Shah (JIRA)]

Result is closed; invalid operation
-----------------------------------

                 Key: HHH-7218
                 URL: https://hibernate.onjira.com/browse/HHH-7218
             Project: Hibernate ORM
          Issue Type: Bug
          Components: core
    Affects Versions: 3.5.1
         Environment: DB2. Hibernate 3.5.1 core.
            Reporter: Pranav Shah


I am trying to use, query.list() and pagination. first time when I am querying the chunk of data, it returns data with correct values and for the second time, when I am querying the db, it throws exception as said in summary. when second time, application is querying the db, it has the lesser number of rows then the first time query as db is getting updated in between. 
e.g. right now, employee has 6 records and I am trying to query for first result 0 and max result 5. after the first batch completion and before second batch start, now employee has only 4 records, and second batch is getting crashed with "ResultSet is closed. invalid operation". exception message is coming. SQLCode -4470.

Please let me know, if you need more description.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira