I want to get all the results in single page, I've tried with
Pageable p = new PageRequest(1, Integer.MAX_VALUE);
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 at first page (0).