You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Donald Woods (JIRA)" <ji...@apache.org> on 2009/05/07 15:46:30 UTC
[jira] Updated: (OPENJPA-1002) Select range doesn't work on Oracle
JDBC driver
[ https://issues.apache.org/jira/browse/OPENJPA-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Donald Woods updated OPENJPA-1002:
----------------------------------
Patch Info: [Patch Available]
Summary: Select range doesn't work on Oracle JDBC driver (was: [PATCH] Select range doesn't work on Oracle JDBC driver)
Still needs to be applied to 1.3.x.
> 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
> Fix For: 1.3.0, 2.0.0
>
> 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.