[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3070) Pagination support for criteria queries
marko asplund (JIRA)
noreply at atlassian.com
Thu Jan 17 13:54:55 EST 2008
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29360 ]
marko asplund commented on HHH-3070:
------------------------------------
I did have a look, but obviously managed to still miss it :-)
> 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.
--
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
More information about the hibernate-issues
mailing list