HQL – row identifier for pagination

by

this is one situation where hibernate shines:

typical solution with hql query.

int elementsPerBlock = 10;
int page = 2;

return  getSession().createQuery("from SomeItems order by id asc")
            .setFirstResult(elementsPerBlock * (page-1) + 1 )
            .setMaxResults(elementsPerBlock)
            .list();

hibernate will translate this to a pattern that is understood by the database according to its sql dialect.
on oracle it will create a subselect with ROWNUM < X.
on postgresql it will issue a LIMIT / OFFSET
on msSQL server it will issue a TOP..

to my knowledge it is not possible to achieve this with “pure” hql.

More Related Contents:

  1. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  2. How do you do a limit query in JPQL or HQL?
  3. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  4. JPA and Hibernate – Criteria vs. JPQL or HQL
  5. Hibernate criteria: Joining table without a mapped association
  6. How can you call custom database functions with Hibernate?
  7. Hibernate Named Query Order By parameter
  8. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  9. How to escape reserved words in Hibernate’s HQL
  10. IN-clause in HQL or Java Persistence Query Language
  11. HQL Hibernate INNER JOIN
  12. HQL left join of un-related entities
  13. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  14. How to write a like query in HQL
  15. HQL recursion, how do I do this?
  16. Inserting data in one table using HQL in Hibernate
  17. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  18. Hibernate Error: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session
  19. Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1
  20. Using Hibernate’s ScrollableResults to slowly read 90 million records
  21. How do we count rows using older versions of Hibernate (~2009)?
  22. How can I get the session object if I have the entity-manager?
  23. Using javafx.beans properties in model classes
  24. Hibernate could not fetch the SequenceInformation from the database
  25. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  26. How to set the timeout period on a JPA EntityManager query
  27. Difference between @GeneratedValue and @GenericGenerator
  28. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  29. maven missing dependency jta-1.0.1b
  30. How to find distinct rows with field in list using JPA and Spring?

Leave a Comment