[FIXED] pagination in quarkus backend and java

Issue

I'm new to quarkus and trying to get query result in quarkus using PanacheQuery.findAll().page( pageIndex,pageSize).list(); I run my query in data base and it returns correct data. but in my application it's always returns list of wrong numbers of objects.

what do I miss?

my database contains 6 objects in PatientsTbl when I set pageIndex to 1 and itemsPerPage to 6 (all objects in database) it returns no data when I set pageIndex to 1 and itemsPerPage to 4 it only returns 2!

@GET
@Path("getPag")
public Response getAll(@Path("/getPage/{pageIndex}/{itemsPerPage}")) {
    return Response.ok((productsRepository).findAll()
            .page(Page.of(pageIndex, itemsPerPage), pageRequest.getPageSize()))
            .list()).build();
}



in application :



 public List<PatientsTbl> getListWithPagination(int pageNum, int pageSize) throws Exception{
        String data = target.path("/patients/getPag").queryParam( "pageNum", pageNum ).queryParam( "pageSize", pageSize) .request(MediaType.APPLICATION_JSON).get(String.class);
        ObjectMapper mapper = new ObjectMapper();
        System.out.println(data);
    
        List<PatientsTbl> list = new ArrayList<>();
        list = mapper.readValue(data, new TypeReference<List<PatientsTbl>>(){});
        return list;
    
    }

Solution

Look at the Javadoc of the Page#of method. It clearly says that the index is 0-based. So, when you use a pageIndex of 1, it will actually show you the second page.

Answered By - Christian Beikov
Answer Checked By - Clifford M. (JavaFixing Volunteer)