org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags

by

Hibernate doesn’t allow fetching more than one bag because that would generate a Cartesian product.

Now, you will find lots of answers, blog posts, videos, or other resources telling you to use a Set instead of a List for your collections.

That’s terrible advice!

Using Sets instead of Lists will make the MultipleBagFetchException go away, but the Cartesian Product will still be there.

The right fix

Instead of using multiple JOIN FETCH in a single JPQL or Criteria API query:

List<Post> posts = entityManager.createQuery("""
    select p
    from Post p
    left join fetch p.comments
    left join fetch p.tags
    where p.id between :minId and :maxId
    """, Post.class)
.setParameter("minId", 1L)
.setParameter("maxId", 50L)
.getResultList();

You can do the following trick:

List<Post> posts = entityManager.createQuery("""
    select distinct p
    from Post p
    left join fetch p.comments
    where p.id between :minId and :maxId
    """, Post.class)
.setParameter("minId", 1L)
.setParameter("maxId", 50L)
.setHint(QueryHints.PASS_DISTINCT_THROUGH, false)
.getResultList();

posts = entityManager.createQuery("""
    select distinct p
    from Post p
    left join fetch p.tags t
    where p in :posts
    """, Post.class)
.setParameter("posts", posts)
.setHint(QueryHints.PASS_DISTINCT_THROUGH, false)
.getResultList();

As long as you fetch at most one collection using JOIN FETCH, you will be fine. By using multiple queries, you will avoid the Cartesian Product since any other collection but the first one is fetched using a secondary query.

More Related Contents:

  1. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  2. How to map calculated properties with JPA and Hibernate
  3. Can someone explain mappedBy in JPA and Hibernate?
  4. In which case do you use the JPA @JoinTable annotation?
  5. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  6. Hibernate throws strange error: Class is not mapped
  7. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  8. Difference between FetchType LAZY and EAGER in Java Persistence API?
  9. How to map an entity field whose name is a reserved word in JPA
  10. Why is Hibernate Open Session in View considered a bad practice?
  11. What’s the difference between JPA and Hibernate? [closed]
  12. How to convert a Hibernate proxy to a real entity object
  13. What is the solution for the N+1 issue in JPA and Hibernate?
  14. JPA CascadeType.ALL does not delete orphans
  15. Wrong ordering in generated table in jpa
  16. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  17. what is @JoinColumn and how it is used in Hibernate
  18. JPA eager fetch does not join
  19. How can I get the session object if I have the entity-manager?
  20. No Dialect mapping for JDBC type: 1111
  21. Hibernate – A collection with cascade=”all-delete-orphan” was no longer referenced by the owning entity instance
  22. Hibernate one-to-one: getId() without fetching entire object
  23. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  24. Hibernate generates negative id values when using a sequence
  25. How to prevent SQL Injection with JPA and Hibernate?
  26. Specifying an Index (Non-Unique Key) Using JPA
  27. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  28. IN-clause in HQL or Java Persistence Query Language
  29. How to set the timeout period on a JPA EntityManager query
  30. JPA Updating Bidirectional Association

Leave a Comment