[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3070) Pagination support for criteria queries

Pagination support for criteria queries ---------------------------------------- Key: HHH-3070 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3070 Project: Hibernate3 Issue Type: Improvement Reporter: marko asplund It would good if it would be possible to use the criteria query api for specifying the result set window e.g. so that Criteria c = session.createCriteria(Cat.class); c.setResultSetWindow(500000, 20); would make the database return the first 20 rows starting from row 500000 of the total result set. Currently it's possible to do this in the application level but a lot of work would be saved when the database would not need to return 500000 rows which are then OR mapped only to be discarded.