Hi,
I have test the following on Hibernate version: 2.1.7 and preior and got the same results.

When I use setFirstResults on a query like this:

Query query =
session.createSQLQuery("select {table.*} from TABLE {table}");

query = query.setFirstResults(lastOffset + pageSize);

List l = query.list();

Then it is OK and each time the list contains the next required records.

But when I am trying to select from more then one table (either by join or not) like this:


Query query =
session.createSQLQuery("select {table_a.*}, {table_b.*} from TABLE_A {table_a}, TABLE_B {table_b} where table_a.field = table_b.field");

query = query.setFirstResults(lastOffset + pageSize);

List l = query.list();

Then I always get the same first results like the cursor begins always from position 0 (Althogh I can see that SQLQueryImpl holds the firstResults value that I gave it.

Is there a way to bypass that behavior?

I'll quess that you batch size of retrieving the records is larger or as large as your resultset.
Try to use .setMaxResults(maxPerPage)[/b] on your query and make sure maxPerPage is less then your resultset size.

Hi,

I didn;t mantioned it before because I have found in my tests that it is irrelevant but I did use setMaxResults and maxPerPage is way less then what the table is containing.

Is it less then what the query is containing?

Yes sure, sorry for not making it clear...

Show your configuration and mapping. I don't see why this shouldn't work. Maybe somebody else has an idea on this?

Hi,

Please, if you are familer with the related problem reply to that message I need help about it.


I have test the following on Hibernate version: 2.1.7 and preior and got the same results.

When I use setFirstResults on a query like this:

Query query =
session.createSQLQuery("select {table.*} from TABLE {table}");

query = query.setFirstResults(lastOffset + pageSize);

List l = query.list();

Then it is OK and each time the list contains the next required records.

But when I am trying to select from more then one table (either by join or not) like this:


Query query =
session.createSQLQuery("select {table_a.*}, {table_b.*} from TABLE_A {table_a}, TABLE_B {table_b} where table_a.field = table_b.field");

query = query.setFirstResults(lastOffset + pageSize);

List l = query.list();

Then I always get the same first results like the cursor begins always from position 0 (Althogh I can see that SQLQueryImpl holds the firstResults value that I gave it.

Is there a way to bypass that behavior?