Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes Object Relational Mapping and the fly likes Hibernate subquery Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate subquery" Watch "Hibernate subquery" New topic

Hibernate subquery

Johan den Boer

Joined: Apr 08, 2008
Posts: 18

How can I do this query in hibernate using criteria, projections, restrictions

select * from my_table where id = (select id from other_table where name = 'abc')

thanks a lot


Johan<br /> <br />scjp, scjd
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

The HQL is not that different. What have you tried?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Have you tried LearnNowOnline?
subject: Hibernate subquery