CODEWITHSUNDEEP
hibernategrailscriteriaeager
lfrodrigues
lfrodrigues

Reputation: 305

Grails criteria query with fetchMode eager with two levels

In my Grails project, I have the following classes:

class A {
    static hasMany = [cs:C]
}

class B {
    static hasMany = [cs:C]
}

class C {
    static belongsTo = [a:A, b:B]
}

I would like to query the class A and bring the all the associations from B and C eagerly. I tried the following criteria query, but when I iterate over Cs from A, hibernate uses lazy initialization to query B objects.

A.withCriteria() {
    fetchmode "cs", FetchMode.JOIN
    fetchMode "cs.b", FetchMode.JOIN
}

Any ideas?

Upvotes: 6

Views: 6470

Answers (1)

lfrodrigues
lfrodrigues

Reputation: 305

Solved.

A.withCriteria() {
    cs{
        fetchMode "cs.b", FetchMode.JOIN
    }
}

Or

A.withCriteria() {
    cs{
        b{
        }
    }
}

In both cases Hibernate is using two queries. Much better than the 98 I had before ;-)

Upvotes: 9

Related Questions