How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller

by

You will have to make an explicit call on the lazy collection in order to initialize it (common practice is to call .size() for this purpose). In Hibernate there is a dedicated method for this (Hibernate.initialize()), but JPA has no equivalent of that. Of course you will have to make sure that the invocation is done, when the session is still available, so annotate your controller method with @Transactional. An alternative is to create an intermediate Service layer between the Controller and the Repository that could expose methods which initialize lazy collections.

Update:

Please note that the above solution is easy, but results in two distinct queries to the database (one for the user, another one for its roles). If you want to achieve better performace add the following method to your Spring Data JPA repository interface:

public interface PersonRepository extends JpaRepository<Person, Long> {

    @Query("SELECT p FROM Person p JOIN FETCH p.roles WHERE p.id = (:id)")
    public Person findByIdAndFetchRolesEagerly(@Param("id") Long id);

}

This method will use JPQL’s fetch join clause to eagerly load the roles association in a single round-trip to the database, and will therefore mitigate the performance penalty incurred by the two distinct queries in the above solution.

More Related Contents:

  1. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  2. What is this spring.jpa.open-in-view=true property in Spring Boot?
  3. Bypass GeneratedValue in Hibernate (merge data not in db?)
  4. Using generics in Spring Data JPA repositories
  5. How does the FetchMode work in Spring Data JPA
  6. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  7. No Dialect mapping for JDBC type: 1111
  8. @Transactional method called from another method doesn’t obtain a transaction
  9. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  10. How to set up default schema name in JPA configuration?
  11. Transaction marked as rollback only: How do I find the cause
  12. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  13. How to manually force a commit in a @Transactional method? [duplicate]
  14. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  15. Change database schema during runtime based on logged in user
  16. How to map sql native query result into DTO in spring jpa repository?
  17. Difference between save and saveAndFlush in Spring data jpa
  18. The onFlushDirty Hibernate Interceptor method is never called
  19. spring data jpa @query and pageable
  20. Spring Data JPA and Exists query
  21. Spring Data JPA: query ManyToMany
  22. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  23. Hibernate, spring, JPS & isolation – custom isolation not supported
  24. Error creating bean with name ‘entityManagerFactory
  25. Spring Data JPA find by embedded object property
  26. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  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