Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 368365

Summary: add DDL support to alter existing tables to add missing fields
Product: z_Archived Reporter: Chris Delahunt <christopher.delahunt>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3    
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
proposed changes. Test to be uploaded seperately
none
patch with test cases
none
slight change to what was already checked in none

Description Chris Delahunt CLA 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 CLA 2012-01-24 12:18:12 EST 
Created attachment 209986 [details]
proposed changes.  Test to be uploaded seperately
Comment 2 Chris Delahunt CLA 2012-01-31 15:18:48 EST 
Created attachment 210333 [details]
patch with test cases
Comment 3 Chris Delahunt CLA 2012-02-01 17:12:06 EST 
Checked in at revision 10787
Comment 4 Chris Delahunt CLA 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 CLA 2012-03-15 12:59:59 EDT 
Last update was checked into main (2.4) at revision 10995
Comment 6 Eclipse Webmaster CLA 2022-06-09 10:18:55 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink