Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Criteria for retriving data involving multiple joins

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?

Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic