Hi,

I am a newbie to Hibernate.

I searched for paging in this forum and came with a lot of hits, sorry if this has been answered already.

In my Seam page, I display a list of records from a table called Tax which has a One-To-Many with a table called Item

So in my Tax entity class, I have


On my Tax list page, I use a EntityQuery backed list with paging controls which use firstResult parameter to limit the rows.

When I click a tax on the list page, I now display a list of associated items.
So Hibernate will fire the query getItems() above.

My problem is how do I limit rows returned from getItems() and having paging controls for it. I can't do setFirstResult() and setMaxResults() ?

thanks for any guidance.

Regards
Franco

Check out if the Session.createFilter() may help you. It seems like it returns a Query object that is applied to a collection. Here is a link to some examples:
http://www.hibernate.org/hib_docs/v3/re ... -filtering

Thanks.

I had to make a call to getItems() from my EntityHome object in Seam, after plugging in a createFilter, it seems like getItems() gets called for as many rows that I have in the relation.

Sorry, can't post the code - using my home laptop now.

I think it will work, just have to play with it a little bit more.

Franco