Click here to Skip to main content
15,896,478 members

Query from multiples domains in grails

Revision 2
I have issues. Please help me I you can.

I have 3 domains called:
- DomainA(id, propA1,propA2)
- DomainB(id, propB1,propB2,forgeinKeyToDomainA)
- DomainC(id, propC1,propC2,forgeinKeyToDomainB)


The relationship of domains is:
DomainA hasMany DomainB, DomainB beLongsTo DomainA
DomainB hasMany DomainC, DomainC beLongsTo DomainB


I wants to get all record from DomainC that propA1="value1"

Imaging SQL code:
SQL
Select DomainC.* 
from DomainA,DomainB,DomainC
where DomainA.id=DomainB.forgeinKeyToDomainA
and DomainB.id=DomainC.forgeinKeyToDomainB
and DomainA.propA1="value1"

I can executing SQL code in grails, but I wants to use Hibernate.

Thanks.
Posted 26-Apr-13 16:20pm by ngnlx.
Tags: