JPA Hibernate Nested Objects

Question

Basically I have 3 tables: COUNTRY, STATE and CITY.

in Country.java:

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
@JoinColumn(name = "COUNTRY_ID")
private List<State> state = new Vector<State>();

in State.java

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER)
@JoinColumn(name = "STATE_ID")
private List<City> city = new Vector<City>();

JPA query looks like:

caEntityManager.createQuery("SELECT C FROM COUNTRY C 
        JOIN fetch C.STATE S JOIN fetch S.CITY").getResultList();

When I try to execute the query I get:

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

I am sure my query is wrong, i am new to this, please appoint me to the right direction. I

Thanks!

BTW, i am getting org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags from the code above. — topcan5
– topcan5, Commented Apr 24, 2014 at 3:48

Community · Accepted Answer · 2017-05-23 10:32:26Z

1

Problem is Hibernate can not fetch two bags EAGERly. The quick solution would be to change the Lists to Sets.

To read more:

Also this question suggests a couple of other solutions.

CommunityBot

11 silver badge

answered Apr 24, 2014 at 6:14

Ean V

5,4495 gold badges33 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1