Using firstResult and maxResults in queries is not working properly
-------------------------------------------------------------------
Key: OPENJPA-1580
URL: https://issues.apache.org/jira/browse/OPENJPA-1580
Project: OpenJPA
Issue Type: Bug
Affects Versions: 2.0.0-beta2
Environment: Ubuntu 9.10, Maven 2.2.1, Spring 3.0.1
Reporter: Oliver Ringel
Hi again,
I try to implement a paged resultset using the firstResult and maxResults
method of the Query class. It seems that this is not working as expected.
Here is the relevant part of the logging.
DEBUG,Query,main] Executing query: select s from SimpleEntity s order by s.id
[DEBUG,SQL,main] <t 2132679615, conn 651497704> executing prepstmnt 558185842
SELECT LIMIT 0 2 t0.id, t0.version, t0.base, t0.street, t0.my_name FROM
some_objects t0 ORDER BY t0.id ASC
[DEBUG,Query,main] Executing query: select s from SimpleEntity s order by s.id
[DEBUG,SQL,main] <t 2132679615, conn 651497704> executing prepstmnt 2094184728
SELECT LIMIT 0 2 t0.id, t0.version, t0.base, t0.street, t0.my_name FROM
some_objects t0 ORDER BY t0.id ASC
Both queries are identical. So my guess is once more the trouble comes from the
query cache.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
