Hibernate criteria examples

Here are the domain objects

Here is the example to query on grandchild's property.

Here is the example to query on different children's properties.