SpringBoot JPA Pagination Issue - Getting incorrect total number of records in spring boot.

Hello Team,

We are using JPA pagination issue in our application. Issue: Returning different count of total number of records for different page number and page size inputs. Used Inner joins and distinct keywords in our native queries.

Tech Details: Spring Boot:3.0.7 postgresql: 42.3.9

Kindly let me know if any other details required and assist on this issue.

Comment From: wilkinsona

Spring Boot 3.0.x is no longer supported. Please upgrade to Spring Boot 3.2.x or later. Furthermore, Spring Boot itself isn't really involved with JPA and pagination. Those are Hibernate and Spring Data JPA features. If the upgrade to a supported version does not resolve the problem, I think your next step should be to post a question on Stack Overflow that includes a minimal example of the problem you're trying to solve.