Attachment 147002 Details for Bug 289023 – Patch for bugs 289019-289023

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

[patch] Patch for bugs 289019-289023

Bugs289019-289023.patch (text/plain), 55.24 KB, created by Tom Ware

on 2009-09-11 16:27:21 EDT

(hide)

Description:

Filename:

MIME Type:

Creator: Tom Ware

Created: 2009-09-11 16:27:21 EDT

Size: 55.24 KB

patch

obsolete

>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/framework/LoadBuildSystem.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/framework/LoadBuildSystem.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/framework/LoadBuildSystem.java	(working copy)
>@@ -93,10 +93,12 @@
>         session.executeNonSelectingCall(new SQLCall("Create table LOADBUILD (id number(10), lbtimestamp date, lberrors number(10), fatalErrors number(10), loginChoice varchar2(100), os varchar2(100), toplink_version varchar(100), jvm varchar2(100), machine varchar2(100), numberOfTests number(10), lbuserName varchar2(50), primary key (id))"));
>         session.executeNonSelectingCall(new SQLCall("Create table RESULT (id number(10), description varchar2(2000), exception varchar2(2000), name varchar2(1000), outcome varchar2(100), test_time number(10), total_time number(10), summaryId number(10), lbuildId number(10), primary key (id))"));
>         session.executeNonSelectingCall(new SQLCall("Create table SUMMARY (id number(10), description varchar2(2000), setup_failures number(10), errors number(10), fatalErrors number(10), name varchar2(1000), passed number(10), problems number(10), setupException varchar2(2000), total_time number(10), totalTests number(10), warnings number(10), lbuildId number(10), parentId number(10), primary key (id))"));
>-        session.executeNonSelectingCall(new SQLCall("ALTER TABLE RESULT ADD CONSTRAINT FK_RESULT_summaryId FOREIGN KEY (summaryId) REFERENCES SUMMARY (id)"));
>-        session.executeNonSelectingCall(new SQLCall("ALTER TABLE RESULT ADD CONSTRAINT FK_RESULT_lbuildId FOREIGN KEY (lbuildId) REFERENCES LOADBUILD (id)"));
>-        session.executeNonSelectingCall(new SQLCall("ALTER TABLE SUMMARY ADD CONSTRAINT FK_LOADBUILD_lbuildId FOREIGN KEY (lbuildId) REFERENCES LOADBUILD (id)"));
>-        session.executeNonSelectingCall(new SQLCall("ALTER TABLE SUMMARY ADD CONSTRAINT FK_LOADBUILD_parentId FOREIGN KEY (parentId) REFERENCES SUMMARY (id)"));
>+        if (session.getPlatform().supportsUniqueKeyConstraints()){
>+            session.executeNonSelectingCall(new SQLCall("ALTER TABLE RESULT ADD CONSTRAINT FK_RESULT_summaryId FOREIGN KEY (summaryId) REFERENCES SUMMARY (id)"));
>+            session.executeNonSelectingCall(new SQLCall("ALTER TABLE RESULT ADD CONSTRAINT FK_RESULT_lbuildId FOREIGN KEY (lbuildId) REFERENCES LOADBUILD (id)"));
>+            session.executeNonSelectingCall(new SQLCall("ALTER TABLE SUMMARY ADD CONSTRAINT FK_LOADBUILD_lbuildId FOREIGN KEY (lbuildId) REFERENCES LOADBUILD (id)"));
>+            session.executeNonSelectingCall(new SQLCall("ALTER TABLE SUMMARY ADD CONSTRAINT FK_LOADBUILD_parentId FOREIGN KEY (parentId) REFERENCES SUMMARY (id)"));
>+        }
>         session.executeNonSelectingCall(new SQLCall("Create INDEX IX_LOADBUILD_lbtimestamp ON LOADBUILD (lbtimestamp)"));
>         session.executeNonSelectingCall(new SQLCall("Create INDEX IX_LOADBUILD_loginChoice ON LOADBUILD (loginChoice)"));
>         session.executeNonSelectingCall(new SQLCall("Create INDEX IX_LOADBUILD_toplink_version ON LOADBUILD (toplink_version)"));
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/employee/relational/EmployeeTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/employee/relational/EmployeeTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/employee/relational/EmployeeTableCreator.java	(working copy)
>@@ -367,7 +367,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/InheritanceSystem.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/InheritanceSystem.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/InheritanceSystem.java	(working copy)
>@@ -118,12 +118,14 @@
>          
>             // Drop old constraints.
>             try {
>-                session.executeNonSelectingSQL("Alter TABLE PROJECT_WORKER_BATCH DROP CONSTRAINT PROJECT_WORKER_BATCH_HD");
>-                session.executeNonSelectingSQL("Alter TABLE PROJECT_BATCH DROP CONSTRAINT PROJECT_WORKER_BATCH_FK");
>-                session.executeNonSelectingSQL("Alter TABLE ALLIGATOR DROP CONSTRAINT FK_ALLIGATOR_VICTIM_ID");
>-                session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_FRND");
>-                session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_REP");
>-                session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_BS");
>+                if (session.getPlatform().supportsUniqueKeyConstraints()){
>+                    session.executeNonSelectingSQL("Alter TABLE PROJECT_WORKER_BATCH DROP CONSTRAINT PROJECT_WORKER_BATCH_HD");
>+                    session.executeNonSelectingSQL("Alter TABLE PROJECT_BATCH DROP CONSTRAINT PROJECT_WORKER_BATCH_FK");
>+                    session.executeNonSelectingSQL("Alter TABLE ALLIGATOR DROP CONSTRAINT FK_ALLIGATOR_VICTIM_ID");
>+                    session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_FRND");
>+                    session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_REP");
>+                    session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_BS");
>+                }
>             } catch (Exception ignore) {}
>         }
>     }
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/InheritanceTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/InheritanceTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/InheritanceTableCreator.java	(working copy)
>@@ -60,7 +60,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -82,7 +82,7 @@
>         FieldDefinition fieldVICTIM_ID = new FieldDefinition();
>         fieldVICTIM_ID.setName("VICTIM_ID");
>         fieldVICTIM_ID.setTypeName("NUMBER");
>-        fieldVICTIM_ID.setSize(19);
>+        fieldVICTIM_ID.setSize(18);
>         fieldVICTIM_ID.setSubSize(0);
>         fieldVICTIM_ID.setIsPrimaryKey(false);
>         fieldVICTIM_ID.setIsIdentity(false);
>@@ -107,7 +107,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -147,7 +147,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -502,7 +502,7 @@
>         FieldDefinition fieldGH_ID = new FieldDefinition();
>         fieldGH_ID.setName("GH_ID");
>         fieldGH_ID.setTypeName("NUMBER");
>-        fieldGH_ID.setSize(19);
>+        fieldGH_ID.setSize(18);
>         fieldGH_ID.setSubSize(0);
>         fieldGH_ID.setIsPrimaryKey(true);
>         fieldGH_ID.setIsIdentity(false);
>@@ -513,7 +513,7 @@
>         FieldDefinition fieldGH_MAXIMUMJUMP = new FieldDefinition();
>         fieldGH_MAXIMUMJUMP.setName("GH_MAXIMUMJUMP");
>         fieldGH_MAXIMUMJUMP.setTypeName("NUMBER");
>-        fieldGH_MAXIMUMJUMP.setSize(19);
>+        fieldGH_MAXIMUMJUMP.setSize(18);
>         fieldGH_MAXIMUMJUMP.setSubSize(0);
>         fieldGH_MAXIMUMJUMP.setIsPrimaryKey(false);
>         fieldGH_MAXIMUMJUMP.setIsIdentity(false);
>@@ -705,7 +705,7 @@
>         FieldDefinition fieldIN_ID = new FieldDefinition();
>         fieldIN_ID.setName("IN_ID");
>         fieldIN_ID.setTypeName("NUMBER");
>-        fieldIN_ID.setSize(19);
>+        fieldIN_ID.setSize(18);
>         fieldIN_ID.setSubSize(0);
>         fieldIN_ID.setIsPrimaryKey(true);
>         fieldIN_ID.setIsIdentity(false);
>@@ -727,7 +727,7 @@
>         FieldDefinition fieldIN_NUMBEROFLEGS = new FieldDefinition();
>         fieldIN_NUMBEROFLEGS.setName("IN_NUMBEROFLEGS");
>         fieldIN_NUMBEROFLEGS.setTypeName("NUMBER");
>-        fieldIN_NUMBEROFLEGS.setSize(19);
>+        fieldIN_NUMBEROFLEGS.setSize(18);
>         fieldIN_NUMBEROFLEGS.setSubSize(0);
>         fieldIN_NUMBEROFLEGS.setIsPrimaryKey(false);
>         fieldIN_NUMBEROFLEGS.setIsIdentity(false);
>@@ -738,7 +738,7 @@
>         FieldDefinition fieldENTOMOLOGIST = new FieldDefinition();
>         fieldENTOMOLOGIST.setName("ENTOMOLOGIST");
>         fieldENTOMOLOGIST.setTypeName("NUMBER");
>-        fieldENTOMOLOGIST.setSize(19);
>+        fieldENTOMOLOGIST.setSize(18);
>         fieldENTOMOLOGIST.setSubSize(0);
>         fieldENTOMOLOGIST.setIsPrimaryKey(false);
>         fieldENTOMOLOGIST.setIsIdentity(false);
>@@ -889,7 +889,7 @@
>         FieldDefinition fieldLB_ID = new FieldDefinition();
>         fieldLB_ID.setName("LB_ID");
>         fieldLB_ID.setTypeName("NUMBER");
>-        fieldLB_ID.setSize(19);
>+        fieldLB_ID.setSize(18);
>         fieldLB_ID.setSubSize(0);
>         fieldLB_ID.setIsPrimaryKey(true);
>         fieldLB_ID.setIsIdentity(false);
>@@ -900,7 +900,7 @@
>         FieldDefinition fieldLB_NUMBEROFSPOTS = new FieldDefinition();
>         fieldLB_NUMBEROFSPOTS.setName("LB_NUMBEROFSPOTS");
>         fieldLB_NUMBEROFSPOTS.setTypeName("NUMBER");
>-        fieldLB_NUMBEROFSPOTS.setSize(19);
>+        fieldLB_NUMBEROFSPOTS.setSize(18);
>         fieldLB_NUMBEROFSPOTS.setSubSize(0);
>         fieldLB_NUMBEROFSPOTS.setIsPrimaryKey(false);
>         fieldLB_NUMBEROFSPOTS.setIsIdentity(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/STI_EmployeeTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/STI_EmployeeTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/inheritance/STI_EmployeeTableCreator.java	(working copy)
>@@ -200,7 +200,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field6 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field6.setName("BUDGET");
>         field6.setTypeName("DOUBLE PRECIS");
>-        field6.setSize(32);
>+        field6.setSize(18);
>         field6.setShouldAllowNull(true);
>         field6.setIsPrimaryKey(false);
>         field6.setUnique(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/insurance/InsuranceTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/insurance/InsuranceTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/insurance/InsuranceTableCreator.java	(working copy)
>@@ -40,7 +40,7 @@
>         FieldDefinition fieldHOLDER_ID = new FieldDefinition();
>         fieldHOLDER_ID.setName("HOLDER_ID");
>         fieldHOLDER_ID.setTypeName("NUMBER");
>-        fieldHOLDER_ID.setSize(19);
>+        fieldHOLDER_ID.setSize(18);
>         fieldHOLDER_ID.setSubSize(0);
>         fieldHOLDER_ID.setIsPrimaryKey(true);
>         fieldHOLDER_ID.setIsIdentity(false);
>@@ -76,7 +76,7 @@
>         FieldDefinition fieldCLM_ID = new FieldDefinition();
>         fieldCLM_ID.setName("CLM_ID");
>         fieldCLM_ID.setTypeName("NUMBER");
>-        fieldCLM_ID.setSize(19);
>+        fieldCLM_ID.setSize(18);
>         fieldCLM_ID.setSubSize(0);
>         fieldCLM_ID.setIsPrimaryKey(true);
>         fieldCLM_ID.setIsIdentity(false);
>@@ -87,7 +87,7 @@
>         FieldDefinition fieldPOL_ID = new FieldDefinition();
>         fieldPOL_ID.setName("POL_ID");
>         fieldPOL_ID.setTypeName("NUMBER");
>-        fieldPOL_ID.setSize(19);
>+        fieldPOL_ID.setSize(18);
>         fieldPOL_ID.setSubSize(0);
>         fieldPOL_ID.setIsPrimaryKey(false);
>         fieldPOL_ID.setIsIdentity(false);
>@@ -109,7 +109,7 @@
>         FieldDefinition fieldAMOUNT = new FieldDefinition();
>         fieldAMOUNT.setName("AMOUNT");
>         fieldAMOUNT.setTypeName("FLOAT");
>-        fieldAMOUNT.setSize(19);
>+        fieldAMOUNT.setSize(18);
>         fieldAMOUNT.setSubSize(4);
>         fieldAMOUNT.setIsPrimaryKey(false);
>         fieldAMOUNT.setIsIdentity(false);
>@@ -131,7 +131,7 @@
>         FieldDefinition fieldAREA = new FieldDefinition();
>         fieldAREA.setName("AREA");
>         fieldAREA.setTypeName("NUMBER");
>-        fieldAREA.setSize(19);
>+        fieldAREA.setSize(18);
>         fieldAREA.setSubSize(4);
>         fieldAREA.setIsPrimaryKey(false);
>         fieldAREA.setIsIdentity(false);
>@@ -156,7 +156,7 @@
>         FieldDefinition fieldSSN = new FieldDefinition();
>         fieldSSN.setName("SSN");
>         fieldSSN.setTypeName("NUMBER");
>-        fieldSSN.setSize(19);
>+        fieldSSN.setSize(18);
>         fieldSSN.setSubSize(0);
>         fieldSSN.setIsPrimaryKey(true);
>         fieldSSN.setIsIdentity(false);
>@@ -229,7 +229,7 @@
>         FieldDefinition fieldSSN = new FieldDefinition();
>         fieldSSN.setName("SSN");
>         fieldSSN.setTypeName("NUMBER");
>-        fieldSSN.setSize(19);
>+        fieldSSN.setSize(18);
>         fieldSSN.setSubSize(0);
>         fieldSSN.setIsPrimaryKey(true);
>         fieldSSN.setIsIdentity(false);
>@@ -309,7 +309,7 @@
>         FieldDefinition fieldHOLDER_SSN = new FieldDefinition();
>         fieldHOLDER_SSN.setName("HOLDER_SSN");
>         fieldHOLDER_SSN.setTypeName("NUMBER");
>-        fieldHOLDER_SSN.setSize(19);
>+        fieldHOLDER_SSN.setSize(18);
>         fieldHOLDER_SSN.setSubSize(0);
>         fieldHOLDER_SSN.setIsPrimaryKey(true);
>         fieldHOLDER_SSN.setIsIdentity(false);
>@@ -367,7 +367,7 @@
>         FieldDefinition fieldPOL_ID = new FieldDefinition();
>         fieldPOL_ID.setName("POL_ID");
>         fieldPOL_ID.setTypeName("NUMBER");
>-        fieldPOL_ID.setSize(19);
>+        fieldPOL_ID.setSize(18);
>         fieldPOL_ID.setSubSize(0);
>         fieldPOL_ID.setIsPrimaryKey(true);
>         fieldPOL_ID.setIsIdentity(false);
>@@ -378,7 +378,7 @@
>         FieldDefinition fieldSSN = new FieldDefinition();
>         fieldSSN.setName("SSN");
>         fieldSSN.setTypeName("NUMBER");
>-        fieldSSN.setSize(19);
>+        fieldSSN.setSize(18);
>         fieldSSN.setSubSize(0);
>         fieldSSN.setIsPrimaryKey(false);
>         fieldSSN.setIsIdentity(false);
>@@ -411,7 +411,7 @@
>         FieldDefinition fieldMAX_COV = new FieldDefinition();
>         fieldMAX_COV.setName("MAX_COV");
>         fieldMAX_COV.setTypeName("NUMBER");
>-        fieldMAX_COV.setSize(19);
>+        fieldMAX_COV.setSize(18);
>         fieldMAX_COV.setSubSize(4);
>         fieldMAX_COV.setIsPrimaryKey(false);
>         fieldMAX_COV.setIsIdentity(false);
>@@ -424,7 +424,7 @@
>         //NUMBER corresponds to long which is mapped to INTEGER data type in some database such as DB2 and MySQL.  
>         //FLOAT should be used which reflect float java type.
>         fieldCOV_RATE.setTypeName("FLOAT(16)");
>-        fieldCOV_RATE.setSize(19);
>+        fieldCOV_RATE.setSize(18);
>         fieldCOV_RATE.setSubSize(4);
>         fieldCOV_RATE.setIsPrimaryKey(false);
>         fieldCOV_RATE.setIsIdentity(false);
>@@ -460,7 +460,7 @@
>         FieldDefinition fieldCLM_ID = new FieldDefinition();
>         fieldCLM_ID.setName("CLM_ID");
>         fieldCLM_ID.setTypeName("NUMBER");
>-        fieldCLM_ID.setSize(19);
>+        fieldCLM_ID.setSize(18);
>         fieldCLM_ID.setSubSize(0);
>         fieldCLM_ID.setIsPrimaryKey(true);
>         fieldCLM_ID.setIsIdentity(false);
>@@ -507,7 +507,7 @@
>         FieldDefinition fieldPOL_ID = new FieldDefinition();
>         fieldPOL_ID.setName("POL_ID");
>         fieldPOL_ID.setTypeName("NUMBER");
>-        fieldPOL_ID.setSize(19);
>+        fieldPOL_ID.setSize(18);
>         fieldPOL_ID.setSubSize(0);
>         fieldPOL_ID.setIsPrimaryKey(true);
>         fieldPOL_ID.setIsIdentity(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/interfaces/InterfaceWithoutTablesSystem.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/interfaces/InterfaceWithoutTablesSystem.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/interfaces/InterfaceWithoutTablesSystem.java	(working copy)
>@@ -53,8 +53,12 @@
>          * There is no possibility of existing instances being messed up, because all the tables are dropped
>          * here as well
>          */
>-        session.executeNonSelectingCall(new org.eclipse.persistence.queries.SQLCall("DELETE FROM SEQUENCE WHERE SEQ_NAME = 'EMAIL_SEQ'"));
>-        session.executeNonSelectingCall(new org.eclipse.persistence.queries.SQLCall("DELETE FROM SEQUENCE WHERE SEQ_NAME = 'PHONE_SEQ'"));
>+        String sequenceTableName = "SEQUENCE";
>+        if (session.getPlatform().getDefaultSequence().isTable()) {
>+            sequenceTableName = session.getPlatform().getQualifiedSequenceTableName();
>+        }
>+        session.executeNonSelectingCall(new org.eclipse.persistence.queries.SQLCall("DELETE FROM " + sequenceTableName + " WHERE SEQ_NAME = 'EMAIL_SEQ'"));
>+        session.executeNonSelectingCall(new org.eclipse.persistence.queries.SQLCall("DELETE FROM " + sequenceTableName  + " WHERE SEQ_NAME = 'PHONE_SEQ'"));
>         schemaManager.createSequences();
>     }
> 
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/onetoonejointable/EmployeeTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/onetoonejointable/EmployeeTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/onetoonejointable/EmployeeTableCreator.java	(working copy)
>@@ -406,7 +406,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/orderedlist/EmployeeTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/orderedlist/EmployeeTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/orderedlist/EmployeeTableCreator.java	(working copy)
>@@ -299,7 +299,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/performance/EmployeeTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/performance/EmployeeTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/models/performance/EmployeeTableCreator.java	(working copy)
>@@ -276,7 +276,7 @@
>         FieldDefinition field1 = new FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/nls/japanese/NLSEmployeeTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/nls/japanese/NLSEmployeeTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/nls/japanese/NLSEmployeeTableCreator.java	(working copy)
>@@ -327,7 +327,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("\u3044\u306a\u3048\u304d\u304a\u3068");//("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/tableswithspacesmodel/EmployeeWithSpacesTableCreator.java
>===================================================================
>--- foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/tableswithspacesmodel/EmployeeWithSpacesTableCreator.java	(revision 5106)
>+++ foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/tableswithspacesmodel/EmployeeWithSpacesTableCreator.java	(working copy)
>@@ -309,7 +309,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/tools/schemaframework/TableDefinition.java
>===================================================================
>--- foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/tools/schemaframework/TableDefinition.java	(revision 5106)
>+++ foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/tools/schemaframework/TableDefinition.java	(working copy)
>@@ -626,29 +626,32 @@
>         if (schemaWriter == null) {
>             this.dropConstraintsOnDatabase(session);
>         } else {
>-            for (ForeignKeyConstraint foreignKey : getForeignKeyMap().values()) {
>-                buildConstraintDeletionWriter(session, foreignKey, schemaWriter).toString();
>-                try {
>-                    if (createSQLFiles) {
>-                        schemaWriter.write(session.getPlatform().getStoredProcedureTerminationToken());
>+            if (session.getPlatform().supportsForeignKeyConstraints()){
>+                for (ForeignKeyConstraint foreignKey : getForeignKeyMap().values()) {
>+                    buildConstraintDeletionWriter(session, foreignKey, schemaWriter).toString();
>+                    try {
>+                        if (createSQLFiles) {
>+                            schemaWriter.write(session.getPlatform().getStoredProcedureTerminationToken());
>+                        }
>+                        schemaWriter.write("\n");
>+                    } catch (IOException exception) {
>+                        throw ValidationException.fileError(exception);
>                     }
>-                    schemaWriter.write("\n");
>-                } catch (IOException exception) {
>-                    throw ValidationException.fileError(exception);
>                 }
>             }
>-                     
>-            for (Enumeration uniqueKeysEnum = getUniqueKeys().elements();
>-                     uniqueKeysEnum.hasMoreElements();) {        
>-                UniqueKeyConstraint uniqueKey = (UniqueKeyConstraint)uniqueKeysEnum.nextElement();
>-                buildUniqueConstraintDeletionWriter(session, uniqueKey, schemaWriter).toString();
>-                try {
>-                    if (createSQLFiles) {                    
>-                        schemaWriter.write(session.getPlatform().getStoredProcedureTerminationToken());
>+            if (session.getPlatform().supportsUniqueKeyConstraints()){
>+                for (Enumeration uniqueKeysEnum = getUniqueKeys().elements();
>+                         uniqueKeysEnum.hasMoreElements();) {        
>+                    UniqueKeyConstraint uniqueKey = (UniqueKeyConstraint)uniqueKeysEnum.nextElement();
>+                    buildUniqueConstraintDeletionWriter(session, uniqueKey, schemaWriter).toString();
>+                    try {
>+                        if (createSQLFiles) {                    
>+                            schemaWriter.write(session.getPlatform().getStoredProcedureTerminationToken());
>+                        }
>+                        schemaWriter.write("\n");
>+                    } catch (IOException exception) {
>+                        throw ValidationException.fileError(exception);
>                     }
>-                    schemaWriter.write("\n");
>-                } catch (IOException exception) {
>-                    throw ValidationException.fileError(exception);
>                 }
>             }
>         }
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/AdvancedTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/AdvancedTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/AdvancedTableCreator.java	(working copy)
>@@ -980,7 +980,7 @@
>         FieldDefinition field1 = new FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>@@ -1168,7 +1168,7 @@
>         FieldDefinition field1 = new FieldDefinition();
>         field1.setName("PURCHASES");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>@@ -1395,7 +1395,7 @@
>         FieldDefinition fieldCOST = new FieldDefinition();
>         fieldCOST.setName("COST");
>         fieldCOST.setTypeName("DOUBLE PRECIS");
>-        fieldCOST.setSize(32);
>+        fieldCOST.setSize(18);
>         table.addField(fieldCOST);
> 
>         FieldDefinition fieldTAGS = new FieldDefinition();
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/compositepk/CompositePKTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/compositepk/CompositePKTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/compositepk/CompositePKTableCreator.java	(working copy)
>@@ -747,8 +747,10 @@
>      */
>     public void replaceTables(DatabaseSession session) {
>         try {
>-            session.executeNonSelectingSQL("Alter table CMP3_SCIENTIST drop constraint CMP3_SCIENTIST_CUBICLE");
>-            session.executeNonSelectingSQL("Alter table CMP3_SCIENTIST drop constraint CMP3_SCIENTIST_DEPT");
>+            if (session.getPlatform().supportsUniqueKeyConstraints()){
>+                session.executeNonSelectingSQL("Alter table CMP3_SCIENTIST drop constraint CMP3_SCIENTIST_CUBICLE");
>+                session.executeNonSelectingSQL("Alter table CMP3_SCIENTIST drop constraint CMP3_SCIENTIST_DEPT");
>+            }
>         } catch (Exception ignore) {}
>         super.replaceTables(session);
>     }
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/complexaggregate/ComplexAggregateTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/complexaggregate/ComplexAggregateTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/complexaggregate/ComplexAggregateTableCreator.java	(working copy)
>@@ -45,7 +45,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(true);
>@@ -100,7 +100,7 @@
>         FieldDefinition fieldWORLDID = new FieldDefinition();
>         fieldWORLDID.setName("WORLD_ID");
>         fieldWORLDID.setTypeName("NUMBER");
>-        fieldWORLDID.setSize(19);
>+        fieldWORLDID.setSize(18);
>         fieldWORLDID.setSubSize(0);
>         fieldWORLDID.setIsPrimaryKey(false);
>         fieldWORLDID.setIsIdentity(false);
>@@ -119,7 +119,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -174,7 +174,7 @@
>         FieldDefinition fieldWORLDID = new FieldDefinition();
>         fieldWORLDID.setName("WORLD_ID");
>         fieldWORLDID.setTypeName("NUMBER");
>-        fieldWORLDID.setSize(19);
>+        fieldWORLDID.setSize(18);
>         fieldWORLDID.setSubSize(0);
>         fieldWORLDID.setIsPrimaryKey(false);
>         fieldWORLDID.setIsIdentity(false);
>@@ -193,7 +193,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -259,7 +259,7 @@
>         FieldDefinition fieldTEAMID = new FieldDefinition();
>         fieldTEAMID.setName("TEAM_ID");
>         fieldTEAMID.setTypeName("NUMBER");
>-        fieldTEAMID.setSize(19);
>+        fieldTEAMID.setSize(18);
>         fieldTEAMID.setSubSize(0);
>         fieldTEAMID.setIsPrimaryKey(false);
>         fieldTEAMID.setIsIdentity(false);
>@@ -278,7 +278,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("PLAYERID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -366,7 +366,7 @@
>         FieldDefinition fieldTEAMID = new FieldDefinition();
>         fieldTEAMID.setName("TEAM_ID");
>         fieldTEAMID.setTypeName("NUMBER");
>-        fieldTEAMID.setSize(19);
>+        fieldTEAMID.setSize(18);
>         fieldTEAMID.setSubSize(0);
>         fieldTEAMID.setIsPrimaryKey(false);
>         fieldTEAMID.setIsIdentity(false);
>@@ -385,7 +385,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -447,7 +447,7 @@
>         FieldDefinition fieldPLAYERID = new FieldDefinition();
>         fieldPLAYERID.setName("PLAYER_ID");
>         fieldPLAYERID.setTypeName("NUMBER");
>-        fieldPLAYERID.setSize(19);
>+        fieldPLAYERID.setSize(18);
>         fieldPLAYERID.setSubSize(0);
>         fieldPLAYERID.setIsPrimaryKey(false);
>         fieldPLAYERID.setIsIdentity(false);
>@@ -459,7 +459,7 @@
>         FieldDefinition fieldROLEID = new FieldDefinition();
>         fieldROLEID.setName("ROLE_ID");
>         fieldROLEID.setTypeName("NUMBER");
>-        fieldROLEID.setSize(19);
>+        fieldROLEID.setSize(18);
>         fieldROLEID.setSubSize(0);
>         fieldROLEID.setIsPrimaryKey(false);
>         fieldROLEID.setIsIdentity(false);
>@@ -478,7 +478,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -507,7 +507,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/datatypes/DataTypesTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/datatypes/DataTypesTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/datatypes/DataTypesTableCreator.java	(working copy)
>@@ -91,7 +91,7 @@
>         FieldDefinition fieldLONGDATA = new FieldDefinition();
>         fieldLONGDATA.setName("LONG_DATA");
>         fieldLONGDATA.setTypeName("NUMERIC");
>-        fieldLONGDATA.setSize(19);
>+        fieldLONGDATA.setSize(18);
>         fieldLONGDATA.setIsPrimaryKey(false);
>         fieldLONGDATA.setIsIdentity(false);
>         fieldLONGDATA.setUnique(false);
>@@ -147,7 +147,7 @@
>         FieldDefinition fieldBIGDECIMALDATA = new FieldDefinition();
>         fieldBIGDECIMALDATA.setName("BIGDECIMAL_DATA");
>         fieldBIGDECIMALDATA.setTypeName("NUMERIC");
>-        fieldBIGDECIMALDATA.setSize(38);
>+        fieldBIGDECIMALDATA.setSize(18);
>         fieldBIGDECIMALDATA.setSubSize(0);
>         fieldBIGDECIMALDATA.setIsPrimaryKey(false);
>         fieldBIGDECIMALDATA.setIsIdentity(false);
>@@ -158,7 +158,7 @@
>         FieldDefinition fieldBIGINTEGERDATA = new FieldDefinition();
>         fieldBIGINTEGERDATA.setName("BIGINTEGER_DATA");
>         fieldBIGINTEGERDATA.setTypeName("NUMERIC");
>-        fieldBIGINTEGERDATA.setSize(38);
>+        fieldBIGINTEGERDATA.setSize(18);
>         fieldBIGINTEGERDATA.setSubSize(0);
>         fieldBIGINTEGERDATA.setIsPrimaryKey(false);
>         fieldBIGINTEGERDATA.setIsIdentity(false);
>@@ -215,7 +215,7 @@
>         FieldDefinition fieldLONGDATA = new FieldDefinition();
>         fieldLONGDATA.setName("LONG_DATA");
>         fieldLONGDATA.setTypeName("NUMERIC");
>-        fieldLONGDATA.setSize(19);
>+        fieldLONGDATA.setSize(18);
>         fieldLONGDATA.setIsPrimaryKey(false);
>         fieldLONGDATA.setIsIdentity(false);
>         fieldLONGDATA.setUnique(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/fieldaccess/advanced/AdvancedTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/fieldaccess/advanced/AdvancedTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/fieldaccess/advanced/AdvancedTableCreator.java	(working copy)
>@@ -694,7 +694,7 @@
>         FieldDefinition field1 = new FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>@@ -919,7 +919,7 @@
>         FieldDefinition field1 = new FieldDefinition();
>         field1.setName("PURCHASES");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>@@ -1139,7 +1139,7 @@
>         FieldDefinition fieldCOST = new FieldDefinition();
>         fieldCOST.setName("COST");
>         fieldCOST.setTypeName("DOUBLE PRECIS");
>-        fieldCOST.setSize(32);
>+        fieldCOST.setSize(18);
>         table.addField(fieldCOST);
> 
>         FieldDefinition fieldTAGS = new FieldDefinition();
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/inheritance/InheritanceTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/inheritance/InheritanceTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/inheritance/InheritanceTableCreator.java	(working copy)
>@@ -1671,7 +1671,9 @@
>      */
>     public void replaceTables(DatabaseSession session) {
>         try {
>-            session.executeNonSelectingSQL("Alter table CMP3_ENGINEER_LAPTOP drop constraint CMP3_ENGINEER_LAPTOP_FK1");
>+            if (session.getPlatform().supportsUniqueKeyConstraints()){
>+                session.executeNonSelectingSQL("Alter table CMP3_ENGINEER_LAPTOP drop constraint CMP3_ENGINEER_LAPTOP_FK1");
>+            }
>         } catch (Exception ignore) {}
>         super.replaceTables(session);
>     }
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/lob/LobTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/lob/LobTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/lob/LobTableCreator.java	(working copy)
>@@ -53,7 +53,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(38);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/orphanremoval/OrphanRemovalModelTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/orphanremoval/OrphanRemovalModelTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/orphanremoval/OrphanRemovalModelTableCreator.java	(working copy)
>@@ -47,7 +47,7 @@
>         FieldDefinition serialNumber = new FieldDefinition();
>         serialNumber.setName("SERIALNUMBER");
>         serialNumber.setTypeName("NUMERIC");
>-        serialNumber.setSize(19);
>+        serialNumber.setSize(18);
>         serialNumber.setSubSize(0);
>         serialNumber.setIsPrimaryKey(false);
>         serialNumber.setIsIdentity(false);
>@@ -145,7 +145,7 @@
>         FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
>         fieldSERIALNUMBER.setName("SERIALNUMBER");
>         fieldSERIALNUMBER.setTypeName("NUMERIC");
>-        fieldSERIALNUMBER.setSize(19);
>+        fieldSERIALNUMBER.setSize(18);
>         fieldSERIALNUMBER.setSubSize(0);
>         fieldSERIALNUMBER.setIsPrimaryKey(false);
>         fieldSERIALNUMBER.setIsIdentity(false);
>@@ -175,7 +175,7 @@
>         FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
>         fieldSERIALNUMBER.setName("SERIALNUMBER");
>         fieldSERIALNUMBER.setTypeName("NUMERIC");
>-        fieldSERIALNUMBER.setSize(19);
>+        fieldSERIALNUMBER.setSize(18);
>         fieldSERIALNUMBER.setSubSize(0);
>         fieldSERIALNUMBER.setIsPrimaryKey(false);
>         fieldSERIALNUMBER.setIsIdentity(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/performance/EmployeeTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/performance/EmployeeTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/performance/EmployeeTableCreator.java	(working copy)
>@@ -276,7 +276,7 @@
>         FieldDefinition field1 = new FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true);
>         field1.setIsPrimaryKey(false);
>         field1.setUnique(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/privateowned/PrivateOwnedModelTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/privateowned/PrivateOwnedModelTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/privateowned/PrivateOwnedModelTableCreator.java	(working copy)
>@@ -46,7 +46,7 @@
>         FieldDefinition serialNumber = new FieldDefinition();
>         serialNumber.setName("SERIALNUMBER");
>         serialNumber.setTypeName("NUMERIC");
>-        serialNumber.setSize(19);
>+        serialNumber.setSize(18);
>         serialNumber.setSubSize(0);
>         serialNumber.setIsPrimaryKey(false);
>         serialNumber.setIsIdentity(false);
>@@ -145,7 +145,7 @@
>         FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
>         fieldSERIALNUMBER.setName("SERIALNUMBER");
>         fieldSERIALNUMBER.setTypeName("NUMERIC");
>-        fieldSERIALNUMBER.setSize(19);
>+        fieldSERIALNUMBER.setSize(18);
>         fieldSERIALNUMBER.setSubSize(0);
>         fieldSERIALNUMBER.setIsPrimaryKey(false);
>         fieldSERIALNUMBER.setIsIdentity(false);
>@@ -175,7 +175,7 @@
>         FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
>         fieldSERIALNUMBER.setName("SERIALNUMBER");
>         fieldSERIALNUMBER.setTypeName("NUMERIC");
>-        fieldSERIALNUMBER.setSize(19);
>+        fieldSERIALNUMBER.setSize(18);
>         fieldSERIALNUMBER.setSubSize(0);
>         fieldSERIALNUMBER.setIsPrimaryKey(false);
>         fieldSERIALNUMBER.setIsIdentity(false);
>@@ -225,7 +225,7 @@
>         FieldDefinition fieldSERIALNUMBER = new FieldDefinition();
>         fieldSERIALNUMBER.setName("SERIALNUMBER");
>         fieldSERIALNUMBER.setTypeName("NUMERIC");
>-        fieldSERIALNUMBER.setSize(19);
>+        fieldSERIALNUMBER.setSize(18);
>         fieldSERIALNUMBER.setSubSize(0);
>         fieldSERIALNUMBER.setIsPrimaryKey(false);
>         fieldSERIALNUMBER.setIsIdentity(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/Customer.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/Customer.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/Customer.java	(working copy)
>@@ -49,7 +49,7 @@
>     @Id
>     @GeneratedValue(strategy=TABLE, generator="CUSTOMER_TABLE_GENERATOR")
>     @TableGenerator(
>-        name="CUSTOMER_GENERATOR_TABLE", 
>+        name="CUSTOMER_TABLE_GENERATOR", 
>         table="CMP3_CUSTOMER_SEQ", 
>         pkColumnName="SEQ_NAME", 
>         valueColumnName="SEQ_COUNT",
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/Lego.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/Lego.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/Lego.java	(working copy)
>@@ -32,7 +32,7 @@
>     @Id
>     @GeneratedValue(strategy=TABLE, generator="MANUFACTURER_TABLE_GENERATOR")
>     @TableGenerator(
>-        name="MANUFACTURER_GENERATOR_TABLE", 
>+        name="MANUFACTURER_TABLE_GENERATOR", 
>         table="CMP3_MANUFACTURER_SEQ", 
>         pkColumnName="SEQ_NAME", 
>         valueColumnName="SEQ_COUNT",
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/MegaBrands.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/MegaBrands.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/relationships/MegaBrands.java	(working copy)
>@@ -32,7 +32,7 @@
>     @Id
>     @GeneratedValue(strategy=TABLE, generator="DISTRIBUTOR_TABLE_GENERATOR")
>     @TableGenerator(
>-        name="DISTRIBUTOR_GENERATOR_TABLE", 
>+        name="DISTRIBUTOR_TABLE_GENERATOR", 
>         table="CMP3_DISTRIBUTOR_SEQ", 
>         pkColumnName="SEQ_NAME", 
>         valueColumnName="SEQ_COUNT",
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/advanced/AdvancedTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/advanced/AdvancedTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/advanced/AdvancedTableCreator.java	(working copy)
>@@ -561,7 +561,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/complexaggregate/ComplexAggregateTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/complexaggregate/ComplexAggregateTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/complexaggregate/ComplexAggregateTableCreator.java	(working copy)
>@@ -44,7 +44,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(true);
>@@ -99,7 +99,7 @@
>         FieldDefinition fieldWORLDID = new FieldDefinition();
>         fieldWORLDID.setName("WORLD_ID");
>         fieldWORLDID.setTypeName("NUMBER");
>-        fieldWORLDID.setSize(19);
>+        fieldWORLDID.setSize(18);
>         fieldWORLDID.setSubSize(0);
>         fieldWORLDID.setIsPrimaryKey(false);
>         fieldWORLDID.setIsIdentity(false);
>@@ -118,7 +118,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -173,7 +173,7 @@
>         FieldDefinition fieldWORLDID = new FieldDefinition();
>         fieldWORLDID.setName("WORLD_ID");
>         fieldWORLDID.setTypeName("NUMBER");
>-        fieldWORLDID.setSize(19);
>+        fieldWORLDID.setSize(18);
>         fieldWORLDID.setSubSize(0);
>         fieldWORLDID.setIsPrimaryKey(false);
>         fieldWORLDID.setIsIdentity(false);
>@@ -192,7 +192,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("PLAYERID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -375,7 +375,7 @@
>         FieldDefinition fieldOWNERID = new FieldDefinition();
>         fieldOWNERID.setName("OWNER_ID");
>         fieldOWNERID.setTypeName("NUMBER");
>-        fieldOWNERID.setSize(19);
>+        fieldOWNERID.setSize(18);
>         fieldOWNERID.setSubSize(0);
>         fieldOWNERID.setIsPrimaryKey(false);
>         fieldOWNERID.setIsIdentity(false);
>@@ -394,7 +394,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -433,7 +433,7 @@
>         FieldDefinition fieldPLAYERID = new FieldDefinition();
>         fieldPLAYERID.setName("PLAYER_ID");
>         fieldPLAYERID.setTypeName("NUMBER");
>-        fieldPLAYERID.setSize(19);
>+        fieldPLAYERID.setSize(18);
>         fieldPLAYERID.setSubSize(0);
>         fieldPLAYERID.setIsPrimaryKey(false);
>         fieldPLAYERID.setIsIdentity(false);
>@@ -445,7 +445,7 @@
>         FieldDefinition fieldROLEID = new FieldDefinition();
>         fieldROLEID.setName("ROLE_ID");
>         fieldROLEID.setTypeName("NUMBER");
>-        fieldROLEID.setSize(19);
>+        fieldROLEID.setSize(18);
>         fieldROLEID.setSubSize(0);
>         fieldROLEID.setIsPrimaryKey(false);
>         fieldROLEID.setIsIdentity(false);
>@@ -464,7 +464,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>@@ -521,7 +521,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(false);
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/merge/incompletemappings/owning/AdvancedTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/merge/incompletemappings/owning/AdvancedTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/merge/incompletemappings/owning/AdvancedTableCreator.java	(working copy)
>@@ -262,7 +262,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/relationships/unidirectional/AdvancedTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/relationships/unidirectional/AdvancedTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/xml/relationships/unidirectional/AdvancedTableCreator.java	(working copy)
>@@ -280,7 +280,7 @@
>         org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 = new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
>         field1.setName("BUDGET");
>         field1.setTypeName("DOUBLE PRECIS");
>-        field1.setSize(32);
>+        field1.setSize(18);
>         field1.setShouldAllowNull(true );
>         field1.setIsPrimaryKey(false );
>         field1.setUnique(false );
>Index: jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/metamodel/MetamodelTableCreator.java
>===================================================================
>--- jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/metamodel/MetamodelTableCreator.java	(revision 5112)
>+++ jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/metamodel/MetamodelTableCreator.java	(working copy)
>@@ -928,7 +928,7 @@
> /*        FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("GALACTIC_ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(true);
>@@ -950,7 +950,7 @@
>         /*FieldDefinition fieldID2 = new FieldDefinition();
>         fieldID2.setName("PK_PART2");
>         fieldID2.setTypeName("NUMBER");
>-        fieldID2.setSize(19);
>+        fieldID2.setSize(18);
>         fieldID2.setSubSize(0);
>         fieldID2.setIsPrimaryKey(true);
>         fieldID2.setIsIdentity(true);
>@@ -1019,7 +1019,7 @@
> /*        FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("LOCATION_ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(true);
>@@ -1030,7 +1030,7 @@
>         /*FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("PK_PART1");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(true);
>@@ -1041,7 +1041,7 @@
>         /*FieldDefinition fieldID2 = new FieldDefinition();
>         fieldID2.setName("PK_PART2");
>         fieldID2.setTypeName("NUMBER");
>-        fieldID2.setSize(19);
>+        fieldID2.setSize(18);
>         fieldID2.setSubSize(0);
>         fieldID2.setIsPrimaryKey(true);
>         fieldID2.setIsIdentity(true);
>@@ -1086,7 +1086,7 @@
>         FieldDefinition fieldID = new FieldDefinition();
>         fieldID.setName("GALACTIC_ID");
>         fieldID.setTypeName("NUMBER");
>-        fieldID.setSize(19);
>+        fieldID.setSize(18);
>         fieldID.setSubSize(0);
>         fieldID.setIsPrimaryKey(true);
>         fieldID.setIsIdentity(true);

Actions: View | Diff

Attachments on bug 289023: 147002