Re: problem with pagination when hibernate result transformer is applied

[fachhoch <fa...@gmail.com>]

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<fa...@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-unsubscribe@wicket.apache.org
> For additional commands, e-mail: users-help@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-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org