Closed jfrchicanog closed 3 years ago
Internal Exception: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE TINYINT(1) default 0, DISPLAYTEXT VARCHAR(255), EWPREASONCODE VARCHAR(255' at line 1 Error Code: 1064 Call: CREATE TABLE SINGLECHANGE (ID VARCHAR(255) NOT NULL, DELETE TINYINT(1) default 0, DISPLAYTEXT VARCHAR(255), EWPREASONCODE VARCHAR(255), INDEX BIGINT, OMOBILITY_INSERT_COMPONENT_RECOGNIZED VARCHAR(255), OMOBILITY_INSERT_COMPONENT_STUDIED VARCHAR(255), PRIMARY KEY (ID)) Query: DataModifyQuery(sql="CREATE TABLE SINGLECHANGE (ID VARCHAR(255) NOT NULL, DELETE TINYINT(1) default 0, DISPLAYTEXT VARCHAR(255), EWPREASONCODE VARCHAR(255), INDEX BIGINT, OMOBILITY_INSERT_COMPONENT_RECOGNIZED VARCHAR(255), OMOBILITY_INSERT_COMPONENT_STUDIED VARCHAR(255), PRIMARY KEY (ID))") [EL Warning]: 2021-07-07 09:46:49.71--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Table 'ewp.singlechange' doesn't exist Error Code: 1146 Call: ALTER TABLE SINGLECHANGE ADD CONSTRAINT SINGLECHANGE_OMOBILITY_INSERT_COMPONENT_RECOGNIZED FOREIGN KEY (OMOBILITY_INSERT_COMPONENT_RECOGNIZED) REFERENCES OMIBILITYCOMPONENTRECOGNIZED (ID) Query: DataModifyQuery(sql="ALTER TABLE SINGLECHANGE ADD CONSTRAINT SINGLECHANGE_OMOBILITY_INSERT_COMPONENT_RECOGNIZED FOREIGN KEY (OMOBILITY_INSERT_COMPONENT_RECOGNIZED) REFERENCES OMIBILITYCOMPONENTRECOGNIZED (ID)") [EL Warning]: 2021-07-07 09:47:05.77--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_BEFORE_MOBILITY ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDBFRMBLTYcmpRcgnzdBfrMbltyChngsD FOREIGN KEY (cmpRecognizedBeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_BEFORE_MOBILITY ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDBFRMBLTYcmpRcgnzdBfrMbltyChngsD FOREIGN KEY (cmpRecognizedBeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:06.417--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_APPOVED ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTPPVcmpRcgnzdLtstpprvdChngsD FOREIGN KEY (cmpRecognizedLatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_APPOVED ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTPPVcmpRcgnzdLtstpprvdChngsD FOREIGN KEY (cmpRecognizedLatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:07.026--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_DRAFT ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTDRFTcmpRcgnzdLtstDrftChngsD FOREIGN KEY (cmpRecognizedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_DRAFT ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTDRFTcmpRcgnzdLtstDrftChngsD FOREIGN KEY (cmpRecognizedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:08.963--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_DRAFT_CHANGES ADD CONSTRAINT MBLTYLSSTDDLATESTDRAFTCHANGESstddLtstDrftChangesID FOREIGN KEY (studiedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_DRAFT_CHANGES ADD CONSTRAINT MBLTYLSSTDDLATESTDRAFTCHANGESstddLtstDrftChangesID FOREIGN KEY (studiedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:09.921--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_STUDIED_BEFORE_MOBILITY_CHANGES ADD CONSTRAINT MBLTYLSSTDDBFREMOBILITYCHANGESstddbfrMbltyChngesID FOREIGN KEY (studiedbeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_STUDIED_BEFORE_MOBILITY_CHANGES ADD CONSTRAINT MBLTYLSSTDDBFREMOBILITYCHANGESstddbfrMbltyChngesID FOREIGN KEY (studiedbeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:10.342--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_APPROVED_CHANGES ADD CONSTRAINT MBLTYLSSTDDLTSTPPROVEDCHANGESstddltstpprvdChngesID FOREIGN KEY (studiedlatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_APPROVED_CHANGES ADD CONSTRAINT MBLTYLSSTDDLTSTPPROVEDCHANGESstddltstpprvdChngesID FOREIGN KEY (studiedlatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID)")
Internal Exception: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE TINYINT(1) default 0, DISPLAYTEXT VARCHAR(255), EWPREASONCODE VARCHAR(255' at line 1 Error Code: 1064 Call: CREATE TABLE SINGLECHANGE (ID VARCHAR(255) NOT NULL, DELETE TINYINT(1) default 0, DISPLAYTEXT VARCHAR(255), EWPREASONCODE VARCHAR(255), INDEX BIGINT, OMOBILITY_INSERT_COMPONENT_RECOGNIZED VARCHAR(255), OMOBILITY_INSERT_COMPONENT_STUDIED VARCHAR(255), PRIMARY KEY (ID)) Query: DataModifyQuery(sql="CREATE TABLE SINGLECHANGE (ID VARCHAR(255) NOT NULL, DELETE TINYINT(1) default 0, DISPLAYTEXT VARCHAR(255), EWPREASONCODE VARCHAR(255), INDEX BIGINT, OMOBILITY_INSERT_COMPONENT_RECOGNIZED VARCHAR(255), OMOBILITY_INSERT_COMPONENT_STUDIED VARCHAR(255), PRIMARY KEY (ID))") [EL Warning]: 2021-07-07 09:46:49.71--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Table 'ewp.singlechange' doesn't exist Error Code: 1146 Call: ALTER TABLE SINGLECHANGE ADD CONSTRAINT SINGLECHANGE_OMOBILITY_INSERT_COMPONENT_RECOGNIZED FOREIGN KEY (OMOBILITY_INSERT_COMPONENT_RECOGNIZED) REFERENCES OMIBILITYCOMPONENTRECOGNIZED (ID) Query: DataModifyQuery(sql="ALTER TABLE SINGLECHANGE ADD CONSTRAINT SINGLECHANGE_OMOBILITY_INSERT_COMPONENT_RECOGNIZED FOREIGN KEY (OMOBILITY_INSERT_COMPONENT_RECOGNIZED) REFERENCES OMIBILITYCOMPONENTRECOGNIZED (ID)") [EL Warning]: 2021-07-07 09:47:05.77--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_BEFORE_MOBILITY ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDBFRMBLTYcmpRcgnzdBfrMbltyChngsD FOREIGN KEY (cmpRecognizedBeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_BEFORE_MOBILITY ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDBFRMBLTYcmpRcgnzdBfrMbltyChngsD FOREIGN KEY (cmpRecognizedBeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:06.417--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_APPOVED ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTPPVcmpRcgnzdLtstpprvdChngsD FOREIGN KEY (cmpRecognizedLatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_APPOVED ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTPPVcmpRcgnzdLtstpprvdChngsD FOREIGN KEY (cmpRecognizedLatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:07.026--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_DRAFT ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTDRFTcmpRcgnzdLtstDrftChngsD FOREIGN KEY (cmpRecognizedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_COMPONENT_RECOGNIZED_LATEST_DRAFT ADD CONSTRAINT MBLTYLSCMPNNTRCGNZDLTSTDRFTcmpRcgnzdLtstDrftChngsD FOREIGN KEY (cmpRecognizedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:08.963--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_DRAFT_CHANGES ADD CONSTRAINT MBLTYLSSTDDLATESTDRAFTCHANGESstddLtstDrftChangesID FOREIGN KEY (studiedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_DRAFT_CHANGES ADD CONSTRAINT MBLTYLSSTDDLATESTDRAFTCHANGESstddLtstDrftChangesID FOREIGN KEY (studiedLatestDraftChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:09.921--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_STUDIED_BEFORE_MOBILITY_CHANGES ADD CONSTRAINT MBLTYLSSTDDBFREMOBILITYCHANGESstddbfrMbltyChngesID FOREIGN KEY (studiedbeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_STUDIED_BEFORE_MOBILITY_CHANGES ADD CONSTRAINT MBLTYLSSTDDBFREMOBILITYCHANGESstddbfrMbltyChngesID FOREIGN KEY (studiedbeforeMobilityChanges_ID) REFERENCES SINGLECHANGE (ID)") [EL Warning]: 2021-07-07 09:47:10.342--ServerSession(1969527566)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Cannot add foreign key constraint Error Code: 1215 Call: ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_APPROVED_CHANGES ADD CONSTRAINT MBLTYLSSTDDLTSTPPROVEDCHANGESstddltstpprvdChngesID FOREIGN KEY (studiedlatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID) Query: DataModifyQuery(sql="ALTER TABLE OMOBILITY_LAS_STUDIED_LATEST_APPROVED_CHANGES ADD CONSTRAINT MBLTYLSSTDDLTSTPPROVEDCHANGESstddltstpprvdChngesID FOREIGN KEY (studiedlatestApprovedChanges_ID) REFERENCES SINGLECHANGE (ID)")