Best Practice Pagination with OneToMany Mapping

[cy23]

hi there,

a LinkRubric has many Links.

Its mapped like this:

@OneToMany(cascade = { CascadeType.ALL },
 fetch = FetchType.LAZY, mappedBy="linkRubric")

i can get out a LinkRubric with that statment:

SELECT p
FROM LinkRubric p
WHERE p.topRubricID = '5'

I put "Lazy Loading" to on, so my links are loaded when this object is beeing accessed. However, i don't want to load all that links at once. My cleint gives me the page and the max_links_per_page params, and i want to limit the size of the links.

Does anyone have an idea about how to realize this?
thanks,
chris

[jc7442]

Query.setMaxResults(int)

[cy23]

Well,
in that case i have my LinkRubrics limited, but i want to limit the Links in the collection within the LinkRubrics.

Thanks,
Chris

[jc7442]

IN EJBQL, you can force the fetch

left join fetch x.ys

I don' think you can choose to fetch only some of the element of the collection