openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (OPENJPA-1580) Using firstResult and maxResults in queries is not working properly
Date Fri, 19 Mar 2010 15:21:27 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Fay Wang resolved OPENJPA-1580.
-------------------------------

       Resolution: Fixed
    Fix Version/s: 2.1.0

> 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
>             Fix For: 2.1.0
>
>         Attachments: OPENJPA-1580.patch, openjpa1580.tar
>
>
> 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.


Mime
View raw message