I have a strange behaviour with the Criteria.setFirstResult method.

In my db there is a table items containing 100 items with id's from 1 to 100

When I query the items with

criteria.setFirstResult(1);
criteria.setMaxResults(20);

It returns the items 21 to 40.

But when I do this:
criteria.setFirstResult(0);
criteria.setMaxResults(20);

Only the first 10 items are returned. It seems that when FirstResult=0, always the first 10 items are returned.

Can someone explain this behaviour to me?

It should work...

setFirstResulst counts from zero. So to itterate over 100 entriies, it should be something like:

//first 20 results
setFirstResult(0)
setMaxResults(20)

//second 20 resutls
setFirstResult(20)
setMaxresults(20)

etc...

Regards,
Pavol