Hi: I have a many to many relationship like this

Class A {

set <B>
}

Class B {
Set <a>
}

I am in a situation where when I retrieve object B through Object A, I would like to have a limit on the composed object, that is object B. According to my understanding I can limit the number of rows for Object A by calling setMaxResults on the Query object, but I am not sure how can I limit the number of objects returned by the query for objectB. BTW I am using lazy evaluation so my code looks like this

List<ObjectA> result = session.createQuery("from ObjectA objectA where objectA.id = :id ").setParameter("id", id).list();
ObjectA objectA= result.get(0);

Set<ObjectB> seObjectB = ObjectA.getObjectB(); //Here I only want to return a limited number of rows instead of thousands of rows

Thanks,
RJ

You can use a collection filter. There is an example (tenKittens) in the documentation http://docs.jboss.org/hibernate/stable/ ... -filtering

Thanks for the help, it worked like a charm.

Regards,
RJ.