Hi,

Now there are two objects in my J2EE projects.One is A,the other is B,
and the relationship between A and B is many-to-many. I can get many B objects that related by a A object as follow:

A a=(A)session.get(A.class,1);
Set bs=a.getB();

So my question is i can't paging with query.setFirstResult() and query.setMaxResult() hql statement.

thank you!

You could use a criteriaQuery to select the instances of B for A=foo
In this case paging is possible.

Regards

Sebastian

Ok,i'll try it,thank you!