Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.1.3

Hi,

I used table-per-class-hierarchy strategy to map one of my tables. The mapping file is like below:

<class name="parent" ...>
<subclass name="child1" .../>
<subclass name="child2" .../>
</class>

How do I support queries that across the subclasses like:

select * from child1 where exists(select * from child2 where child2.prop =...);

Thanks!

I got it by searching through Hibernate documentation.

Use DetachedCriteria to create subQuery.

Then use
Criteria.add(Subqueries.exists(DetachedCriteria))
to append the condition.