Multiple fetches with EAGER type in Hibernate with JPA

by

The root cause of the problem is that when Hibernate fetches SQL query results there is no simple way to tell which child element belongs to which collection. See this blog entry for more detailed explanation with an example. To summarize you have following workarounds:

  • Load each collection separately using subselect @Fetch(FetchMode.SELECT)
  • Force usage of list instead of bag by adding index column @IndexColumn(name="LIST_INDEX")
  • Use unordered collection like Set.

More Related Contents:

  1. JPA JoinColumn vs mappedBy
  2. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  3. Hibernate Annotations – Which is better, field or property access?
  4. Hibernate JPA Sequence (non-Id)
  5. How to store date/time and timestamps in UTC time zone with JPA and Hibernate
  6. Bypass GeneratedValue in Hibernate (merge data not in db?)
  7. How does the FetchMode work in Spring Data JPA
  8. What is “the inverse side of the association” in a bidirectional JPA OneToMany/ManyToOne association?
  9. Hibernate – @ElementCollection – Strange delete/insert behavior
  10. Difference between @OneToMany and @ElementCollection?
  11. What is the difference between CascadeType.REMOVE and orphanRemoval in JPA?
  12. JPA SQL Server No Dialect mapping for JDBC type: -9
  13. @GeneratedValue polymorphic abstract superclass over MySQL
  14. JPA entity without id
  15. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  16. How to use multiple JOIN FETCH in one JPQL query
  17. JPA OneToMany and ManyToOne throw: Repeated column in mapping for entity column (should be mapped with insert=”false” update=”false”)
  18. Hibernate generates negative id values when using a sequence
  19. GenerationType.AUTO vs GenerationType.IDENTITY in hibernate
  20. How to prevent SQL Injection with JPA and Hibernate?
  21. Native query with named parameter fails with “Not all named parameters have been set”
  22. Specifying an Index (Non-Unique Key) Using JPA
  23. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  24. IN-clause in HQL or Java Persistence Query Language
  25. @BatchSize a smart or stupid use?
  26. Spring Data JPA and Exists query
  27. Hibernate throws strange error: Class is not mapped
  28. Error creating bean with name ‘entityManagerFactory
  29. Unsuccessful: alter table XXX drop constraint YYY in Hibernate/JPA/HSQLDB standalone
  30. How to map one class with multiple tables in Hibernate/javax.persistance?

Leave a Comment