How do you do a limit query in JPQL or HQL?

by

This was posted on the Hibernate forum a few years back when asked about why this worked in Hibernate 2 but not in Hibernate 3:

Limit was never a supported clause
in HQL. You are meant to use
setMaxResults().

So if it worked in Hibernate 2, it seems that was by coincidence, rather than by design. I think this was because the Hibernate 2 HQL parser would replace the bits of the query that it recognised as HQL, and leave the rest as it was, so you could sneak in some native SQL. Hibernate 3, however, has a proper AST HQL Parser, and it’s a lot less forgiving.

I think Query.setMaxResults() really is your only option.

More Related Contents:

  1. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  2. JPA and Hibernate – Criteria vs. JPQL or HQL
  3. Hibernate criteria: Joining table without a mapped association
  4. How can you call custom database functions with Hibernate?
  5. Hibernate Named Query Order By parameter
  6. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  7. How to escape reserved words in Hibernate’s HQL
  8. IN-clause in HQL or Java Persistence Query Language
  9. HQL Hibernate INNER JOIN
  10. HQL left join of un-related entities
  11. HQL – row identifier for pagination
  12. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  13. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  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. ImprovedNamingStrategy no longer working in Hibernate 5
  18. Correct use of flush() in JPA/Hibernate
  19. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  20. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  21. Java / Hibernate – Write operations are not allowed in read-only mode
  22. How to call an Oracle function from Hibernate with a return parameter?
  23. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  24. Doing an “IN” query with Hibernate
  25. Difference between save and saveAndFlush in Spring data jpa
  26. Inherited abstract class with JPA (+Hibernate)
  27. Different representation of UUID in Java Hibernate and SQL Server
  28. Hibernate Error: a different object with the same identifier value was already associated with the session
  29. How do I map a BigDecimal in Hibernate so I get back the same scale I put in?
  30. How to use JTA support in Tomcat 6 for Hibernate?

Leave a Comment