How to get all results in one page using Spring Da

Question

I want to get all the results in single page, I've tried with

Pageable p = new PageRequest(1, Integer.MAX_VALUE);
return customerRepository.findAll(p);

Above is not working, is there any methods to achieve this? Seems like it cannot be achieved from custom query as asked here.

Answer 1

As of spirng-data-commons@2.1.0 correct syntax is PageRequest.of(0, Integer.MAX_VALUE). You can look here

Answer 2

Your page request is incorrect because you are looking for results at the wrong page. It should be:

new PageRequest(0, Integer.MAX_VALUE);

First page for results is 0. Since you're returning all records, they are all on this page.

Answer 3

If you pass null for Pageable, Spring will ignore it and brings all data.

Pageable p = null;
return customerRepository.findAll(p);

Answer 4

The more correct way is to use Pageable.unpaged()

Pageable wholePage = Pageable.unpaged();
return customerRepository.findAll(wholePage);