How to get all results in one page using Spring Data Pagination

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

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

PageRequest.of(0, Integer.MAX_VALUE);

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