InvalidDataAccessApiUsageException: Pageable unsupported for native @Query without LIMIT/OFFSET
When executing a native SQL query annotated with @Query in Spring Data JPA, passing a Pageable without an explicit LIMIT / OFFSET clause triggers an InvalidDataAccessApiUsageException . This indicates that pagination is unsupported for that query. The goal is to paginate large datasets efficiently while preventing accidental full result retrieval. Constraint
spring