Hibernate fetching in criteria ignored

Question

I have some class User which has one to many relation to LoginSession class (I have a collection of LoginSessions in my User class).

@Entity(name="T_User")
public class User() 
{
   ....
     @OneToMany(fetch=FetchType.LAZY, mappedBy="user", cascade=CascadeType.ALL)
     @Fetch(FetchMode.SELECT)
     @JsonIgnore
     private Set<LoginSession> userLoginSession;
   ....
 }

Here is the LoginSession class:

@Entity(name="T_LoginSession")
public class LoginSession extends BasicDTO
{

    @ManyToOne
    @JoinColumn(name="userId")  
    protected User user;
    ...

And I have this Criteria:

Criteria crit = session.createCriteria(User.class);
crit.setFetchMode("loginSession", FetchMode.JOIN);
crit.createAlias("userLoginSession", "session");
crit.add(Restrictions.eq("session.token", sessionToken));
crit.setMaxResults(1);
crit.setFirstResult(0);
crit.setFetchSize(1);

The problem is that the fetching is always Lazy. How can I make it to be Eager (via criteria and not via attribute annotation)?

Note:
If I am adding @Fetch annotation above the private Set<LoginSession> userLoginSession the response fetching as set in the annotation (I wont it to be customised by the criteria setFetchMode).

Are the names of the fields (the first parameter of the setFetchMode method) correct?

Question: Is this bug related to my issue?

check this http://stackoverflow.com/questions/25823552/hibernate-eager-loading-with-query — Killer, Sep 15 '14 at 05:52

score 5 · Accepted Answer · edited May 23 '17 at 11:58

as noted here you can not filter and eager fetch a collection at the same time. you can solve it with a correlated subquery:

DetachedCriteria subquery = DetachedCriteria.For(User.class)
    .createAlias("userLoginSession", "session")
    .add(Restrictions.eq("session.token", sessionToken))
    .setFirstResult(0)
    .setMaxResults(1)     // assuming token is unique otherwise this won't restrict users but loginsessions
    .setProjection(Projections.id());

Criteria crit = session.createCriteria(User.class)
    .add(Subqueries.propertyIn("id", subquery)
    .setFetchMode("userLoginSession", FetchMode.JOIN);

Note: this is text editor code of the top of my head. Methodnames may vary

Alexey Semenyuk · Answer 2 · 2014-09-15T06:01:57.377

1

Try:

 Criteria crt = session.createCriteria(User.class);
 crt.setFetchMode("sessions", FetchMode.JOIN);

edited Sep 15 '14 at 06:01

answered Sep 15 '14 at 05:33

Alexey Semenyuk

3,263
2
32
36

Criteria criteria = session.createCriteria(User.class); criteria.setFetchMode("sessions", FetchMode.JOIN); List list = criteria.list(); – Alexey Semenyuk Sep 15 '14 at 05:58
https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/performance.html#performance-fetching – Alexey Semenyuk Sep 15 '14 at 06:18

score 1 · Answer 3 · answered Sep 15 '14 at 06:07

1

Try following

Criteria crit = session.createCriteria(User.class);
crit.setFetchMode("session.userId", FetchMode.EAGER);
User myThingy = (User)crit.uniqueResult();

answered Sep 15 '14 at 06:07

Darshan Lila

5,772
2
24
34

EAGER is deprecated, according documentation I need to use JOIN. – vlio20 Sep 15 '14 at 06:16
Ok, are you getting unexpected results or some exceptions. What's going wrong? How are you testing your code? – Darshan Lila Sep 16 '14 at 05:11
The setFetchingMethod doing nothing. That is the problem. I see that I am having one query when I am getting the user (as seen in the code) and another one when I am accessing the relationship. – vlio20 Sep 16 '14 at 06:08
Do you use annotations for mapping? – Darshan Lila Sep 16 '14 at 06:43
Yes, you can see in the question – vlio20 Sep 16 '14 at 07:02

score 1 · Answer 4 · answered Sep 17 '14 at 07:55

1

Try setting the jointype on the alias:

Criteria crit = session.createCriteria(User.class);
crit.createAlias("userLoginSession", "session", Criteria.INNER_JOIN);
crit.add(Restrictions.eq("session.token", sessionToken));
crit.setMaxResults(1);
crit.setFirstResult(0);
crit.setFetchSize(1);

answered Sep 17 '14 at 07:55

Marius

3,043
1
15
24

this is deprecated :( – vlio20 Sep 17 '14 at 17:35
What is deprecated? In the stable release, you can use createAlias(String associationPath, alias, joinType) (http://docs.jboss.org/hibernate/stable/core/javadocs/org/hibernate/Criteria.html#createAlias(java.lang.String, java.lang.String, org.hibernate.sql.JoinType)) – Marius Sep 18 '14 at 09:04
I am using hibernate 4 and eclipse indicates that is deprecated. Can you look at the names I provided as strings to setFetchingMethod? – vlio20 Sep 18 '14 at 09:18

Hibernate fetching in criteria ignored

4 Answers4

Linked