Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Criteria for retriving data involving multiple joins  RSS feed

Harish Harry
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


101 |John


1001 |Java |101
1002 |SQL |101


1001 |22
1002 |33


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?

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!