Do a different query to ask how many there are than the one you use to return the data.
On Wed, Jul 22, 2009 at 11:10 AM, tubin gen<fachh...@gmail.com> wrote: > I am using hibernate criteria query to get data for my > AjaxFallbackDefaultDataTable, this datatable also gives me pagination > parameters which I am apply to criteria. .The entity I am using for the > criteria query has a lazy load collection ,and I need the size of the > collection in the view , so If I donot eager fetch collection I end up > with n+1 selects .So to eager fetch collection and not to have duplicater > records I added result transformer Criteria.DISTINCT_ROOT_ENTITY anmd > fetchmode join . > Now the problem is with pagination , > for example I have item and bids and the criteria query to fetch items with > eager fetch for bids , suppose query selects one item and this item has > 2 bids the query returns total 3 records and total record count will be 3 > and now when I apply result transformer three records will reduce to one > record , but pagination information will be wrong , please help me how to > resolve this ? > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org