Limit number of results in JPQL

by

You can try like this giving 10 results to be fetched explicitly.

entityManager.createQuery(JPQL_QUERY)
             .setParameter(arg0, arg1)
             .setMaxResults(10)
             .getResultList();

It will automatically create native query in back-end to retrieve specific number of results, if the backend supports it, and otherwise do the limit in memory after getting all results.

More Related Contents:

  1. JPQL Create new Object In Select Statement – avoid or embrace?
  2. Adding IN clause List to a JPA Query
  3. Parameter in like clause JPQL
  4. How to use multiple JOIN FETCH in one JPQL query
  5. How To Define a JPA Repository Query with a Join
  6. Using the JPA Criteria API, can you do a fetch join that results in only one join?
  7. Doing an “IN” query with Hibernate
  8. Setting a parameter as a list for an IN expression
  9. JPQL: Receiving a Collection in a Constructor Expression
  10. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  11. IN-clause in HQL or Java Persistence Query Language
  12. JPA Native Query select and cast object
  13. Spring Data JPA and Exists query
  14. JPQL Like Case Insensitive
  15. JPA: JOIN in JPQL
  16. How to create a JPA query with LEFT OUTER JOIN
  17. What’s the difference between the IN and MEMBER OF JPQL operators?
  18. JPA Select latest instance for each item
  19. having an exception when saving oracle type object in some entity
  20. How can I make a JPA OneToOne relation lazy
  21. Spring Boot – Cannot determine embedded database driver class for database type NONE
  22. annotation to filter results of a @OneToMany association
  23. Why use returned instance after save() on Spring Data JPA Repository?
  24. Use abstract super class as parameter for Spring data repository
  25. JPA (Hibernate) and custom table prefixes
  26. One-To-Many Relationship with Join Table
  27. How to configure transaction management for working with 2 different db in Spring?
  28. Hibernate using JPA (annotated Entities) and liquibase
  29. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  30. javax.persistence.TransactionRequiredException in small facelet application

Leave a Comment