How to override FetchType.EAGER to be lazy at runtime

Question

Using the JPA EntityManager and the JPA Query object, how can I override something that has the annotation @OneToMany(fetch = FetchType.EAGER) to be fetched lazily in a query?

If I had the hibernate Query object, I could have it create a criteria object and using this, set the fetch type to be lazy. But I have to use the JPA Query object. Is there any solution for this problem?

Yes, you can - http://stackoverflow.com/questions/4388486/fetchmode-in-jpa-2-criteriaquery — Yegor Chumakov, Jun 12 '12 at 13:30
See this: http://stackoverflow.com/questions/17847289/ignore-a-fetchtype-eager-in-a-relationship. — Dherik, Sep 30 '13 at 15:21

score 8 · Accepted Answer · answered Jun 12 '12 at 13:58

8

There is no way to do that, even with the native Hibernate API. If an association is defined as EAGER, it will always be eagerly loaded, and there's no way to change that using a query.

The reverse is not true: you can eagerly-load a lazy association using a query.

answered Jun 12 '12 at 13:58

JB Nizet

633,450
80
1,108
1,174

Damn. Thanks, yes, I've been using the fetch-keyword in HQL to do that. – hugelgupf Jun 12 '12 at 14:15

score -1 · Answer 2 · answered Sep 26 '17 at 15:55

-1

Look into Hibernate Fetch profiles, or JPA Entity Graphs. This problem has been solved since you've asked the question in 2012.

answered Sep 26 '17 at 15:55

mancini0

3,075
21
25

1

This has not been solved see: https://hibernate.atlassian.net/browse/HHH-8776 - it is not possible to to ignore the EAGER load even using EntityGraphs. – Robert Hunt Oct 19 '17 at 09:53
Ahh my apologies, disregard my answer. The typical use case is the reverse - mark your entities as lazily fetched, and use the entity graph to change the fetch type to be eager at run time. I was not aware of HHH-8776, good to know, thanks. – mancini0 Jan 29 '18 at 17:40

How to override FetchType.EAGER to be lazy at runtime

2 Answers2

Linked