Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sorting not honored with JPA and Oracle #30146

Open
ajaypaul-ibm opened this issue Nov 13, 2024 · 1 comment
Open

Sorting not honored with JPA and Oracle #30146

ajaypaul-ibm opened this issue Nov 13, 2024 · 1 comment

Comments

@ajaypaul-ibm
Copy link
Contributor

When running a Jakarta Data test against Oracle there is an issue with sorting not always being honored. To recreate, remove the @SkipIfSysProp(DB_Oracle) in JakartaDataRecreateServlet.java (open-liberty/dev/com.ibm.ws.jpa.tests.jpa_32_fat/test-applications/jakartadata/src/io/openliberty/jpa/data/tests/web/JakartaDataRecreateServlet.java)

@Test
 @SkipIfSysProp({ DB_Oracle }) 
 // Reference issue: https://github.com/OpenLiberty/open-liberty/issues/28289
 // DB2 issue resolved (https://github.com/eclipse-ee4j/eclipselink/issues/2282), Oracle now has issues too
 public void testOLGH28289() throws Exception {

This individual test can be run against Oracle with the following command:
 ./gradlew com.ibm.ws.jpa.tests.jpa_32_fat:buildAndRun -Dfat.test.use.remote.docker=true -Dfat.bucket.db.type=Oracle
The test should fail because a Package with id 70077 is returned first when Package with id 70071 should be returned first.
You can find the recreate here : https://github.com/OpenLiberty/open-liberty/blob/integration/dev/com.ibm.ws.jpa.tests.jpa_32_fat/test-applications/jakartadata/src/io/openliberty/jpa/data/tests/web/JakartaDataRecreateServlet.java#L1132

Note: A similar issue was found in the DB2 database, which was resolved by this PR: #30076. The root cause was a problem with inserting values into DB2.

@ajaypaul-ibm
Copy link
Contributor Author

EL issue eclipse-ee4j/eclipselink#2301

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant