openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Lee (JIRA)" <>
Subject [jira] [Commented] (OPENJPA-2356) Use new Offset/Limit/ROWNUM features in DB2 family of databases for range queries
Date Mon, 06 May 2013 00:00:16 GMT


Albert Lee commented on OPENJPA-2356:

commit r1459918 cause the following failure when run against Oracle. It passed with Derby.

     73   <testcase time="2.058" classname="org.apache.openjpa.persistence.jdbc.meta.TestRangeQuery"
     74     <failure message="expected:&lt;5&gt; but was:&lt;0&gt;" type="junit.framework.AssertionFailedError">junit.framework.AssertionFailedError:
expected:&lt;5&gt; but was:&lt;0&gt;
     75   at
     76   at junit.framework.Assert.failNotEquals(
     77   at junit.framework.Assert.assertEquals(
     78   at junit.framework.Assert.assertEquals(
     79   at junit.framework.Assert.assertEquals(
     80   at org.apache.openjpa.persistence.jdbc.meta.TestRangeQuery.testQueryRange(
     81   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

> Use new Offset/Limit/ROWNUM features in DB2 family of databases for range queries
> ---------------------------------------------------------------------------------
>                 Key: OPENJPA-2356
>                 URL:
>             Project: OpenJPA
>          Issue Type: Improvement
>            Reporter: Pinaki Poddar
>            Assignee: Pinaki Poddar
>             Fix For: 2.3.0
> JPA queries that use setFirstResult() and/or setMaxResult() translate to some form of
Offset and Limit syntax in database SQL query. Recently DB2 and Derby has added ROWNUM and
FETCH offset respectively.
> OpenJPA should use these facilities when appropriate.   

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message