Hibernate version: 2.1.6

This is a silly question but, I can't seem to figure this out:

I'm paging through many rows in a database and only want to show certain values (eg: rows 75 - 100 or something like that). Can somebody please tell me how to set a start row so I wouldn't have to scroll through 0-100 to get to 75-100? See the code below:

Session session = null;
try {
session = getSession();
Query query = session.createQuery(QUERY_STRING);
query.setMaxResults((PAGE_SIZE);
ScrollableResults rs = query.scroll();
rs.setRowNumber(rowNumber); // this doesn't work if the row number is higher than PAGE_SIZE
List results = new ArrayList(PAGE_SIZE);
boolean hasMoreRows = true;
for (int i=0; i<PAGE_SIZE; i++) {
if (!rs.next()) {
hasMoreRows = false;
break;
}
results.add(rs.get(0));
}

If you use setMaxResults(PAGE_SIZE) then hibernate will not return more than PAGE_SIZE

I think that mixed setMaxResults() and ScrollableResult is wrong
regards

Thanks, that solved my problem.

Joe

I want to start the cursor at row 5000:



However the second approach does not start the cursor at position 5000, it starts at 0.

So I guess the setFirstResult(5000).setMaxResults(500). slows the fetching down. I use DB2, so I prefer to use ScrollableResults, but I want to begin fetching at row x. How can I set it via ScrollableResults ???

How can I proof, if a ScrollableResults is open? Something like:

ScrollableResults resultSet ;




any ideas?