[ https://issues.apache.org/jira/browse/OPENJPA-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12701048#action_12701048 ]
Ravi P Palacherla commented on OPENJPA-1002: -------------------------------------------- Can someone please commit my changes on the head revision. Thanks, Ravi. > select range doesn't work on Oracle JDBC driver > ----------------------------------------------- > > Key: OPENJPA-1002 > URL: https://issues.apache.org/jira/browse/OPENJPA-1002 > Project: OpenJPA > Issue Type: Bug > Components: jdbc > Affects Versions: 1.1.0 > Environment: OS: windows XP professional > java version 1.5.0_14 > Oracle jdbc driver 10.2.0.1.0 > Reporter: Amy Yang > Attachments: 1002.patch, 1002_Headtrunk.patch, > TestEagerOuterToManyJoins1.java > > > Select range doesn't work on Oracle with Oracle jdbc driver 10.2.0.1.0. > The test case is like below: > OpenJPAEntityManager pm =(OpenJPAEntityManager)currentEntityManager(); > FetchPlan fetch = (FetchPlan) pm.getFetchPlan(); > fetch.addField(EagerOuterJoinPC.class, "stringList"); > fetch.setFetchBatchSize(3); > OpenJPAQuery q = pm.createQuery(JPQLParser.LANG_JPQL, > "select x from EagerOuterJoinPC x order by x.name asc"); > q.setFirstResult(5).setMaxResults(15); > > List results = (List) q.getResultList(); > assertEquals(5, results.size()); > The assertion passed on Derby. But failed on Oracle: > junit.framework.AssertionFailedError: expected:<5> but was:<10> > at junit.framework.Assert.fail(Assert.java:47) > at junit.framework.Assert.failNotEquals(Assert.java:282) > at junit.framework.Assert.assertEquals(Assert.java:64) > at junit.framework.Assert.assertEquals(Assert.java:201) > at junit.framework.Assert.assertEquals(Assert.java:207) > at > org.apache.openjpa.persistence.jdbc.meta.TestEagerOuterToManyJoins.testQueryRange(TestEagerOuterToManyJoins.java:679) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at junit.framework.TestCase.runTest(TestCase.java:154) > at junit.framework.TestCase.runBare(TestCase.java:127) > at junit.framework.TestResult$1.protect(TestResult.java:106) > at junit.framework.TestResult.runProtected(TestResult.java:124) > at junit.framework.TestResult.run(TestResult.java:109) > at junit.framework.TestCase.run(TestCase.java:118) > at > org.apache.openjpa.persistence.test.PersistenceTestCase.run(PersistenceTestCase.java:127) > at junit.framework.TestSuite.runTest(TestSuite.java:208) > at junit.framework.TestSuite.run(TestSuite.java:203) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:213) > at > org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140) > at > org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127) > at org.apache.maven.surefire.Surefire.run(Surefire.java:177) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:334) > at > org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:980) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.