Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Criteria for retriving data involving multiple joins

 
Harish Harry
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have four tables with sample data related with eachother as below


**Employee**

EMP_ID|EMP_NAME
---------------
101 |John

**EmployeeDtl**

EMP_DTL_ID |EMP_SKILLS |EMP_ID
-----------------------------------
1001 |Java |101
1002 |SQL |101


**EmpDeptDtl**

EMP_DTL_ID |DEPT_ID
--------------------
1001 |22
1002 |33

**Dept**

DEPT_ID |DEPT_NAME
----------------------
22 |XYZ
33 |PQR


Below are my corresponding pojos






Now, Can anyone suggest me on how to retrieve the list of Dept records for the given EMP_ID using CRITERIA. In the above sample data given, for the EMP_ID=101, the dept records with dept_ids 22 and 33 should be returned.

I got the solution using Named query and native SQl query. But I couln't get it through the hibernate CRITERIA. Can anyone please help me in this?

Thanks
Harish
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic