Spring-Data FETCH JOIN with Paging is not working

by

The easiest way is to use the countQuery attribute of the the @Query annotation to provide a custom query to be used.

@Query(value = "SELECT v FROM VisitEntity v LEFT JOIN FETCH v.comments …",
       countQuery = "select count(v) from VisitEntity v where …")
List<VisitEntity> getVenueVisits(@Param("venueId") long venueId, …);

More Related Contents:

  1. setMaxResults for Spring-Data-JPA annotation?
  2. Using generics in Spring Data JPA repositories
  3. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  4. Handling soft-deletes with Spring JPA
  5. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  6. Why use returned instance after save() on Spring Data JPA Repository?
  7. How to use @Transactional with Spring Data?
  8. Spring Data JPA: query ManyToMany
  9. Spring Data JPA find by embedded object property
  10. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  11. Spring Data + JPA with multiple datasources but only one set of Repositories
  12. How to properly use findBySomeOtherId not findById in Spring data jpa?
  13. What is this spring.jpa.open-in-view=true property in Spring Boot?
  14. Spring Boot, Spring Data JPA with multiple DataSources
  15. Spring Data JPA – ZonedDateTime format for json serialization
  16. How does the FetchMode work in Spring Data JPA
  17. Filtering database rows with spring-data-jpa and spring-mvc
  18. Spring data jpa- No bean named ‘entityManagerFactory’ is defined; Injection of autowired dependencies failed
  19. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  20. How to manually force a commit in a @Transactional method? [duplicate]
  21. JPA: update only specific fields
  22. How to map sql native query result into DTO in spring jpa repository?
  23. Difference between save and saveAndFlush in Spring data jpa
  24. spring data jpa @query and pageable
  25. JPQL Like Case Insensitive
  26. Spring Data JPA: Query by Example?
  27. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  28. Spring Data – Multi-column searches
  29. Best way of handling entities inheritance in Spring Data JPA
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment