users@jpa-spec.java.net

[jpa-spec users] Proposal for pagination in JPQL and Criteria API

From: Christian Beikov <christian.beikov_at_gmail.com>
Date: Wed, 13 Aug 2014 15:17:35 +0200

Hello guys!

I would like to propose something very essential. Pagination support for
queries in general.
Currently it is only possible to use pagination with the outermost
query. I described necessary changes in JPQL and the Criteria API to
support pagination in subqueries in the JIRA issue JPA_SPEC-88
<https://java.net/jira/browse/JPA_SPEC-88>.

The use case for this feature obviously is pagination as you can
imagine. It makes it possible to reduce 2 queries to a single one. I
included an example in the JIRA issue.

Any chances that this could be added to JPA.Next?
-- 
Mit freundlichen Grüßen,
------------------------------------------------------------------------
*Christian Beikov*