Click here to Skip to main content
11,575,600 members (62,510 online)

brian.nguyenle asked:

Open original thread
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:
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.
Tags: Groovy

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web03 | 2.8.150624.2 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100