Re: problem with pagination when hibernate result transformer is applied
here one more concern i did not mention before . lets say total records per page is 20 and the query fetched 2 items and each item has 10 bids, so sql query will have 20 records and result transformer will reduce it to two records and user will see just 2 records instead of 20 per page ? is there a solution for this ? James Carman-3 wrote: > > 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 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 > > > -- View this message in context: http://www.nabble.com/problem-with-pagination-when-hibernate-result-transformer-is-applied-tp24608353p24627326.html Sent from the Wicket - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@wicket.apache.org For additional commands, e-mail: users-h...@wicket.apache.org
Re: problem with pagination when hibernate result transformer is applied
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 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
problem with pagination when hibernate result transformer is applied
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 ?
