Hi all,
taking my first steps into the deeper workings of Hibernate i come across the following problem (at least for me) :
Let's say i have three Tables in the DB ->
Child / Parents / Country
And i want to query for a child with name A and his Parents should live in Germany

but i dont know how i have to do this in Hibernate with the Criteria classes
since 1 CriteriaEntry is always for 1 Alias (Child in my case).
CriteriaEntry(alias,expression) -> in my case the expression is an AndExpression -> for both the name and the Country

the query i need to get is easy
select * from child where name = 'A' and parents in (select id from Parents where country = (select id from Country where name = 'Germany'))

how should i handle this with these Criterion and Expressions ?
anyone ?

It looks like a child contains an association to a parent, and a parent contains an association to a country. Yes? It would help if you post your mappings.

If that's the case, then you're going to end up with something like this.



I'd suggest rereading section 16.4 for more info.