Hibernate version 2.1.7

If I use setFirstResult and setMaxResults to perform pagination in a web application, how can I tell if I reached the last result from a query b/c there were no more records in the database or b/c I reached maxResults. I'm looking for a method something like waslimitedByMaxRows() just like one would have available in the jstl api for javax.servlet.jsp.jstl.sql.Result.

I suppose one could do an sql count to see how many records actually exist. Or when maxResults is reached one could do a second query with setMaxResult(1) and setFirstResult(startRow+maxResults) and if this returns a list greater then zero one would know that the previous query was limited by setMaxResults.

Thanks,
Jason

Works in (max-1)/max cases

I guess I was looking for the works 100% of the time solution. So that I wouldn't display a "next" link to the user for the next set of results unless there really were more results. However, I guess it really isn't necessary since most of the time or as you say "(max-1/max)" of the time you will know that the results are finished by the results found being less than max.

Perhaps someday a limitedByMaxResults method could be implemented in net.sf.hibernate.collection.PersistentCollection or net.sf.hibernate.Collection.

Thanks for your help,
Jason

Actially you can do setMaxResults(max+1) and display only max result, you can then play with it the limit