Bug 209983 - Make EclipseLink JPA Junit tests run in MySQL
Summary: Make EclipseLink JPA Junit tests run in MySQL
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard: Fixed in 1.0M2
Keywords: test
Depends on:
Blocks:
 
Reported: 2007-11-15 11:38 EST by Tom Ware CLA
Modified: 2022-06-09 10:20 EDT (History)
0 users

See Also:

Attachments
patch for fixes that go in the eclipselink.jpa.test project (7.84 KB, patch)
2007-11-15 11:46 EST, Tom Ware CLA 		no flags Details | Diff
patch for fixes that go in the eclipselink.core project (2.38 KB, patch)
2007-11-15 11:46 EST, Tom Ware CLA 		no flags Details | Diff
updated eclipselink.core changes after changes suggested by Guy Pelletier (2.37 KB, patch)
2007-11-15 13:31 EST, Tom Ware CLA 		no flags Details | Diff
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Ware CLA 2007-11-15 11:38:21 EST 
There are several failures in the JPA FullRegressionTestSuite when running on MySQL.  Diagnose these failures and ensure it is possible to run this suite on MySQL by either fixing the tests, fixing the underlying code, or changing the tests so log a warning and filing abug

MySQL will be used as the test server for our nightly builds.  In order to run automated testing we will need our test suites to run on an Open source DB.  We have chosen MySQL because of its feature set (compared to Derby) and the accessibility of an instance of MySQL on the Eclispe build server.
Comment 1 Tom Ware CLA 2007-11-15 11:46:05 EST 
Created attachment 82976 [details]
patch for fixes that go in the eclipselink.jpa.test project
Comment 2 Tom Ware CLA 2007-11-15 11:46:27 EST 
Created attachment 82977 [details]
patch for fixes that go in the eclipselink.core project
Comment 3 Tom Ware CLA 2007-11-15 11:48:41 EST 
Attaching two patch files

1. Fix to MySQL4Platform and DatabasePlatform to allow stored procedure calls to be written properly
2. Test fixes to throw a warning on an Oracle-only test and fix the cleanup of one test

These changes solve all but one problem on MySQL in FullRegressionTestSuite.  That problem is already solved by a separate transaction that is currently in progress.
Comment 4 Tom Ware CLA 2007-11-15 11:52:22 EST 
Note: No new tests have been added for this bug because it specifically fixes broken test cases.  To test the bug, run the JPA FullRegressionTestSuite on MySQL.
Comment 5 Tom Ware CLA 2007-11-15 13:31:44 EST 
Created attachment 82988 [details]
updated eclipselink.core changes after changes suggested by Guy Pelletier
Comment 6 Tom Ware CLA 2007-11-15 13:51:03 EST 
The attached changes have been checked in.  See above for description of changes and how it was tested.

The JUnit JPA tests have been run against both Oracle and MySQL to verify this fix.

Reviewed by Guy Pelletier
Comment 7 Eclipse Webmaster CLA 2022-06-09 10:20:19 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink