spring data jpa limit pagesize, how to set to maxSize

by

In conjunction with Spring MVC you can use PageableDefaults annotation with value = Integer.MAX_VALUE like

public String showUsers(Model model, 
  @PageableDefaults(pageNumber = 0, value = Integer.MAX_VALUE) Pageable pageable) { … }

see PageableDefaults annotation Javadoc.

In any other client code you can set second constructor parameter to Integer.MAX_VALUE:

new PageRequest(
    queryForm.getPageNumber()- 1, 
    queryForm.getPageSize() == null ? Integer.MAX_VALUE : queryForm.getPageSize(),
    Sort.Direction.ASC,"id");

see PageRequest constructor. I assume that queryForm.getPageSize() is a wrapper type not a primitive. Otherwise you get a zero if pageSize wasn’t set by the user (intentionally for a “search all” request).

UPDATE:

Since Spring Data Commons 1.6 you should use PageableDefault instead of PageableDefaults

public String showUsers(Model model, 
    @PageableDefault(page= 2 ,value = Integer.MAX_VALUE)

See PageableDefault annotation Javadoc.

More Related Contents:

  1. Dynamic spring data jpa repository query with arbitrary AND clauses
  2. setMaxResults for Spring-Data-JPA annotation?
  3. Using generics in Spring Data JPA repositories
  4. POSTing a @OneToMany sub-resource association in Spring Data REST
  5. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  6. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  7. Spring Data JPA – “No Property Found for Type” Exception
  8. Handling soft-deletes with Spring JPA
  9. How to maintain bi-directional relationships with Spring Data REST and JPA?
  10. Adding Spring Dependency Injection in JavaFX (JPA Repo, Service)
  11. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  12. Spring-Data FETCH JOIN with Paging is not working
  13. Filtering data with Spring boot CrudRepository
  14. Why use returned instance after save() on Spring Data JPA Repository?
  15. Use abstract super class as parameter for Spring data repository
  16. How to use @Transactional with Spring Data?
  17. Are you supposed to have one repository per table in JPA?
  18. How to map sql native query result into DTO in spring jpa repository?
  19. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  20. Delete Not Working with JpaRepository
  21. Check date between two other dates spring data jpa
  22. Spring Data JPA: Query by Example?
  23. JpaRepository caches newly created object. How to refresh it?
  24. Apparent connection leak detected with Hikari CP
  25. Spring Data – Multi-column searches
  26. Spring Data JPA find by embedded object property
  27. Spring Data JPA findOne() change to Optional how to use this?
  28. Best way of handling entities inheritance in Spring Data JPA
  29. Spring data JPA and parameters that can be null
  30. How to persist LocalDate with JPA?

Leave a Comment