Hi I have my domain model like this:

class Parent{
Set child;
long parentID;
String name;
int age;
String surname;

public void addChild(Child child){}
}

Class Child{
Set grandChild;
long childID;
long parentID;
String name;
int age;
String surname;

Parent parent;

public void addGrandChild(GrandChild grandChild){}
}


Class GrandChild{

long childID;
long grandChildID;
String name;
int age;
String surname;
Child child;
}

Basically a relation with of one to many from Parent to Child and one to many from child to grandchild.

I want to get all the parent records along with the child and grand child records using Criteria API and how can I add restrictions like the child age < 45 and grand child age >5 in the Criteria query. Pls help I am new to hibernate.

Sounds like a good use of the Restrictions class. Here's an example of its use using a greaterthan. Just do the query on the central object, get the objects back, and you can just call the getters to get the associated objectsl



Here's a tutorial on using the Hibernate Criteria API:

http://www.hiberbook.com/HiberBookWeb/l ... riteriaapi