Hello!
I have looked every where for a way to solve my problemt, but the only examples are like

DetachedCriteria weights = DetachedCriteria.forClass(Cat.class)
.setProjection( Property.forName("weight") );
session.createCriteria(Cat.class)
.add( Subqueries.geAll("weight", weights) )
.list();

But what i want it's the equivalent of the following sql example:

SELECT *
..FROM Cat c LEFT OUTER JOIN
....( SELECT pedigreeId, catId
........FROM pedigree
........WHERE category = "big"
....) p on c.Id = p.catId
..ORDER BY c.Id ASC
;

This means that some cats have pedigree, and i want the data of ALL cats,
and the pedigree info of the big category, the rest should appear as null.
Does anyone have an idea on how to do it?

Thank you in advance!
FBrum :)

Would something like

do?
The above is the equivalent of the SQL

which is slightly different than yours but should work ?

Thanks for your reply!

The thing is that the SQL works, but the hibernate criteria doesn't!

The reason it's because, when adding the category restriction, this will restrict the cats and not only the pedigree class.

I believe that we should first do a subquery with its restriction, but the problem its how to connect a new criteria with a detached criteria.

I think that there should be a way to do a join between two criterias giving the path association, that in this case would be:


Maybe this feature it's not yet implemented!

Does any one know something about this?

Hi have found a solutions to this problem.