GeeCON Prague 2014*
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


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate subquery" Watch "Hibernate subquery" New topic
Author

Hibernate subquery

Johan den Boer
Greenhorn

Joined: Apr 08, 2008
Posts: 18
Hi

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


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

Joined: Apr 14, 2004
Posts: 10336

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


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
GeeCON Prague 2014
 
subject: Hibernate subquery