Criteria Paging is not working

[Charan kumar sarvepalli]

Hi,

I am trying a code using Criteria which i have setFirstResults(20) and setMaxResults(50).

I am expecting the hibernate will load 30 records but it is returning 50 records.

The code is like this

Criteria criteria = session.createCriteria(Customer.class)
    							.createAlias("invoices", "Invoice")
    							.setFetchMode("invoices", FetchMode.LAZY)
    							.add(Restrictions.eq("Invoice.open", 0))
    							.add(Restrictions.eq("id", 4200))
    							.setFirstResult(20)
							    .setMaxResults(50);
List results = criteria.list()
System.out.println("Size"+results.size());

size is 50 i.e. hibernate loaded 50 records.

what is wrong in this.

[David O'Meara]

you asked it to skip 20 then return 50 results. Looks like Hibernate is doing what you asked.
Did you try entering 20,30?

[Charan kumar sarvepalli]

yes, i tried with 20 and 30. it is returning 30 records.

Hibernate generated query (rowNum < ? and rownum > ?) has '?' place holders so i am unable to trace the values of those.

[Christian Dillinger]

firstResult specifies the rownumber of the first result row. maxResults (see the "s") specifies the number of results. so if you want 20 rows you have to set maxResults(20).