JPA 2 CriteriaQuery, using a limit

by

Define limit and offset on the Query:

return em.createQuery(query)
         .setFirstResult(offset) // offset
         .setMaxResults(limit) // limit
         .getResultList();

From the documentation:

TypedQuery setFirstResult(int startPosition)

Set the position of the first result to retrieve. Parameters:
startPosition – position of the first result, numbered from 0

TypedQuery setMaxResults(int maxResult)

Set the maximum number of results to retrieve.

More Related Contents:

  1. String variable in java to get and store the json array in table column
  2. No Persistence provider for EntityManager named
  3. How to call a stored procedure from Java and JPA
  4. Confusion: @NotNull vs. @Column(nullable = false) with JPA and Hibernate
  5. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  6. When to use EntityManager.find() vs EntityManager.getReference() with JPA
  7. Persistence unit as RESOURCE_LOCAL or JTA?
  8. Correct use of flush() in JPA/Hibernate
  9. Spring JPA @Query with LIKE
  10. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  11. How to prevent SQL Injection with JPA and Hibernate?
  12. Hibernate: “Field ‘id’ doesn’t have a default value”
  13. Sharing a persistence unit across components in a .ear file
  14. JPA Native Query select and cast object
  15. PersistenceUnit vs PersistenceContext
  16. What is Persistence Context?
  17. Name attribute in @Entity and @Table
  18. Setting a JPA timestamp column to be generated by the database?
  19. When to use DiscriminatorValue annotation in hibernate
  20. One-To-Many Relationship with Join Table
  21. JPA Select latest instance for each item
  22. Does JPA support mapping to sql views?
  23. having an exception when saving oracle type object in some entity
  24. How can I make a JPA OneToOne relation lazy
  25. How do I get the size of a java.sql.ResultSet?
  26. How to persist a property of type List in JPA?
  27. annotation to filter results of a @OneToMany association
  28. dll missing in JDBC
  29. Is it possible to dynamically define column names in Hibernate / JPA?
  30. Are there any Java VMs which can save their state to a file and then reload that state?

Leave a Comment