spring data jpa @query and pageable

by

You can use pagination with a native query. It is documented here: Spring Data JPA – Reference Documentation

“You can however use native queries for pagination by specifying the count query yourself:
Example 59. Declare native count queries for pagination at the query method using @Query“

public interface UserRepository extends JpaRepository<User, Long> {

  @Query(value = "SELECT * FROM USERS WHERE LASTNAME = ?1",
    countQuery = "SELECT count(*) FROM USERS WHERE LASTNAME = ?1",
    nativeQuery = true)
  Page<User> findByLastname(String lastname, Pageable pageable);
}

More Related Contents:

  1. How does the FetchMode work in Spring Data JPA
  2. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  3. Spring JpaRepository – Detach and Attach entity
  4. How to map sql native query result into DTO in spring jpa repository?
  5. Difference between save and saveAndFlush in Spring data jpa
  6. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  7. setMaxResults for Spring-Data-JPA annotation?
  8. Using generics in Spring Data JPA repositories
  9. Spring Data JPA – ZonedDateTime format for json serialization
  10. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  11. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  12. Handling soft-deletes with Spring JPA
  13. @Transactional method called from another method doesn’t obtain a transaction
  14. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  15. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  16. Spring-Data FETCH JOIN with Paging is not working
  17. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  18. Could not commit JPA transaction: Transaction marked as rollbackOnly
  19. Change database schema during runtime based on logged in user
  20. Why use returned instance after save() on Spring Data JPA Repository?
  21. Use abstract super class as parameter for Spring data repository
  22. How to use @Transactional with Spring Data?
  23. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  24. Delete Not Working with JpaRepository
  25. Error creating bean with name ‘entityManagerFactory
  26. Spring Data JPA find by embedded object property
  27. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  28. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  29. Spring Data + JPA with multiple datasources but only one set of Repositories
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment