Editorial question138.3K views2,584 votes0 answers3,325 following
AI-generatedInvalidDataAccessApiUsageException: 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