368365 – add DDL support to alter existing tables to add missing fields

This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.

Bug 368365 - add DDL support to alter existing tables to add missing fields

Summary: add DDL support to alter existing tables to add missing fields

Status:	RESOLVED FIXED

Alias:	None

Product:	z_Archived
Classification:	Eclipse Foundation
Component:	Eclipselink (show other bugs)
Version:	unspecified
Hardware:	All All

Importance:	P3 enhancement (vote)
Target Milestone:	---
Assignee:	Nobody - feel free to take it
QA Contact:

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2012-01-11 10:58 EST by Chris Delahunt
Modified:	2022-06-09 10:18 EDT (History)
CC List:	0 users

See Also:

Attachments
proposed changes. Test to be uploaded seperately (22.88 KB, patch) 2012-01-24 12:18 EST, Chris Delahunt	no flags	Details \| Diff
patch with test cases (37.92 KB, patch) 2012-01-31 15:18 EST, Chris Delahunt	no flags	Details \| Diff
slight change to what was already checked in (9.22 KB, patch) 2012-02-10 15:02 EST, Chris Delahunt	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 Chris Delahunt

2012-01-11 10:58:33 EST

EclipseLink currently only supports create and drop-and-create DDL generation.  This feature is to allow creating tables if missing, and modify existing tables to add missing fields required by the model.  
The goal being to allow testing to reuse existing test data - avoiding the need to drop and create tables and then repopulate data on each time the model changes.  

This feature could also be used with Extensibility to add columns, potentialy within a PAS Manager (providing a non-JTA datasource).

Comment 1 Chris Delahunt

2012-01-24 12:18:12 EST

Created attachment 209986 [details]
proposed changes.  Test to be uploaded seperately

Comment 2 Chris Delahunt

2012-01-31 15:18:48 EST

Created attachment 210333 [details]
patch with test cases

Comment 3 Chris Delahunt

2012-02-01 17:12:06 EST

Checked in at revision 10787

Comment 4 Chris Delahunt

2012-02-10 15:02:22 EST

Created attachment 210871 [details]
slight change to what was already checked in

This is a slight change to automatically create the table and then look for fields rather than the other way around.  This works around an issue with our automated testing where some of the table exist in a different schema: this feature cannot distinguish between different schemas until https://bugs.eclipse.org/bugs/show_bug.cgi?id=367887 is resolved.

Comment 5 Chris Delahunt

2012-03-15 12:59:59 EDT

Last update was checked into main (2.4) at revision 10995

Comment 6 Eclipse Webmaster

2022-06-09 10:18:55 EDT

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