Skipping 2,628 KB..
Full LogTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTestTest
[junit] Error Code: 1050
[junit] Call: CREATE TABLE DDL_CKENT_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE DDL_CKENT_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:28:56.027--ServerSession(2072998261)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'CMP3_MERGE_BEER_SEQ' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE CMP3_MERGE_BEER_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE CMP3_MERGE_BEER_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:28:56.028--ServerSession(2072998261)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'JDO_SEQUENCE' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE JDO_SEQUENCE (ID VARCHAR(50) NOT NULL, SEQUENCE_VALUE DECIMAL(38), PRIMARY KEY (ID))
[junit] Query: DataModifyQuery(sql="CREATE TABLE JDO_SEQUENCE (ID VARCHAR(50) NOT NULL, SEQUENCE_VALUE DECIMAL(38), PRIMARY KEY (ID))")
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.049--ServerSession(405660971)--The tenant discriminator context property for the tenant discriminator column [DDL_CONTRACT.TENANT_ID] on the element [class org.eclipse.persistence.testing.models.jpa.ddlgeneration.multitenant.Contract] is being defaulted to: eclipselink.tenant-id.
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.049--ServerSession(405660971)--You have specified multiple ids for the entity class [org.eclipse.persistence.testing.models.jpa.ddlgeneration.multitenant.MafiaFamily] without specifying an @IdClass. By doing this you may lose the ability to find by identity, distributed cache support etc. Note: You may however use EntityManager find operations by passing a list of primary key fields. Else, you will have to use JPQL queries to read your entities. For other id options see @PrimaryKey.
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.05--ServerSession(405660971)--The reference column name [Cliente] mapped on the element [field operaciones] does not correspond to a valid id or basic field/column on the mapping reference. Will use referenced column name as provided.
[junit] [EL Info]: 2021-12-16 05:28:56.059--ServerSession(405660971)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.062--ServerSession(405660971)--Parent Entity Mafioso has an isolation level of: ISOLATED which is more protective then the subclass Underboss with isolation: null so the subclass has been set to the isolation level ISOLATED.
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.063--ServerSession(405660971)--Parent Entity Mafioso has an isolation level of: ISOLATED which is more protective then the subclass Soldier with isolation: null so the subclass has been set to the isolation level ISOLATED.
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.063--ServerSession(405660971)--isNullAllowed is reset to false in org.eclipse.persistence.mappings.AggregateObjectMapping[mapHolderEmbedded] because the aggregate has a (possibly nested) target foreign key mapping
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.064--ServerSession(405660971)--isNullAllowed is reset to false in org.eclipse.persistence.mappings.AggregateObjectMapping[contactInfo] because the aggregate has a (possibly nested) target foreign key mapping
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.064--ServerSession(405660971)--Parent Entity Mafioso has an isolation level of: ISOLATED which is more protective then the subclass Capo with isolation: null so the subclass has been set to the isolation level ISOLATED.
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.064--ServerSession(405660971)--Parent Entity Mafioso has an isolation level of: ISOLATED which is more protective then the subclass Boss with isolation: null so the subclass has been set to the isolation level ISOLATED.
[junit] [EL Warning]: metadata: 2021-12-16 05:28:56.064--ServerSession(405660971)--isNullAllowed is reset to false in org.eclipse.persistence.mappings.AggregateObjectMapping[patentCollection] because the aggregate has a (possibly nested) target foreign key mapping
[junit] [EL Info]: connection: 2021-12-16 05:28:56.066--ServerSession(405660971)--/ddlGeneration_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:28:56.174--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'DDL_CKENTA' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE DDL_CKENTA (F_NAME VARCHAR(64) NOT NULL, L_NAME VARCHAR(64) NOT NULL, SEQ INTEGER NOT NULL, B_CODE VARCHAR(64), B_SEQ BIGINT, B_UNQ1 VARCHAR(255), B_UNQ2 VARCHAR(255), PRIMARY KEY (F_NAME, L_NAME, SEQ))
[junit] Query: DataModifyQuery(sql="CREATE TABLE DDL_CKENTA (F_NAME VARCHAR(64) NOT NULL, L_NAME VARCHAR(64) NOT NULL, SEQ INTEGER NOT NULL, B_CODE VARCHAR(64), B_SEQ BIGINT, B_UNQ1 VARCHAR(255), B_UNQ2 VARCHAR(255), PRIMARY KEY (F_NAME, L_NAME, SEQ))")
[junit] [EL Warning]: 2021-12-16 05:28:56.465--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ecltest.DDL_CKENT_C_B' doesn't exist
[junit] Error Code: 1146
[junit] Call: CREATE INDEX INDEX_BS ON DDL_CKENT_C_B (C_SEQ, C_ROLE)
[junit] Query: DataModifyQuery(sql="CREATE INDEX INDEX_BS ON DDL_CKENT_C_B (C_SEQ, C_ROLE)")
[junit] [EL Warning]: 2021-12-16 05:28:57.104--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'DDL_EMP' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE DDL_EMP (ID INTEGER NOT NULL, JUSTTOTEST SMALLINT, PRIMARY KEY (ID))
[junit] Query: DataModifyQuery(sql="CREATE TABLE DDL_EMP (ID INTEGER NOT NULL, JUSTTOTEST SMALLINT, PRIMARY KEY (ID))")
[junit] [EL Warning]: 2021-12-16 05:28:57.254--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'Foos' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE Foos (ordinal_nbr INTEGER NOT NULL, contact_id INTEGER NOT NULL, PRIMARY KEY (ordinal_nbr, contact_id))
[junit] Query: DataModifyQuery(sql="CREATE TABLE Foos (ordinal_nbr INTEGER NOT NULL, contact_id INTEGER NOT NULL, PRIMARY KEY (ordinal_nbr, contact_id))")
[junit] [EL Warning]: 2021-12-16 05:28:57.35--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'Countries' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE Countries (iso_code VARCHAR(50) NOT NULL, name VARCHAR(255), PRIMARY KEY (iso_code))
[junit] Query: DataModifyQuery(sql="CREATE TABLE Countries (iso_code VARCHAR(50) NOT NULL, name VARCHAR(255), PRIMARY KEY (iso_code))")
[junit] [EL Warning]: 2021-12-16 05:28:57.478--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'DDL_COURSE' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE DDL_COURSE (ID BIGINT NOT NULL, PRIMARY KEY (ID))
[junit] Query: DataModifyQuery(sql="CREATE TABLE DDL_COURSE (ID BIGINT NOT NULL, PRIMARY KEY (ID))")
[junit] [EL Warning]: 2021-12-16 05:28:58.814--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: Cannot add foreign key constraint
[junit] Error Code: 1215
[junit] Call: ALTER TABLE DDL_CKENTA ADD CONSTRAINT FK_DDL_CKENTA_B_UNQ1 FOREIGN KEY (B_UNQ1, B_UNQ2) REFERENCES DDL_CKENTB (UNQ1, UNQ2)
[junit] Query: DataModifyQuery(sql="ALTER TABLE DDL_CKENTA ADD CONSTRAINT FK_DDL_CKENTA_B_UNQ1 FOREIGN KEY (B_UNQ1, B_UNQ2) REFERENCES DDL_CKENTB (UNQ1, UNQ2)")
[junit] [EL Warning]: 2021-12-16 05:28:58.924--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: Cannot add foreign key constraint
[junit] Error Code: 1215
[junit] Call: ALTER TABLE DDL_CKENTC ADD CONSTRAINT FK_DDL_CKENTC_A_F_NAME FOREIGN KEY (A_F_NAME, A_L_NAME, A_SEQ) REFERENCES DDL_CKENTA (F_NAME, L_NAME, SEQ)
[junit] Query: DataModifyQuery(sql="ALTER TABLE DDL_CKENTC ADD CONSTRAINT FK_DDL_CKENTC_A_F_NAME FOREIGN KEY (A_F_NAME, A_L_NAME, A_SEQ) REFERENCES DDL_CKENTA (F_NAME, L_NAME, SEQ)")
[junit] [EL Warning]: 2021-12-16 05:29:01.109--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: Cannot add foreign key constraint
[junit] Error Code: 1215
[junit] Call: ALTER TABLE DDL_CKENT_C_B ADD CONSTRAINT FK_DDL_CKENT_C_B_C_SEQ FOREIGN KEY (C_SEQ, C_ROLE) REFERENCES DDL_CKENTC (SEQ, C_ROLE)
[junit] Query: DataModifyQuery(sql="ALTER TABLE DDL_CKENT_C_B ADD CONSTRAINT FK_DDL_CKENT_C_B_C_SEQ FOREIGN KEY (C_SEQ, C_ROLE) REFERENCES DDL_CKENTC (SEQ, C_ROLE)")
[junit] [EL Warning]: 2021-12-16 05:29:03.036--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'CMP3_MERGE_BEER_SEQ' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE CMP3_MERGE_BEER_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE CMP3_MERGE_BEER_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:29:03.036--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'DDL_CKENT_SEQ' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE DDL_CKENT_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE DDL_CKENT_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:29:03.036--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'JDO_SEQUENCE' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE JDO_SEQUENCE (ID VARCHAR(50) NOT NULL, SEQUENCE_VALUE DECIMAL(38), PRIMARY KEY (ID))
[junit] Query: DataModifyQuery(sql="CREATE TABLE JDO_SEQUENCE (ID VARCHAR(50) NOT NULL, SEQUENCE_VALUE DECIMAL(38), PRIMARY KEY (ID))")
[junit] [EL Warning]: 2021-12-16 05:29:03.037--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'SEQUENCE' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:29:03.037--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'DDL_CKENT_SEQ' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE DDL_CKENT_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE DDL_CKENT_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:29:03.038--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'CMP3_MERGE_BEER_SEQ' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE CMP3_MERGE_BEER_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE CMP3_MERGE_BEER_SEQ (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:29:03.038--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'JDO_SEQUENCE' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE JDO_SEQUENCE (ID VARCHAR(50) NOT NULL, SEQUENCE_VALUE DECIMAL(38), PRIMARY KEY (ID))
[junit] Query: DataModifyQuery(sql="CREATE TABLE JDO_SEQUENCE (ID VARCHAR(50) NOT NULL, SEQUENCE_VALUE DECIMAL(38), PRIMARY KEY (ID))")
[junit] [EL Warning]: 2021-12-16 05:29:03.038--ServerSession(405660971)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'SEQUENCE' already exists
[junit] Error Code: 1050
[junit] Call: CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))
[junit] Query: DataModifyQuery(sql="CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))")
[junit] [EL Warning]: 2021-12-16 05:29:03.106--UnitOfWork(1737786335)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'FEE_AMOUNT' cannot be null
[junit] Error Code: 1048
[junit] Call: INSERT INTO PURCHASE (ID, FEE_AMOUNT, FEE_ID) VALUES (?, ?, ?)
[junit] bind => [3 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.Purchase@7915c35)
[junit] [EL Warning]: 2021-12-16 05:29:03.108--UnitOfWork(403128496)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'PARCEL_NUMBER' cannot be null
[junit] Error Code: 1048
[junit] Call: INSERT INTO PropertyRecord_PROPERTYINFOS (PropertyRecord_ID, CITY, PLUSFOUR, STREET_NAME, STATE, ZIPNUM, PARCEL_NUMBER, SQUARE_FEET, ASSESSMENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
[junit] bind => [9 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.PropertyInfo@b341d18)
[junit] [EL Warning]: 2021-12-16 05:29:03.121--UnitOfWork(1104037990)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'COLUMN1'
[junit] Error Code: 1062
[junit] Call: INSERT INTO DDL_UCENTITY1 (ID, COLUMN1, COLUMN2, COLUMN31, COLUMN32) VALUES (?, ?, ?, ?, ?)
[junit] bind => [5 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.UniqueConstraintsEntity1@778582cc)
[junit] [EL Warning]: 2021-12-16 05:29:03.123--UnitOfWork(861663178)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'UCforColumn2'
[junit] Error Code: 1062
[junit] Call: INSERT INTO DDL_UCENTITY1 (ID, COLUMN1, COLUMN2, COLUMN31, COLUMN32) VALUES (?, ?, ?, ?, ?)
[junit] bind => [5 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.UniqueConstraintsEntity1@639672b3)
[junit] [EL Warning]: 2021-12-16 05:29:03.126--UnitOfWork(1295390543)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1-1' for key 'UNQ_DDL_UCENTITY1_0'
[junit] Error Code: 1062
[junit] Call: INSERT INTO DDL_UCENTITY1 (ID, COLUMN1, COLUMN2, COLUMN31, COLUMN32) VALUES (?, ?, ?, ?, ?)
[junit] bind => [5 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.UniqueConstraintsEntity1@638800f8)
[junit] [EL Warning]: 2021-12-16 05:29:03.138--UnitOfWork(862563524)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'COLUMN1'
[junit] Error Code: 1062
[junit] Call: INSERT INTO DDL_UCENTITY2 (ID, COLUMN1, COLUMN2, COLUMN31, COLUMN32) VALUES (?, ?, ?, ?, ?)
[junit] bind => [5 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.UniqueConstraintsEntity2@25686c8f)
[junit] [EL Warning]: 2021-12-16 05:29:03.14--UnitOfWork(894464766)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'UNQ_DDL_UCENTITY2_0'
[junit] Error Code: 1062
[junit] Call: INSERT INTO DDL_UCENTITY2 (ID, COLUMN1, COLUMN2, COLUMN31, COLUMN32) VALUES (?, ?, ?, ?, ?)
[junit] bind => [5 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.UniqueConstraintsEntity2@5583b232)
[junit] [EL Warning]: 2021-12-16 05:29:03.143--UnitOfWork(1643864475)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1-1' for key 'UNQ_DDL_UCENTITY2_1'
[junit] Error Code: 1062
[junit] Call: INSERT INTO DDL_UCENTITY2 (ID, COLUMN1, COLUMN2, COLUMN31, COLUMN32) VALUES (?, ?, ?, ?, ?)
[junit] bind => [5 parameters bound]
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.ddlgeneration.UniqueConstraintsEntity2@7d8a4444)
[junit] Dec 16, 2021 5:29:03 AM org.eclipse.persistence.session.JPASessionXML
[junit] INFO: EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] Dec 16, 2021 5:29:03 AM org.eclipse.persistence.session.JPASessionXML.connection
[junit] INFO: JPASessionXML login successful
[junit] Dec 16, 2021 5:29:03 AM org.eclipse.persistence.session.JPASessionXML
[junit] WARNING:
[junit] Local Exception Stack:
[junit] Exception [EclipseLink-6015] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.QueryException
[junit] Exception Description: Invalid query key [name1] in expression.
[junit] Query: ReadObjectQuery(referenceClass=Customer )
[junit] at org.eclipse.persistence.exceptions.QueryException.invalidQueryKeyInExpression(QueryException.java:697)
[junit] at org.eclipse.persistence.internal.expressions.QueryKeyExpression.validateNode(QueryKeyExpression.java:1011)
[junit] at org.eclipse.persistence.expressions.Expression.normalize(Expression.java:3291)
[junit] at org.eclipse.persistence.internal.expressions.DataExpression.normalize(DataExpression.java:369)
[junit] at org.eclipse.persistence.internal.expressions.QueryKeyExpression.normalize(QueryKeyExpression.java:758)
[junit] at org.eclipse.persistence.internal.expressions.QueryKeyExpression.normalize(QueryKeyExpression.java:671)
[junit] at org.eclipse.persistence.internal.expressions.RelationExpression.normalize(RelationExpression.java:841)
[junit] at org.eclipse.persistence.internal.expressions.SQLSelectStatement.normalize(SQLSelectStatement.java:1521)
[junit] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.buildNormalSelectStatement(ExpressionQueryMechanism.java:559)
[junit] at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.prepareSelectOneRow(ExpressionQueryMechanism.java:1767)
[junit] at org.eclipse.persistence.queries.ReadObjectQuery.prepare(ReadObjectQuery.java:787)
[junit] at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:673)
[junit] at org.eclipse.persistence.queries.ObjectLevelReadQuery.checkPrepare(ObjectLevelReadQuery.java:911)
[junit] at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:622)
[junit] at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:879)
[junit] at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134)
[junit] at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:441)
[junit] at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3281)
[junit] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1863)
[junit] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
[junit] at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1796)
[junit] at org.eclipse.persistence.internal.sessions.AbstractSession.readObject(AbstractSession.java:3717)
[junit] at org.eclipse.persistence.testing.tests.jpa.jpaadvancedproperties.JPAAdvPropertiesJUnitTestCase.testExceptionHandlerProperty(JPAAdvPropertiesJUnitTestCase.java:149)
[junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[junit] at java.lang.reflect.Method.invoke(Method.java:498)
[junit] at junit.framework.TestCase.runTest(TestCase.java:176)
[junit] at junit.framework.TestCase.runBare(TestCase.java:141)
[junit] at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:650)
[junit] at junit.framework.TestResult$1.protect(TestResult.java:122)
[junit] at junit.framework.TestResult.runProtected(TestResult.java:142)
[junit] at junit.framework.TestResult.run(TestResult.java:125)
[junit] at junit.framework.TestCase.run(TestCase.java:129)
[junit] at junit.framework.TestSuite.runTest(TestSuite.java:252)
[junit] at junit.framework.TestSuite.run(TestSuite.java:247)
[junit] at junit.framework.TestSuite.runTest(TestSuite.java:252)
[junit] at junit.framework.TestSuite.run(TestSuite.java:247)
[junit] at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248)
[junit] at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:211)
[junit] at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313)
[junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:534)
[junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:1196)
[junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:1041)
[junit]
[junit] [EL Info]: 2021-12-16 05:29:03.912--ServerSession(2050181190)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] Profile(
[junit] total time=62217,
[junit] local time=62217,
[junit] Timer:Logging=62217,
[junit] )
[junit] Profile(
[junit] total time=1480527,
[junit] local time=1480527,
[junit] Timer:ConnectionManagement=1480527,
[junit] )
[junit] [EL Info]: connection: 2021-12-16 05:29:03.915--ServerSession(2050181190)--/JPAADVProperties2_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] Profile(
[junit] total time=26030,
[junit] local time=26030,
[junit] Timer:Logging=26030,
[junit] )
[junit] [EL Warning]: metamodel: 2021-12-16 05:29:03.915--The collection of metamodel types is empty. Model classes may not have been found during entity search for Java SE and some Java EE container managed persistence units. Please verify that your entity classes are referenced in persistence.xml using either <class> elements or a global <exclude-unlisted-classes>false</exclude-unlisted-classes> element
[junit] [EL Info]: 2021-12-16 05:29:03.916--ServerSession(105087396)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:29:03.917--ServerSession(105087396)--/JPAADVProperties3_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: metamodel: 2021-12-16 05:29:03.918--The collection of metamodel types is empty. Model classes may not have been found during entity search for Java SE and some Java EE container managed persistence units. Please verify that your entity classes are referenced in persistence.xml using either <class> elements or a global <exclude-unlisted-classes>false</exclude-unlisted-classes> element
[junit] [EL Info]: connection: 2021-12-16 05:29:04.225--ServerSession(849028726)--/ddlGeneration_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Info]: connection: 2021-12-16 05:29:04.226--ServerSession(2072998261)--/ddlGeneration_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ecltest.CMP3_PO_SPARK_PLUG' doesn't exist
[junit] Error Code: 1146
[junit] Call: Alter table CMP3_PO_SPARK_PLUG drop foreign key CMP3_PO_SPARK_PLUG_ENGINE_ID
[junit] Query: DataModifyQuery(sql="Alter table CMP3_PO_SPARK_PLUG drop foreign key CMP3_PO_SPARK_PLUG_ENGINE_ID")
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ecltest.JPA_OR_SPARK_PLUG' doesn't exist
[junit] Error Code: 1146
[junit] Call: Alter table JPA_OR_SPARK_PLUG drop foreign key JPA_OR_SPARK_PLUG_ENGINE_ID
[junit] Query: DataModifyQuery(sql="Alter table JPA_OR_SPARK_PLUG drop foreign key JPA_OR_SPARK_PLUG_ENGINE_ID")
[junit] [EL Warning]: UnitOfWork(452884921)--java.lang.IllegalStateException: During synchronization a new object was found through a relationship that was not marked cascade PERSIST: Engine [0].
[junit] [EL Info]: 2021-12-16 05:29:06.981--ServerSession(1875110331)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Warning]: metadata: 2021-12-16 05:29:06.984--ServerSession(1875110331)--isNullAllowed is reset to false in org.eclipse.persistence.mappings.AggregateObjectMapping[observation] because the aggregate has a (possibly nested) target foreign key mapping
[junit] [EL Info]: connection: 2021-12-16 05:29:06.985--ServerSession(1875110331)--metamodel login successful
[junit] [EL Info]: connection: 2021-12-16 05:29:06.986--ServerSession(1875110331)--metamodel logout successful
[junit] [EL Info]: 2021-12-16 05:29:07.0--ServerSession(1228641921)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Warning]: metadata: 2021-12-16 05:29:07.003--ServerSession(1228641921)--isNullAllowed is reset to false in org.eclipse.persistence.mappings.AggregateObjectMapping[observation] because the aggregate has a (possibly nested) target foreign key mapping
[junit] [EL Info]: connection: 2021-12-16 05:29:07.004--ServerSession(1228641921)--metamodel login successful
[junit] [EL Info]: connection: 2021-12-16 05:29:07.006--ServerSession(1228641921)--metamodel logout successful
[junit] [EL Info]: 2021-12-16 05:29:07.02--ServerSession(325083844)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Warning]: metadata: 2021-12-16 05:29:07.023--ServerSession(325083844)--isNullAllowed is reset to false in org.eclipse.persistence.mappings.AggregateObjectMapping[observation] because the aggregate has a (possibly nested) target foreign key mapping
[junit] [EL Info]: connection: 2021-12-16 05:29:07.024--ServerSession(325083844)--metamodel login successful
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Printed list of Metamodel [51] Types to follow:
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@732680163:Board [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Board descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Board --> [DatabaseTable(CMP3_MM_BOARD)]), mappings: 5]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@2076122288:Computer [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Computer descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Computer --> [DatabaseTable(CMP3_MM_COMPUTER)]), mappings: 9]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@700610194:Enclosure [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Enclosure descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Enclosure --> [DatabaseTable(CMP3_MM_ENCLOSURE)]), mappings: 5]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@949578189:GalacticPosition [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.GalacticPosition descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.GalacticPosition --> [DatabaseTable(CMP3_MM_GALACTIC)]), mappings: 5]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@1303932394:Location [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Location descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Location --> [DatabaseTable(CMP3_MM_GALACTIC)]), mappings: 8]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@1315025521:Manufacturer [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Manufacturer descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Manufacturer --> [DatabaseTable(CMP3_MM_MANUF)]), mappings: 34]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@1949117385:Processor [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Processor descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Processor --> [DatabaseTable(CMP3_MM_PROC)]), mappings: 3]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@118092672:SoftwareDesigner [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.SoftwareDesigner descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.SoftwareDesigner --> [DatabaseTable(CMP3_MM_SWDESIGNER)]), mappings: 6]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@164628918:HardwareDesigner [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.HardwareDesigner descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.HardwareDesigner --> [DatabaseTable(CMP3_MM_HWDESIGNER)]), mappings: 13]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@1247924423:User [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.User descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.User --> [DatabaseTable(CMP3_MM_USER)]), mappings: 4]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@1460656417:ArrayProcessor [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.ArrayProcessor descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.ArrayProcessor --> [DatabaseTable(CMP3_MM_PROC)]), mappings: 4]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@525510067:VectorProcessor [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.VectorProcessor descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.VectorProcessor --> [DatabaseTable(CMP3_MM_PROC)]), mappings: 4]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@382108246:MS_MS_Entity_Leaf [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.MS_MS_Entity_Leaf descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.MS_MS_Entity_Leaf --> [DatabaseTable(CMP3_MM_MSMSENTITY_LEAF)]), mappings: 7]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@1390776225:MultiCoreCPU [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.MultiCoreCPU descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.MultiCoreCPU --> [DatabaseTable(CMP3_MM_MULTICORECPU)]), mappings: 3]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@2072674829:Core [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Core descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Core --> [DatabaseTable(CMP3_MM_CORE)]), mappings: 3]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EmbeddableTypeImpl@1904201714:CompositePK [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.CompositePK descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.CompositePK --> []), mappings: 2]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.032--ServerSession(325083844)--Metamodel Type: [EmbeddableTypeImpl@1401501625:ObservationDetail [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.ObservationDetail descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.ObservationDetail --> []), mappings: 1]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@770650862:Memory [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Memory descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Memory --> [DatabaseTable(CMP3_MM_MEMORY)]), mappings: 3]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [EntityTypeImpl@39471028:EntityChildOfMSRootPropertyAccess [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.EntityChildOfMSRootPropertyAccess descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.EntityChildOfMSRootPropertyAccess --> [DatabaseTable(ENTITYCHILDOFMSROOTPROPERTYACCESS)]), mappings: 2]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [EmbeddableTypeImpl@223680594:Observation [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Observation descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Observation --> []), mappings: 5]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [EmbeddableTypeImpl@402379454:CPUEmbeddedId [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.CPUEmbeddedId descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.CPUEmbeddedId --> []), mappings: 1]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [EmbeddableTypeImpl@1138227949:EmbeddedPK [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.EmbeddedPK descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.EmbeddedPK --> []), mappings: 1]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@1642138273:MSRootPropertyAccess [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.MSRootPropertyAccess descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.MSRootPropertyAccess --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 1]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@1218711793:CPU [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.CPU descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.CPU --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 2]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@2133144354:Person [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Person descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Person --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 3]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@2026058437:CoordinateMS [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.CoordinateMS descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.CoordinateMS --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 3]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@295607166:Corporation [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Corporation descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Corporation --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 2]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@2044011044:MS_MS_Entity_Root [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.MS_MS_Entity_Root descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.MS_MS_Entity_Root --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 4]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@801092127:Designer [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Designer descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.Designer --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 2]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [MappedSuperclassTypeImpl@1309403191:MS_MS_Entity_Center [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.MS_MS_Entity_Center descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.metamodel.MS_MS_Entity_Center --> [DatabaseTable(__METAMODEL_RESERVED_IN_MEM_ONLY_TABLE_NAME)]), mappings: 2]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@769103301:Integer [ javaType: class java.lang.Integer]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@2145743887:int [ javaType: int]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@566017435:String [ javaType: class java.lang.String]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@240674397:EnclosureIdClassPK [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.EnclosureIdClassPK]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@531674094:BigDecimal [ javaType: class java.math.BigDecimal]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1268906267:BigInteger [ javaType: class java.math.BigInteger]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@263570833:boolean [ javaType: boolean]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1116872884:Boolean [ javaType: class java.lang.Boolean]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1479001291:byte [ javaType: byte]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@470456309:Byte [ javaType: class java.lang.Byte]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1026707624:char [ javaType: char]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1853243450:Character [ javaType: class java.lang.Character]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@143769763:double [ javaType: double]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1089227643:Double [ javaType: class java.lang.Double]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1878324446:float [ javaType: float]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@870260362:Float [ javaType: class java.lang.Float]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@902648970:long [ javaType: long]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@400058075:Long [ javaType: class java.lang.Long]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1598173946:short [ javaType: short]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@346180822:Short [ javaType: class java.lang.Short]]}
[junit] [EL Info]: metamodel: 2021-12-16 05:29:07.033--ServerSession(325083844)--Metamodel Type: [BasicTypeImpl@1259611084:Position [ javaType: class org.eclipse.persistence.testing.models.jpa.metamodel.Position]]}
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_ENGINEER_LAPTOP_FK1'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_ENGINEER_LAPTOP drop foreign key CMP3_ENGINEER_LAPTOP_FK1
[junit] Query: DataModifyQuery(sql="Alter table CMP3_ENGINEER_LAPTOP drop foreign key CMP3_ENGINEER_LAPTOP_FK1")
[junit] [EL Info]: 2021-12-16 05:29:59.102--ServerSession(949164062)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:29:59.106--ServerSession(949164062)--/DISABLE_SELECTIVE_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [PRODUCT_FALSE.ID] because it is also a primary key.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [PRODUCT_TRUE.ID] because it is also a primary key.
[junit] [EL Info]: 2021-12-16 05:30:00.435--ServerSession(1950732797)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:30:00.439--ServerSession(1950732797)--/ALL_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: 2021-12-16 05:30:00.457--ServerSession(72182012)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:30:00.46--ServerSession(72182012)--/NONE_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: 2021-12-16 05:30:00.477--ServerSession(509695926)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:30:00.48--ServerSession(509695926)--/ENABLE_SELECTIVE_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: 2021-12-16 05:30:00.496--ServerSession(908195597)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:30:00.499--ServerSession(908195597)--/UNSPECIFIED_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: transaction: 2021-12-16 05:30:00.797--UnitOfWork(1375729661)--property javax.persistence.cacheStoreMode is deprecated, property javax.persistence.cache.storeMode should be used instead.
[junit] [EL Info]: transaction: 2021-12-16 05:30:00.802--UnitOfWork(591525878)--property javax.persistence.cacheRetrieveMode is deprecated, property javax.persistence.cache.retrieveMode should be used instead.
[junit] [EL Info]: transaction: 2021-12-16 05:30:00.802--UnitOfWork(591525878)--property javax.persistence.cacheStoreMode is deprecated, property javax.persistence.cache.storeMode should be used instead.
[junit] [EL Warning]: ddl: 2021-12-16 05:30:01.586--ServerSession(509695926)--Removing UNIQUE constraint definition from [PRODUCT_FALSE.ID] because it is also a primary key.
[junit] [EL Warning]: ddl: 2021-12-16 05:30:01.602--ServerSession(509695926)--Removing UNIQUE constraint definition from [PRODUCT_TRUE.ID] because it is also a primary key.
[junit] [EL Info]: 2021-12-16 05:30:02.2--ServerSession(1481845605)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:30:02.203--ServerSession(1481845605)--/delimited_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: 2021-12-16 05:30:03.286--ServerSession(1450794852)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:30:03.288--ServerSession(1450794852)--/cascade-deletes_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_ENGINEER_LAPTOP_FK1'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_ENGINEER_LAPTOP drop foreign key CMP3_ENGINEER_LAPTOP_FK1
[junit] Query: DataModifyQuery(sql="Alter table CMP3_ENGINEER_LAPTOP drop foreign key CMP3_ENGINEER_LAPTOP_FK1")
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: query: UnitOfWork(1597754706)--ReadObjectQuery(referenceClass=Employee jpql="SELECT e FROM Employee e JOIN FETCH e.address WHERE e.id = :ID")
[junit] FetchGroup(Employee-default){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1263619039)--ReadObjectQuery(referenceClass=Employee jpql="SELECT e FROM Employee e JOIN FETCH e.address WHERE e.id = :ID")
[junit] FetchGroup(Employee-default){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(2074153899)--ReadAllQuery(referenceClass=Employee jpql="SELECT e FROM Employee e JOIN FETCH e.address")
[junit] FetchGroup(Employee-default){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(2074153899)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t1.F_NAME, t1.L_NAME, t1.VERSION, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION FROM CMP3_ADDRESS t0, CMP3_SALARY t2, CMP3_EMPLOYEE t1 WHERE ((t2.EMP_ID = t1.EMP_ID) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1118224380)--ReadAllQuery(referenceClass=Employee jpql="SELECT e FROM Employee e JOIN FETCH e.address WHERE e.id IN (SELECT p.id FROM PhoneNumber p)")
[junit] FetchGroup(Employee-default){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1118224380)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t1.F_NAME, t1.L_NAME, t1.VERSION, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION FROM CMP3_ADDRESS t0, CMP3_SALARY t2, CMP3_EMPLOYEE t1 WHERE ((t1.EMP_ID IN (SELECT t3.OWNER_ID FROM CMP3_PHONENUMBER t3) AND (t2.EMP_ID = t1.EMP_ID)) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(740493409)--ReadAllQuery(referenceClass=Employee jpql="SELECT e FROM Employee e JOIN FETCH e.address WHERE e.id IN (SELECT p.id FROM PhoneNumber p)")
[junit] FetchGroup(Employee-default){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: query: UnitOfWork(1684714529)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION, t3.ID, t3.NAME, t3.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t3 ON (t3.ID = t1.DEPT_ID), CMP3_SALARY t2, CMP3_ADDRESS t0 WHERE ((t2.EMP_ID = t1.EMP_ID) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(693393195)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION, t3.ID, t3.NAME, t3.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t3 ON (t3.ID = t1.DEPT_ID), CMP3_SALARY t2, CMP3_ADDRESS t0 WHERE ((t1.EMP_ID IN (SELECT t4.OWNER_ID FROM CMP3_PHONENUMBER t4) AND (t2.EMP_ID = t1.EMP_ID)) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: query: UnitOfWork(791401296)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION, t3.ID, t3.NAME, t3.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t3 ON (t3.ID = t1.DEPT_ID), CMP3_SALARY t2, CMP3_ADDRESS t0 WHERE ((t2.EMP_ID = t1.EMP_ID) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1197869893)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION, t3.ID, t3.NAME, t3.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t3 ON (t3.ID = t1.DEPT_ID), CMP3_SALARY t2, CMP3_ADDRESS t0 WHERE ((t1.EMP_ID IN (SELECT t4.OWNER_ID FROM CMP3_PHONENUMBER t4) AND (t2.EMP_ID = t1.EMP_ID)) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: query: UnitOfWork(155715669)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION, t3.ID, t3.NAME, t3.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t3 ON (t3.ID = t1.DEPT_ID), CMP3_SALARY t2, CMP3_ADDRESS t0 WHERE ((t2.EMP_ID = t1.EMP_ID) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(561273893)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ADDRESS_ID, t0.CITY, t0.COUNTRY, t0.P_CODE, t0.PROVINCE, t0.STREET, t0.TYPE, t0.VERSION, t3.ID, t3.NAME, t3.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t3 ON (t3.ID = t1.DEPT_ID), CMP3_SALARY t2, CMP3_ADDRESS t0 WHERE ((t1.EMP_ID IN (SELECT t4.OWNER_ID FROM CMP3_PHONENUMBER t4) AND (t2.EMP_ID = t1.EMP_ID)) AND (t0.ADDRESS_ID = t1.ADDR_ID))")
[junit] FetchGroup(names){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] >>> Employee retrieved
[junit] >>> Employee copied
[junit] >>> Sparse merge complete
[junit] >>> Flush complete
[junit] >>> Employees retrieved
[junit] >>> Employees copied
[junit] >>> Sparse merge complete
[junit] >>> Flush complete
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: query: UnitOfWork(1774709503)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ID, t0.NAME, t0.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((NOT EXISTS (SELECT ? FROM CMP3_PROJECT t3 WHERE (t3.LEADER_ID = t1.EMP_ID)) AND NOT EXISTS (SELECT ? FROM CMP3_SALARY t5, CMP3_EMPLOYEE t4 WHERE ((t4.MANAGER_EMP_ID = t1.EMP_ID) AND (t5.EMP_ID = t4.EMP_ID))) ) AND (t2.EMP_ID = t1.EMP_ID))")
[junit] FetchGroup(employee){lastName, address => {class java.lang.Object=FetchGroup(address){country, city, ID, version}}, projects => {class java.lang.Object=FetchGroup(projects){name, teamLeader => {class java.lang.Object=FetchGroup(teamLeader){firstName, id, version, phoneNumbers => {class java.lang.Object=FetchGroup(phoneNumbers){owner, areaCode, type}}}}, id, version}}, manager => {class java.lang.Object=FetchGroup(manager){firstName, id, version, phoneNumbers => {class java.lang.Object=FetchGroup(phoneNumbers){owner, areaCode, type}}}}, id, department => {class java.lang.Object=FetchGroup(department){name, id}}, version, phoneNumbers}: joined attribute [projects.teamLeader] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1774709503)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ID, t0.NAME, t0.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((NOT EXISTS (SELECT ? FROM CMP3_PROJECT t3 WHERE (t3.LEADER_ID = t1.EMP_ID)) AND NOT EXISTS (SELECT ? FROM CMP3_SALARY t5, CMP3_EMPLOYEE t4 WHERE ((t4.MANAGER_EMP_ID = t1.EMP_ID) AND (t5.EMP_ID = t4.EMP_ID))) ) AND (t2.EMP_ID = t1.EMP_ID))")
[junit] FetchGroup(employee){lastName, address => {class java.lang.Object=FetchGroup(address){country, city, ID, version}}, projects => {class java.lang.Object=FetchGroup(projects){name, teamLeader => {class java.lang.Object=FetchGroup(teamLeader){firstName, id, version, phoneNumbers => {class java.lang.Object=FetchGroup(phoneNumbers){owner, areaCode, type}}}}, id, version}}, manager => {class java.lang.Object=FetchGroup(manager){firstName, id, version, phoneNumbers => {class java.lang.Object=FetchGroup(phoneNumbers){owner, areaCode, type}}}}, id, department => {class java.lang.Object=FetchGroup(department){name, id}}, version, phoneNumbers}: joined attribute [projects.teamLeader.phoneNumbers] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1774709503)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ID, t0.NAME, t0.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((NOT EXISTS (SELECT ? FROM CMP3_PROJECT t3 WHERE (t3.LEADER_ID = t1.EMP_ID)) AND NOT EXISTS (SELECT ? FROM CMP3_SALARY t5, CMP3_EMPLOYEE t4 WHERE ((t4.MANAGER_EMP_ID = t1.EMP_ID) AND (t5.EMP_ID = t4.EMP_ID))) ) AND (t2.EMP_ID = t1.EMP_ID))")
[junit] FetchGroup(employee){lastName, address => {class java.lang.Object=FetchGroup(address){country, city, ID, version}}, projects => {class java.lang.Object=FetchGroup(projects){name, teamLeader => {class java.lang.Object=FetchGroup(teamLeader){firstName, id, version, phoneNumbers => {class java.lang.Object=FetchGroup(phoneNumbers){owner, areaCode, type}}}}, id, version}}, manager => {class java.lang.Object=FetchGroup(manager){firstName, id, version, phoneNumbers => {class java.lang.Object=FetchGroup(phoneNumbers){owner, areaCode, type}}}}, id, department => {class java.lang.Object=FetchGroup(department){name, id}}, version, phoneNumbers}: joined attribute [manager.phoneNumbers] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: query: UnitOfWork(1878210172)--ReadAllQuery(referenceClass=Employee sql="SELECT t1.EMP_ID, t2.EMP_ID, t1.F_NAME, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_END_DATE, t1.FORMER_START_DATE, t1.FORMER_COMPANY_ADDRESS_ID, t1.END_DATE, t1.START_DATE, t1.COMPANYADDRESS_ADDRESS_ID, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t1.HUGE_PROJ_ID, t0.ID, t0.NAME, t0.DEPT_HEAD FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (t2.EMP_ID = t1.EMP_ID)")
[junit] FetchGroup(){firstName, lastName, id, version}: joined attribute [address] is not included into the fetch group. The joined attribute data (though read from the database) will be ignored. A new sql will be executed to read again the object referenced by the joined attribute; and yet another sql to read the whole main object (because of setting the value to the attribute outside the fetch group). Either include the fetched attribute into the fetch group or remove it.
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Warning]: ddl: ServerSession(1310537038)--Removing UNIQUE constraint definition from [CMP3_EMBED_VISITOR.ID] because it is also a primary key.
[junit] [EL Warning]: ServerSession(1310537038)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'CMP3_SCIENTIST_CUBICLE'; check that column/key exists
[junit] Error Code: 1091
[junit] Call: Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE
[junit] Query: DataModifyQuery(sql="Alter table CMP3_SCIENTIST drop foreign key CMP3_SCIENTIST_CUBICLE")
[junit] [EL Info]: 2021-12-16 05:31:44.869--ServerSession(673617377)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:44.874--ServerSession(673617377)--/partitioned_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: 2021-12-16 05:31:45.859--ServerSession(1376817632)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:45.864--ServerSession(1376817632)--/partitioned-xml_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] WARNING: This test can only be run on Oracle.
[junit] WARNING: This test can only be run on Oracle.
[junit] [EL Info]: 2021-12-16 05:31:46.997--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:47.004--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:47.006--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:47.007--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:47.011--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Warning]: metamodel: 2021-12-16 05:31:47.011--The collection of metamodel types is empty. Model classes may not have been found during entity search for Java SE and some Java EE container managed persistence units. Please verify that your entity classes are referenced in persistence.xml using either <class> elements or a global <exclude-unlisted-classes>false</exclude-unlisted-classes> element
[junit] [EL Warning]: properties: 2021-12-16 05:31:48.766--ServerSession(788139087)--Persistence unit does not use JTA, therefore the EntityManager ignores jta data source.
[junit] [EL Warning]: properties: 2021-12-16 05:31:48.766--ServerSession(1943819920)--Persistence unit does not use JTA, therefore the EntityManager ignores jta data source.
[junit] [EL Warning]: properties: 2021-12-16 05:31:48.766--ServerSession(2145431324)--Persistence unit does not use JTA, therefore the EntityManager ignores jta data source.
[junit] [EL Warning]: properties: 2021-12-16 05:31:48.767--ServerSession(788139087)--Persistence unit does not use JTA, therefore the EntityManager ignores jta data source.
[junit] [EL Warning]: properties: 2021-12-16 05:31:48.767--ServerSession(1943819920)--Persistence unit does not use JTA, therefore the EntityManager ignores jta data source.
[junit] [EL Warning]: properties: 2021-12-16 05:31:48.767--ServerSession(2145431324)--Persistence unit does not use JTA, therefore the EntityManager ignores jta data source.
[junit] [EL Info]: connection: 2021-12-16 05:31:48.788--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.788--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.788--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:48.788--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:48.79--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.791--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.792--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.792--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: query: 2021-12-16 05:31:48.797--UnitOfWork(634608998)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS
[junit] Query: ReadAllQuery(referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS").
[junit] [EL Info]: transaction: 2021-12-16 05:31:48.799--ClientSession(1442929278)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Warning]: 2021-12-16 05:31:48.803--ClientSession(1442929278)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] [EL Info]: query: 2021-12-16 05:31:48.808--UnitOfWork(603009045)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS
[junit] Query: ReadAllQuery(referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS").
[junit] [EL Warning]: 2021-12-16 05:31:48.813--ClientSession(2050933708)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] [EL Info]: query: 2021-12-16 05:31:48.816--UnitOfWork(378358753)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS
[junit] Query: ReadAllQuery(referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS").
[junit] [EL Info]: transaction: 2021-12-16 05:31:48.817--ClientSession(1159454130)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Warning]: 2021-12-16 05:31:48.821--ClientSession(1159454130)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] [EL Info]: connection: 2021-12-16 05:31:48.824--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.824--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.824--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:48.824--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:48.824--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.825--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.826--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.826--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.827--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.827--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.827--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:48.827--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:48.827--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.828--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.83--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.83--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: query: 2021-12-16 05:31:48.834--UnitOfWork(1254273747)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS
[junit] Query: ReadAllQuery(referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS").
[junit] [EL Severe]: 2021-12-16 05:31:48.835--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: sql: 2021-12-16 05:31:48.835--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: transaction: 2021-12-16 05:31:48.835--ClientSession(1469412868)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Severe]: 2021-12-16 05:31:48.835--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: sql: 2021-12-16 05:31:48.835--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: connection: 2021-12-16 05:31:48.852--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.852--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.852--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:48.852--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:48.853--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.854--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.855--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.855--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.974--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.974--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.974--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:48.974--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:48.976--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.977--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.978--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:48.978--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Severe]: 2021-12-16 05:31:48.978--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: 2021-12-16 05:31:48.978--UnitOfWork(690734631)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] Query: InsertObjectQuery(org.eclipse.persistence.testing.models.jpa.composite.advanced.member_1.Address@22d375e5)
[junit] [EL Info]: query: 2021-12-16 05:31:48.979--UnitOfWork(1025586581)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)
[junit] bind => [1]
[junit] Query: ReadObjectQuery(name="readAddress" referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)").
[junit] [EL Info]: transaction: 2021-12-16 05:31:48.989--ClientSession(1985111709)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Severe]: 2021-12-16 05:31:48.989--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:48.99--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:48.99--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: 2021-12-16 05:31:48.99--ClientSession(1985111709)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: query: 2021-12-16 05:31:48.99--UnitOfWork(389387893)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)
[junit] bind => [1]
[junit] Query: ReadObjectQuery(name="readAddress" referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)").
[junit] [EL Info]: transaction: 2021-12-16 05:31:49.0--ClientSession(244870555)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Severe]: 2021-12-16 05:31:49.001--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.001--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.001--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: 2021-12-16 05:31:49.001--ClientSession(244870555)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: query: 2021-12-16 05:31:49.001--UnitOfWork(2101255607)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)
[junit] bind => [1]
[junit] Query: ReadObjectQuery(name="readAddress" referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)").
[junit] [EL Info]: transaction: 2021-12-16 05:31:49.011--ClientSession(1287204311)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Severe]: 2021-12-16 05:31:49.011--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.011--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.012--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: 2021-12-16 05:31:49.012--ClientSession(1287204311)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: query: 2021-12-16 05:31:49.012--UnitOfWork(476448630)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)
[junit] bind => [1]
[junit] Query: ReadObjectQuery(name="readAddress" referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)").
[junit] [EL Info]: transaction: 2021-12-16 05:31:49.021--ClientSession(1104506769)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Severe]: 2021-12-16 05:31:49.021--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.022--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.022--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: 2021-12-16 05:31:49.022--ClientSession(1104506769)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: transaction: 2021-12-16 05:31:49.032--ClientSession(1690890781)--Communication failure detected when attempting to create transaction on database. Attempting to retry begin transaction. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0.
[junit] [EL Severe]: 2021-12-16 05:31:49.032--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.032--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Severe]: 2021-12-16 05:31:49.032--ServerSession(2145431324)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Warning]: 2021-12-16 05:31:49.032--ClientSession(1690890781)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: driver is broken
[junit] Error Code: 0
[junit] [EL Info]: query: 2021-12-16 05:31:49.032--UnitOfWork(63017224)--Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: java.sql.SQLException: DriverWrapper: old connections are broken
[junit] Error Code: 0
[junit] Call: SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)
[junit] bind => [1]
[junit] Query: ReadObjectQuery(name="readAddress" referenceClass=Address sql="SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET, TYPE, VERSION FROM MBR1_ADDRESS WHERE (ADDRESS_ID = ?)").
[junit] [EL Info]: connection: 2021-12-16 05:31:49.042--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:49.042--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:49.042--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:49.042--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:49.042--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:49.043--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:49.044--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:49.044--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: 2021-12-16 05:31:49.063--ServerSession(2045900103)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Severe]: 2021-12-16 05:31:49.065--ServerSession(2045900103)--Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.IntegrityException
[junit] Descriptor Exceptions:
[junit] ---------------------------------------------------------
[junit]
[junit] Exception [EclipseLink-48] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DescriptorException
[junit] Exception Description: Multiple writable mappings exist for the field [WRONGANNOTATION.F_NAME]. Only one may be defined as writable, all others must be specified read-only.
[junit] Mapping: org.eclipse.persistence.mappings.DirectToFieldMapping[lastName-->WRONGANNOTATION.F_NAME]
[junit] Descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.validationfailed.WrongAnnotation --> [DatabaseTable(WRONGANNOTATION)])
[junit]
[junit] Exception [EclipseLink-48] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DescriptorException
[junit] Exception Description: Multiple writable mappings exist for the field [CMP3_MWMAPVALUE.VALUE]. Only one may be defined as writable, all others must be specified read-only.
[junit] Mapping: org.eclipse.persistence.mappings.DirectToFieldMapping[value-->CMP3_MWMAPVALUE.VALUE]
[junit] Descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.validationfailed.MultipleWritableMapValue --> [DatabaseTable(CMP3_MWMAPVALUE)])
[junit]
[junit] Runtime Exceptions:
[junit] ---------------------------------------------------------
[junit]
[junit] [EL Info]: connection: 2021-12-16 05:31:49.066--ServerSession(2045900103)--/broken-PU_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Severe]: ejb: 2021-12-16 05:31:49.066--ServerSession(2045900103)--Exception [EclipseLink-0] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.IntegrityException
[junit] Descriptor Exceptions:
[junit] ---------------------------------------------------------
[junit]
[junit] Exception [EclipseLink-48] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DescriptorException
[junit] Exception Description: Multiple writable mappings exist for the field [WRONGANNOTATION.F_NAME]. Only one may be defined as writable, all others must be specified read-only.
[junit] Mapping: org.eclipse.persistence.mappings.DirectToFieldMapping[lastName-->WRONGANNOTATION.F_NAME]
[junit] Descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.validationfailed.WrongAnnotation --> [DatabaseTable(WRONGANNOTATION)])
[junit]
[junit] Exception [EclipseLink-48] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DescriptorException
[junit] Exception Description: Multiple writable mappings exist for the field [CMP3_MWMAPVALUE.VALUE]. Only one may be defined as writable, all others must be specified read-only.
[junit] Mapping: org.eclipse.persistence.mappings.DirectToFieldMapping[value-->CMP3_MWMAPVALUE.VALUE]
[junit] Descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.validationfailed.MultipleWritableMapValue --> [DatabaseTable(CMP3_MWMAPVALUE)])
[junit]
[junit] Runtime Exceptions:
[junit] ---------------------------------------------------------
[junit]
[junit] [EL Warning]: 2021-12-16 05:31:49.209--UnitOfWork(1945976072)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'F_NAME' at row 1
[junit] Error Code: 1406
[junit] Call: INSERT INTO MBR2_EMPLOYEE (EMP_ID, F_NAME, GENDER, L_NAME, PAY_SCALE, ROOM_NUM, STATUS, VERSION, START_TIME, END_TIME, START_OVERTIME, END_OVERTIME, FORMER_COMPANY, FORMER_END_DATE, FORMER_START_DATE, END_DATE, START_DATE, ADDR_ID, DEPT_ID, MANAGER_EMP_ID, HUGE_PROJ_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[junit] bind => [166, firstName_maxfieldLength_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, null, null, null, 0, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null]
[junit] Query: InsertObjectQuery(Employee: 166)
[junit] [EL Warning]: 2021-12-16 05:31:49.394--UnitOfWork(1306363691)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'NOWAIT' at line 1
[junit] Error Code: 1064
[junit] Call: SELECT t0.PROJ_ID, t0.PROJ_TYPE, t0.DESCRIP, t0.PROJ_NAME, t0.VERSION, t0.LEADER_ID, t1.PROJ_ID, t1.BUDGET FROM MBR3_PROJECT t0, MBR3_LPROJECT t1 WHERE (((t0.PROJ_ID = ?) AND (t1.PROJ_ID = t0.PROJ_ID)) AND (t0.PROJ_TYPE = ?)) FOR UPDATE NOWAIT
[junit] bind => [19, L]
[junit] Query: ReadObjectQuery(referenceClass=LargeProject sql="SELECT DISTINCT t0.PROJ_TYPE FROM MBR3_PROJECT t0, MBR3_LPROJECT t1 WHERE (((t0.PROJ_ID = ?) AND (t1.PROJ_ID = t0.PROJ_ID)) AND (t0.PROJ_TYPE IN (?, ?)))")
[junit] [EL Warning]: 2021-12-16 05:31:52.595--UnitOfWork(237668490)--Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.OptimisticLockException
[junit] Exception Description: The object [Employee: 200] cannot be updated because it has changed or been deleted since it was last read.
[junit] Class> org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee Primary Key> 200
[junit] [EL Warning]: 2021-12-16 05:31:52.605--UnitOfWork(1624566665)--Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.OptimisticLockException
[junit] Exception Description: The object [Employee: 201] cannot be updated because it has changed or been deleted since it was last read.
[junit] Class> org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee Primary Key> 201
[junit] [EL Warning]: 2021-12-16 05:31:52.638--UnitOfWork(1383770720)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'NOWAIT' at line 1
[junit] Error Code: 1064
[junit] Call: SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
[junit] bind => [54]
[junit] Query: ReadObjectQuery(referenceClass=Department sql="SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT")
[junit] [EL Warning]: 2021-12-16 05:31:52.651--UnitOfWork(2076261835)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'NOWAIT' at line 1
[junit] Error Code: 1064
[junit] Call: SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
[junit] bind => [55]
[junit] Query: ReadObjectQuery(referenceClass=Department sql="SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT")
[junit] [EL Info]: connection: 2021-12-16 05:31:52.899--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:52.9--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:52.9--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:52.9--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:52.902--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:52.902--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] [EL Info]: connection: 2021-12-16 05:31:52.904--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:52.904--SessionBroker(886480969)--/composite-advanced login successful
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] Ds - Allocating new non-tx connection
[junit] [EL Info]: connection: 2021-12-16 05:31:53.054--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.054--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.054--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:53.054--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:53.055--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.056--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.057--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.057--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.058--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.058--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.058--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:53.058--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:53.058--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.059--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.061--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.061--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.163--ServerSession(788139087)--composite-advanced-member_3 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.163--ServerSession(1943819920)--composite-advanced-member_2 logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.163--ServerSession(2145431324)--composite-advanced-member_1 logout successful
[junit] [EL Info]: 2021-12-16 05:31:53.163--SessionBroker(886480969)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:53.164--ServerSession(788139087)--composite-advanced-member_3 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.165--ServerSession(1943819920)--composite-advanced-member_2 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.166--ServerSession(2145431324)--composite-advanced-member_1 login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:53.167--SessionBroker(886480969)--/composite-advanced login successful
[junit] [EL Warning]: 2021-12-16 05:31:53.192--UnitOfWork(1214850206)--Exception [EclipseLink-7251] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.ValidationException
[junit] Exception Description: The attribute [id] of class [org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee] is mapped to a primary key column in the database. Updates are not allowed.
[junit] [EL Warning]: 2021-12-16 05:31:53.203--UnitOfWork(996824980)--Exception [EclipseLink-7251] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.ValidationException
[junit] Exception Description: The attribute [owner] of class [org.eclipse.persistence.testing.models.jpa.composite.advanced.member_3.PhoneNumber] is mapped to a primary key column in the database. Updates are not allowed.
[junit] [EL Warning]: 2021-12-16 05:31:53.22--UnitOfWork(378185252)--Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.OptimisticLockException
[junit] Exception Description: The object [Employee: 255] cannot be updated because it has changed or been deleted since it was last read.
[junit] Class> org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee Primary Key> 255
[junit] [EL Warning]: 2021-12-16 05:31:53.551--UnitOfWork(2087717861)--Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.OptimisticLockException
[junit] Exception Description: The object [Employee: 274] cannot be updated because it has changed or been deleted since it was last read.
[junit] Class> org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee Primary Key> 274
[junit] [EL Warning]: 2021-12-16 05:31:53.567--UnitOfWork(1651716379)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'NOWAIT' at line 1
[junit] Error Code: 1064
[junit] Call: SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
[junit] bind => [101]
[junit] Query: ReadObjectQuery(referenceClass=Department sql="SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT")
[junit] [EL Warning]: 2021-12-16 05:31:53.577--UnitOfWork(638388037)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'NOWAIT' at line 1
[junit] Error Code: 1064
[junit] Call: SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
[junit] bind => [102]
[junit] Query: ReadObjectQuery(referenceClass=Department sql="SELECT ID, NAME, DEPT_HEAD FROM MBR1_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT")
[junit] [EL Warning]: 2021-12-16 05:31:53.875--UnitOfWork(706413367)--Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.OptimisticLockException
[junit] Exception Description: The object [Employee: 314] cannot be updated because it has changed or been deleted since it was last read.
[junit] Class> org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee Primary Key> 314
[junit] [EL Warning]: 2021-12-16 05:31:53.905--UnitOfWork(161460560)--Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.OptimisticLockException
[junit] Exception Description: The object [Employee: 317] cannot be updated because it has changed or been deleted since it was last read.
[junit] Class> org.eclipse.persistence.testing.models.jpa.composite.advanced.member_2.Employee Primary Key> 317
[junit] [EL Info]: 2021-12-16 05:31:53.918--ServerSession(1982645951)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:53.92--ServerSession(1982645951)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: 2021-12-16 05:31:54.524--ServerSession(1633503861)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:54.525--ServerSession(1633503861)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:54.563--ServerSession(1633503861)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_726'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: connection: 2021-12-16 05:31:55.266--ServerSession(734120507)--default-session logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:55.271--ServerSession(1982645951)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Info]: 2021-12-16 05:31:55.29--ServerSession(947770287)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:55.294--ServerSession(947770287)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:55.359--ServerSession(947770287)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_728'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: 2021-12-16 05:31:55.514--ServerSession(781212334)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:55.515--ServerSession(781212334)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:55.556--ServerSession(781212334)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_72a'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: 2021-12-16 05:31:55.59--ServerSession(43866117)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:55.591--ServerSession(43866117)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:55.633--ServerSession(43866117)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_72c'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: connection: 2021-12-16 05:31:56.236--ServerSession(1633503861)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:56.237--ServerSession(781212334)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Info]: connection: 2021-12-16 05:31:56.239--ServerSession(947770287)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root logout successful
[junit] [EL Info]: 2021-12-16 05:31:56.24--ServerSession(900698852)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.243--ServerSession(900698852)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:56.273--ServerSession(900698852)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_72e'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: 2021-12-16 05:31:56.283--ServerSession(622326434)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.284--ServerSession(622326434)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:56.309--ServerSession(622326434)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_730'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: 2021-12-16 05:31:56.326--ServerSession(163437851)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.328--ServerSession(163437851)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:56.398--ServerSession(163437851)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_732'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Warning]: 2021-12-16 05:31:56.441--ServerSession(163437851)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_732'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_JOIN_TABLE ADD CONSTRAINT FK_EXTENS_JOIN_TABLE_ID1 FOREIGN KEY (ID1) REFERENCES EXTENS_EMP (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_JOIN_TABLE ADD CONSTRAINT FK_EXTENS_JOIN_TABLE_ID1 FOREIGN KEY (ID1) REFERENCES EXTENS_EMP (ID)")
[junit] [EL Info]: 2021-12-16 05:31:56.463--ServerSession(998477063)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.464--ServerSession(998477063)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:56.501--ServerSession(998477063)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_734'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: 2021-12-16 05:31:56.525--ServerSession(1439343896)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.53--ServerSession(1439343896)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:56.564--ServerSession(1439343896)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_736'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Info]: 2021-12-16 05:31:56.582--ServerSession(92756278)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Severe]: 2021-12-16 05:31:56.582--ServerSession(92756278)--Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.ValidationException
[junit] Exception Description: Cannot acquire data source [MyNonJtaDataSource].
[junit] Internal Exception: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
[junit] [EL Severe]: ejb: 2021-12-16 05:31:56.582--ServerSession(92756278)--Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.ValidationException
[junit] Exception Description: Cannot acquire data source [MyNonJtaDataSource].
[junit] Internal Exception: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
[junit] [EL Info]: 2021-12-16 05:31:56.585--ServerSession(1639120816)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.587--ServerSession(1639120816)--/extensibility_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Warning]: 2021-12-16 05:31:56.628--ServerSession(1639120816)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_738'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_EMP ADD CONSTRAINT FK_EXTENS_EMP_ADDRESS_ID FOREIGN KEY (ADDRESS_ID) REFERENCES EXTENS_ADDR (ID)")
[junit] [EL Warning]: 2021-12-16 05:31:56.661--ServerSession(1639120816)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3): org.eclipse.persistence.exceptions.DatabaseException
[junit] Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-1b5_738'
[junit] Error Code: 1022
[junit] Call: ALTER TABLE EXTENS_JOIN_TABLE ADD CONSTRAINT FK_EXTENS_JOIN_TABLE_ID1 FOREIGN KEY (ID1) REFERENCES EXTENS_EMP (ID)
[junit] Query: DataModifyQuery(sql="ALTER TABLE EXTENS_JOIN_TABLE ADD CONSTRAINT FK_EXTENS_JOIN_TABLE_ID1 FOREIGN KEY (ID1) REFERENCES EXTENS_EMP (ID)")
[junit] [EL Info]: 2021-12-16 05:31:56.728--ServerSession(1158565284)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.73--ServerSession(1158565284)--/ecl-xml-mapping-metadata-complete_url=jdbc:mysql://localhost/ecltest?useSSL=false_user=root login successful
[junit] [EL Info]: connection: 2021-12-16 05:31:56.736--DatabaseSessionImpl(828995006)-- logout successful
[junit] [EL Info]: 2021-12-16 05:31:56.736--DatabaseSessionImpl(1122206500)--EclipseLink, version: Eclipse Persistence Services - 2.6.10.v20211216-9bb6b7fbe3
[junit] [EL Info]: connection: 2021-12-16 05:31:56.737--DatabaseSessionImpl(1122206500)-- login successful
[junit] Tests run: 2945, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 933.17 sec
[junit] Test org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel FAILED
BUILD FAILED
/home/jenkins/agent/workspace/eclipselink-nightly-2.6/autobuild.xml:342: The following error occurred while executing this line:
/home/jenkins/agent/workspace/eclipselink-nightly-2.6/antbuild.xml:1628: The following error occurred while executing this line:
/home/jenkins/agent/workspace/eclipselink-nightly-2.6/jpa/eclipselink.jpa.test/antbuild.xml:1628: The following error occurred while executing this line:
/home/jenkins/agent/workspace/eclipselink-nightly-2.6/jpa/eclipselink.jpa.test/antbuild.xml:2209: TESTS FAILED !
Total time: 29 minutes 29 seconds
[Pipeline] }
Executing sh script inside container el-build of pod el-master-agent-pod-7hd87-hngvf
Executing command: "ssh-agent" "-k"
exit
unset SSH_AUTH_SOCK;
unset SSH_AGENT_PID;
echo Agent pid 397 killed;
[ssh-agent] Stopped.
[Pipeline] // sshagent
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Publish to nightly)
Stage "Publish to nightly" skipped due to earlier failure(s)
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Proceed test results)
Stage "Proceed test results" skipped due to earlier failure(s)
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] emailext
Not sending mail to unregistered user noreply@github.com because your SCM claimed this was associated with a user ID ‘noreply' which your security realm does not recognize; you may need changes in your SCM plugin
Sending email to: eclipselink-dev@eclipse.org
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE
![[Jenkins]](/eclipselink/static/f04fcb43/images/svgs/logo.svg){kind=logo}
