We have a relation Object(one)-Attributes(many) and we would like to display page by page the objects along with the associated attributes.

Doing a fetch join would load the attributes, eliminate duplicates using a LinkedHashMap we are able to display correctly the data. But if the data set is large displaying all objects in a page is not an option.

If we enable paging and still do a fetch the results are not complete-as the recordset is limited to pageNumber, an object will lack some/all attributes depending of the select order.

One solution would be to page without fetching the association and for each object in that page do a fetch of attributes(n+1 selects).

Is there a simpler/more efficient solution to this?