Hi. I am calling setMaxResults on a Criteria instance and I pass it 1000 as the argument. The entity that I am running the query against is a view, and there are 13 rows in the view that I am running the query for. I am only receiving 10 rows back. This is taking place in a test environment, and there are no other updates taking place that remove rows from the view.

There is no other Criteria specified. I am only setting setMaxResults, and then calling list(). I just want row count <= N rows back. Why am I not receiving all 13 rows back? I am seeing the same problem on a different table that has > 200 rows. I specify 200, and I get back 10.

Any ideas?

Thanks.

Hibernate 3.2

Try setFirstResult(0)?

Also check property "hibernate.jdbc.fetch_size" is not set to 10

Thanks a lot! Looks like setFirstResults(0) did the trick...

When you pass 0 as the argument, this method says "start at the first row".