Guys,
Have anyone used the Criteria Object of Hibernate?
I have a Member object which has "careers" and "educations" as collections. For querying Members whose Career.A = x
careerCriteria = criteria.createCriteria("careers");
careerCriteria.add(...);

But I have to query Members just that, either Career.A is "X" or Education.B is "X".

Is it possible to add a criteria like that? What do you suggest?
PS: I use Hibernate3

Best Regards.
Onur.

Try this:

membersCriteria = createCriteria(Member.class);
membersCriteria.add(
Restrictions.disjunction()
.add(Subqueries.propertyEq("careers", careersCriteria))
.add(Subqueries.propertyEq("educations", educationsCriteria)))

AFAIK there is no way to perform joins in criteria subqueries, so i'm not sure there's another way (except for going HQL...)

The thing is,
using Subqueries.properyEq(String, DetachedCriteria), how will I say
Educations.A = x

in the code quoted, membersCriteria is instance of Criteria, however this method requests DetachedCriteria

The subqueries are created as DetachedCriteria. There shouldn't be any difference from a regular query. For example,



The external query will return only those members that the subquries succeeded for. You may need to use DISTINCT_ROOT_ENTITY though, to avoid duplicate members.

HTH