Bug 209983

Summary:

Make EclipseLink JPA Junit tests run in MySQL

Product:

z_Archived

Reporter:

Tom Ware <tom.ware>

Component:

Eclipselink

Assignee:

Nobody - feel free to take it <nobody>

Status:

RESOLVED FIXED

QA Contact:

Severity:

normal

Priority:

Keywords:

test

Version:

unspecified

Target Milestone:

---

Hardware:

All

OS:

All

Whiteboard:

Fixed in 1.0M2

Attachments:

Description	Flags
patch for fixes that go in the eclipselink.jpa.test project	none
patch for fixes that go in the eclipselink.core project	none
updated eclipselink.core changes after changes suggested by Guy Pelletier	none

Description Tom Ware

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

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

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

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

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

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

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

2022-06-09 10:20:19 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink