Unit Test Results

Designed for use with JUnit and Ant.

Summary

Tests	Failures	Errors	Success rate	Time
890	33	155	78.88%	2757.806

Note: failures are anticipated and checked for with assertions while errors are unanticipated.

Packages

Note: package statistics are not computed recursively, they only sum up all of its testsuites numbers.

Name	Tests	Errors	Failures	Time(s)	Time Stamp	Host
org.eclipse.persistence.testing.tests.jpa	890	155	33	2757.806	2008-10-15T16:01:37	build

Package org.eclipse.persistence.testing.tests.jpa

Name	Tests	Errors	Failures	Time(s)	Time Stamp	Host
FullRegressionTestSuite	890	155	33	2757.806	2008-10-15T16:01:37	build

TestCase FullRegressionTestSuite

Name	Status	Type	Time(s)
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.NamedNativeQueryJUnitTest$1.setUp(NamedNativeQueryJUnitTest.java:42) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.001
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.CallbackEventJUnitTestSuite$1.setUp(CallbackEventJUnitTestSuite.java:56) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testSetup(EntityManagerJUnitTestSuite.java:254) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	13.514
testWeaving	Success		0.002
testClearEntityManagerWithoutPersistenceContext	Success		0.000
testUpdateAllProjects	Success		0.378
testUpdateUsingTempStorage	Success		0.242
testSequenceObjectDefinition	Success		0.000
testFindDeleteAllPersist	Success		0.143
testExtendedPersistenceContext	Success		0.280
testRemoveFlushFind	Success		0.072
testRemoveFlushPersistContains	Success		0.361
testTransactionRequired	Success		0.006
testSubString	Success		0.089
testFlushModeOnUpdateQuery	Success		0.080
testContainsRemoved	Success		0.031
testRefreshRemoved	Success		0.035
testRefreshNotManaged	Success		0.001
testDoubleMerge	Success		0.022
testDescriptorNamedQueryForMultipleQueries	Success		0.023
testDescriptorNamedQuery	Success		0.027
testClearEntityManagerWithoutPersistenceContextSimulateJTA	Success		0.004
testMultipleEntityManagerFactories	Success		6.177
testOneToManyDefaultJoinTableName	Success		0.152
testClosedEmShouldThrowException	Success		0.001
testRollbackOnlyOnException	Success		0.001
testUpdateAllProjectsWithNullTeamLeader	Success		0.246
testUpdateAllLargeProjectsWithNullTeamLeader	Success		0.208
testUpdateAllSmallProjectsWithNullTeamLeader	Success		0.171
testUpdateAllProjectsWithName	Success		0.096
testUpdateAllLargeProjectsWithName	Success		0.091
testUpdateAllSmallProjectsWithName	Success		0.076
testUpdateAllLargeProjects	Success		0.140
testUpdateAllSmallProjects	Success		0.156
testUpdateUsingTempStorageWithParameter	Success		0.167
testDeleteAllLargeProjectsWithNullTeamLeader	Success		0.107
testDeleteAllSmallProjectsWithNullTeamLeader	Success		0.675
testDeleteAllProjectsWithNullTeamLeader	Success		0.148
testDeleteAllPhonesWithNullOwner	Success		0.036
testSetFieldForPropertyAccessWithNewEM	Success		0.433
testSetFieldForPropertyAccessWithRefresh	Success		0.134
testSetFieldForPropertyAccess	Success		0.111
testInitializeFieldForPropertyAccess	Success		0.047
testCascadePersistToNonEntitySubclass	Success		0.033
testCascadeMergeManaged	Success		0.066
testCascadeMergeDetached	Success		0.052
testPrimaryKeyUpdatePKFK	Success		0.041
testPrimaryKeyUpdateSameValue	Success		0.013
testPrimaryKeyUpdate	Success		0.019
testRemoveNull	Success		0.001
testContainsNull	Success		0.001
testPersistNull	Success		0.000
testMergeNull	Success		0.000
testMergeRemovedObject	Success		0.034
testMergeDetachedObject	Error	Exception Description: Cannot persist detached object [Employee: 41]. Class> org.eclipse.persistence.testing.models.jpa.advanced.Employee Primary Key> [41]javax.persistence.EntityExistsException: Exception Description: Cannot persist detached object [Employee: 41]. Class> org.eclipse.persistence.testing.models.jpa.advanced.Employee Primary Key> [41] at org.eclipse.persistence.internal.jpa.EntityManagerImpl.persist(EntityManagerImpl.java:222) at org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testMergeDetachedObject(EntityManagerJUnitTestSuite.java:3478) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: Exception [EclipseLink-7231] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot persist detached object [Employee: 41]. Class> org.eclipse.persistence.testing.models.jpa.advanced.Employee Primary Key> [41] at org.eclipse.persistence.exceptions.ValidationException.cannotPersistExistingObject(ValidationException.java:2258) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNotRegisteredNewObjectForPersist(UnitOfWorkImpl.java:3865) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.registerNotRegisteredNewObjectForPersist(RepeatableWriteUnitOfWork.java:369) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNewObjectForPersist(UnitOfWorkImpl.java:3827) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.persist(EntityManagerImpl.java:219)	0.021
testSerializedLazy	Success		0.138
testCloneable	Success		0.068
testLeftJoinOneToOneQuery	Success		0.013
testNullifyAddressIn	Success		0.013
testQueryOnClosedEM	Success		0.003
testIncorrectBatchQueryHint	Success		0.006
testFetchQueryHint	Success		0.301
testBatchQueryHint	Success		0.123
testQueryHints	Success		0.004
testParallelMultipleFactories	Success		0.002
testMultipleFactories	Success		10.089
testPersistenceProperties	Success		0.001
testBeginTransactionCloseCommitTransaction	Success		0.375
testBeginTransactionClose	Success		0.001
testClose	Success		0.000
testPersistOnNonEntity	Success		0.001
testWRITELock	Success		0.124
testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush	Success		0.323
testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh	Success		0.059
testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush	Success		0.059
testReadTransactionIsolation_OriginalInCache_UpdateAll	Success		0.060
testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush	Success		0.060
testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh	Success		0.059
testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush	Success		0.055
testReadTransactionIsolation_OriginalInCache_CustomUpdate	Success		0.047
testReadTransactionIsolation_UpdateAll_Refresh_Flush	Success		0.064
testReadTransactionIsolation_UpdateAll_Refresh	Success		0.055
testReadTransactionIsolation_UpdateAll_Flush	Success		0.055
testReadTransactionIsolation_UpdateAll	Success		0.048
testReadTransactionIsolation_CustomUpdate_Refresh_Flush	Success		0.063
testReadTransactionIsolation_CustomUpdate_Refresh	Success		0.055
testReadTransactionIsolation_CustomUpdate_Flush	Success		0.055
testReadTransactionIsolation_CustomUpdate	Success		0.047
testClearInTransaction	Success		0.078
testClearWithFlush	Success		0.117
testClear	Success		0.012
testCheckVersionOnMerge	Success		0.020
testFindWithNullPk	Success		0.001
testFindWithWrongTypePk	Success		0.001
testPersistManagedNoException	Success		0.020
testPersistManagedException	Success		0.011
testPersistRemoved	Success		0.752
testREADLock	Success		0.046
testIgnoreRemovedObjectsOnDatabaseSync	Success		0.081
testIdentityOutsideTransaction	Success		0.024
testIdentityInsideTransaction	Success		0.007
testDatabaseSyncNewObject	Success		0.001
testSetRollbackOnly	Success		0.112
testFlushModeEmCommitQueryAuto	Success		0.024
testFlushModeEmCommit	Success		0.008
testFlushModeEmCommitQueryCommit	Success		0.014
testFlushModeEmAutoQueryAuto	Success		0.017
testFlushModeEmAuto	Success		0.016
testFlushModeEmAutoQueryCommit	Success		0.008
testCacheUsage	Success		0.089
testSequencePreallocationUsingCallbackTest	Success		0.035
testForceSQLExceptionFor219097	Success		0.007
testRefreshInvalidateDeletedObject	Success		0.035
testClearWithFlush2	Success		0.193
testEMFWrapValidationException	Success		0.162
testEMDefaultTxType	Success		0.811
testMergeNewObject	Success		0.003
testMergeNewObject2	Success		0.025
testMergeNewObject3_UseSequencing	Success		0.004
testMergeNewObject3_DontUseSequencing	Success		0.029
testCreateEntityManagerFactory	Success		0.002
testCreateEntityManagerFactory2	Success		0.922
testPessimisticLockHintStartsTransaction	Success		0.008
testManyToOnePersistCascadeOnFlush	Success		0.464
testDiscoverNewReferencedObject	Success		0.918
testBulkDeleteThenMerge	Success		1.191
testNativeSequences	Success		0.000
testGetReference	Success		0.064
testGetReferenceUpdate	Success		0.077
testGetReferenceUsedInUpdate	Success		0.162
testBadGetReference	Success		0.004
testClassInstanceConverter	Success		0.078
test210280EntityManagerFromPUwithSpaceInNameButNotInPath	Success		0.145
test210280EntityManagerFromPUwithSpaceInPathButNotInName	Success		0.141
test210280EntityManagerFromPUwithSpaceInNameAndPath	Success		0.216
testNewObjectNotCascadePersist	Success		0.001
testConnectionPolicy	Success		0.012
testConverterIn	Success		0.007
testExceptionForPersistNonEntitySubclass	Success		0.001
testEnabledPersistNonEntitySubclass	Success		0.001
testCloneEmbeddable	Success		0.001
testEmbeddedNPE	Success		473.073
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.SQLResultSetMappingTestSuite$1.setUp(SQLResultSetMappingTestSuite.java:281) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.JoinedAttributeAdvancedJunitTest$1.setUp(JoinedAttributeAdvancedJunitTest.java:121) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.001
testSimpleReturnDirectToField	Success		0.004
testSimpleReturnObject	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.advanced.ReportQueryMultipleReturnTestSuite.testSimpleReturnObject(ReportQueryMultipleReturnTestSuite.java:77) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
testReturnObjectAndDirectToField	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.advanced.ReportQueryMultipleReturnTestSuite.testReturnObjectAndDirectToField(ReportQueryMultipleReturnTestSuite.java:90) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
testReturnUnrelatedObjectAndDirectToField	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.advanced.ReportQueryMultipleReturnTestSuite.testReturnUnrelatedObjectAndDirectToField(ReportQueryMultipleReturnTestSuite.java:110) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.008
testInheritanceMultiTableException	Success		0.004
testReturnRootObject	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.advanced.ReportQueryMultipleReturnTestSuite.testReturnRootObject(ReportQueryMultipleReturnTestSuite.java:142) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.006
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.ReportQueryAdvancedJUnitTest$1.setUp(ReportQueryAdvancedJUnitTest.java:104) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.ExtendedPersistenceContextJUnitTestSuite$1.setUp(ExtendedPersistenceContextJUnitTestSuite.java:47) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.ReportQueryConstructorExpressionTestSuite$1.setUp(ReportQueryConstructorExpressionTestSuite.java:74) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.OptimisticConcurrencyJUnitTestSuite$1.setUp(OptimisticConcurrencyJUnitTestSuite.java:62) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.AdvancedJPAJunitTest$1.setUp(AdvancedJPAJunitTest.java:118) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.advanced.AdvancedJunitTest$1.setUp(AdvancedJunitTest.java:55) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
testCreateDepartment	Success		0.031
testCreateScientists	Success		0.105
testReadDepartment	Success		455.942
testReadJuniorScientist	Success		0.027
testAnyAndAll	Success		0.057
testNamedNativeQuery	Success		0.002
testPersistThenRemoveCalls	Success		0.062
testRemoveUnmanagedNewEntity	Success		0.031
testPersistOnRegisteredObject	Success		0.023
testPreUpdateEvent_UpdateAltered	Success		0.040
testPreUpdateEvent_UpdateReverted	Success		0.079
testSetup	Success		8.794
testWeaving	Success		0.002
testClearEntityManagerWithoutPersistenceContext	Success		0.001
testUpdateAllProjects	Success		0.095
testUpdateUsingTempStorage	Success		0.143
testSequenceObjectDefinition	Success		0.001
testFindDeleteAllPersist	Success		0.071
testExtendedPersistenceContext	Success		0.143
testRemoveFlushFind	Success		0.034
testRemoveFlushPersistContains	Success		0.039
testTransactionRequired	Success		0.001
testSubString	Success		0.031
testFlushModeOnUpdateQuery	Success		0.040
testContainsRemoved	Success		0.020
testRefreshRemoved	Success		0.032
testRefreshNotManaged	Success		0.001
testDoubleMerge	Success		0.011
testDescriptorNamedQueryForMultipleQueries	Success		0.012
testDescriptorNamedQuery	Success		0.012
testClearEntityManagerWithoutPersistenceContextSimulateJTA	Success		0.002
testMultipleEntityManagerFactories	Success		2.498
testOneToManyDefaultJoinTableName	Success		0.300
testClosedEmShouldThrowException	Success		0.001
testRollbackOnlyOnException	Success		0.001
testUpdateAllProjectsWithNullTeamLeader	Success		0.102
testUpdateAllLargeProjectsWithNullTeamLeader	Success		0.083
testUpdateAllSmallProjectsWithNullTeamLeader	Success		0.071
testUpdateAllProjectsWithName	Success		0.047
testUpdateAllLargeProjectsWithName	Success		0.064
testUpdateAllSmallProjectsWithName	Success		0.051
testUpdateAllLargeProjects	Success		0.055
testUpdateAllSmallProjects	Success		0.055
testUpdateUsingTempStorageWithParameter	Success		0.084
testDeleteAllLargeProjectsWithNullTeamLeader	Success		0.038
testDeleteAllSmallProjectsWithNullTeamLeader	Success		0.033
testDeleteAllProjectsWithNullTeamLeader	Success		0.030
testDeleteAllPhonesWithNullOwner	Success		0.004
testSetFieldForPropertyAccessWithNewEM	Success		0.062
testSetFieldForPropertyAccessWithRefresh	Success		0.051
testSetFieldForPropertyAccess	Success		0.055
testInitializeFieldForPropertyAccess	Success		0.031
testCascadePersistToNonEntitySubclass	Success		0.036
testCascadeMergeManaged	Success		0.036
testCascadeMergeDetached	Success		0.044
testPrimaryKeyUpdatePKFK	Success		0.022
testPrimaryKeyUpdateSameValue	Success		0.012
testPrimaryKeyUpdate	Success		0.014
testRemoveNull	Success		0.001
testContainsNull	Success		0.001
testPersistNull	Success		0.001
testMergeNull	Success		0.001
testMergeRemovedObject	Success		0.025
testMergeDetachedObject	Success		0.028
testSerializedLazy	Success		0.083
testCloneable	Success		0.028
testLeftJoinOneToOneQuery	Success		0.004
testNullifyAddressIn	Success		0.007
testQueryOnClosedEM	Success		0.002
testIncorrectBatchQueryHint	Success		0.077
testFetchQueryHint	Success		0.088
testBatchQueryHint	Success		0.079
testQueryHints	Success		0.004
testParallelMultipleFactories	Success		0.208
testMultipleFactories	Success		0.001
testPersistenceProperties	Success		0.001
testBeginTransactionCloseCommitTransaction	Success		0.044
testBeginTransactionClose	Success		0.000
testClose	Success		0.000
testPersistOnNonEntity	Success		0.001
testWRITELock	Success		0.037
testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush	Success		0.063
testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh	Success		0.069
testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush	Success		0.052
testReadTransactionIsolation_OriginalInCache_UpdateAll	Success		0.044
testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush	Success		0.056
testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh	Success		0.044
testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush	Success		0.040
testReadTransactionIsolation_OriginalInCache_CustomUpdate	Success		0.048
testReadTransactionIsolation_UpdateAll_Refresh_Flush	Success		0.052
testReadTransactionIsolation_UpdateAll_Refresh	Success		0.056
testReadTransactionIsolation_UpdateAll_Flush	Success		0.044
testReadTransactionIsolation_UpdateAll	Success		0.051
testReadTransactionIsolation_CustomUpdate_Refresh_Flush	Success		0.123
testReadTransactionIsolation_CustomUpdate_Refresh	Success		0.095
testReadTransactionIsolation_CustomUpdate_Flush	Success		0.040
testReadTransactionIsolation_CustomUpdate	Success		0.539
testClearInTransaction	Success		0.055
testClearWithFlush	Success		0.056
testClear	Success		0.012
testCheckVersionOnMerge	Success		0.020
testFindWithNullPk	Success		0.001
testFindWithWrongTypePk	Success		0.001
testPersistManagedNoException	Success		0.021
testPersistManagedException	Success		0.011
testPersistRemoved	Success		0.660
testREADLock	Success		0.039
testIgnoreRemovedObjectsOnDatabaseSync	Success		0.060
testIdentityOutsideTransaction	Success		0.006
testIdentityInsideTransaction	Success		0.002
testDatabaseSyncNewObject	Success		0.001
testSetRollbackOnly	Success		0.078
testFlushModeEmCommitQueryAuto	Success		0.023
testFlushModeEmCommit	Success		0.008
testFlushModeEmCommitQueryCommit	Success		0.008
testFlushModeEmAutoQueryAuto	Success		0.018
testFlushModeEmAuto	Success		0.015
testFlushModeEmAutoQueryCommit	Success		0.008
testCacheUsage	Success		0.052
testSuperclassFieldInSubclass	Success		0.030
testCopyingAddress	Success		0.001
testSequencePreallocationUsingCallbackTest	Success		2.091
testInheritanceNoDiscriminatorColumn	Success		0.008
testComplicateResultWithInheritance	Success		0.064
testRefresh	Success		0.110
testBindParameters	Success		0.007
testBindParametersWithPostitional	Success		0.007
testSimpleInheritance	Success		0.018
testPessimisticLocking	Success		0.016
testComplicateResults	Success		0.009
testProjectJoinTeamMembers	Success		0.394
testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull	Success		0.360
testProjectJoinTeamMembersJoinAddress	Success		0.279
testProjectOuterJoinTeamMembersJoinAddress	Success		0.279
testProjectOuterJoinTeamMembersOuterJoinAddress	Success		0.340
testProjectJoinTeamMembersOuterJoinAddress	Success		0.245
testProblemReporterProjectJoinTeamMembersJoinAddress	Success		0.210
testEmployeeJoinProjects	Success		0.246
testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull	Success		0.169
testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName	Success		0.220
testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones	Success		0.391
testEmployeeJoinManagerAddressOuterJoinManagerAddress	Success		0.193
testTwoUnrelatedResultWithOneToManyJoins	Success		0.319
testMultipleUnrelatedResultWithOneToManyJoins	Success		0.501
testTwoUnrelatedResultWithOneToOneJoins	Success		0.481
testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem	Success		0.460
testSimpleReturnDirectToField	Success		0.003
testSimpleReturnObject	Success		0.019
testReturnObjectAndDirectToField	Success		0.014
testReturnUnrelatedObjectAndDirectToField	Success		0.042
testInheritanceMultiTableException	Success		0.003
testReturnRootObject	Success		0.015
testExtendedPersistenceContext	Success		0.018
testSimpleConstructorExpression	Success		0.010
testSimpleConstructorExpressionWithNamedQuery	Success		0.008
testMultipleTypeConstructorExpression	Success		0.011
testNonExistantConstructorConstructorExpression	Success		0.002
testPrimitiveConstructorExpression	Success		0.006
testConstructorEJBQLWithInheritance	Success		0.003
testConstructorExpressionWithOtherAttributes	Success		0.006
testCreateProjects	Success		0.017
testCreateEmployeeWithFlush	Success		0.024
testVersionUpdateWithCorrectValue	Success		0.012
testVersionUpdateWithIncorrectValue	Success		0.014
testVersionUpdateWithNullValue	Success		0.015
testJoinFetchAnnotation	Success		0.001
testVerifyEmployeeCustomizerSettings	Success		0.000
testUpdateEmployee	Success		0.044
testVerifyUpdatedEmployee	Success		0.006
testCreateNewBuyer	Success		0.025
testVerifyNewBuyer	Success		0.011
testBuyerOptimisticLocking	Success		0.123
testGiveFredASexChange	Success		0.021
testUpdatePenelopesPhoneNumberStatus	Success		0.027
testRemoveJillWithPrivateOwnedPhoneNumbers	Success		0.037
testCreateNewEquipment	Success		0.030
testAddNewEquipmentToDepartment	Success		0.017
testRemoveDepartmentWithPrivateOwnedEquipment	Success		0.031
testUpdateReadOnlyEquipmentCode	Success		0.003
testNamedStoredProcedureQuery	Success		889.629
testNamedStoredProcedureQueryInOut	Success		2.141
testGF1818	Success		0.025
testGF1894	Success		0.025
testGF894	Success		0.023
testManAndWoman	Success		0.012
testStringArrayField	Success		0.009
testBUG241388	Success		0.016
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_FIELDACCESS_CUSTOMER' already exists Error Code: 1050 Call: CREATE TABLE CMP3_FIELDACCESS_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_FIELDACCESS_CUSTOMER' already exists Error Code: 1050 Call: CREATE TABLE CMP3_FIELDACCESS_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID)) Query: DataModifyQuery() at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.fieldaccess.relationships.UniAndBiDirectionalMappingTestSuite$1.setUp(UniAndBiDirectionalMappingTestSuite.java:50) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_FIELDACCESS_CUSTOMER' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
testLeftTrimWithTrimChar	Success		2.838
testLeftTrimWithoutTrimChar	Success		5.361
testRightTrimWithTrimChar	Success		10.139
testRightTrimWithoutTrimChar	Success		7.009
testTrimWithTrimChar	Success		9.310
testTrimWithoutTrimChar	Success		7.379
testLocateWithSingleArgument	Success		7.172
testLocateWithDoubleArgument	Success		5.616
testInsertVirtualAttribute	Success		0.032
testReadVirtualAttribute	Success		0.003
testUpdateVirtualAttribute	Success		0.012
testDeleteVirtualAttribute	Success		0.013
testSetup	Success		22.852
testPrePersistBusOverrideAndAbstractInheritAndDefault	Success		0.021
testPostPersistBusInheritAndDefault	Success		0.020
testPostLoadBusInheritAndDefault	Success		0.002
testPrePersistSportsCarInheritAndExcludeDefault	Success		0.010
testPostPersistSportsCarInheritAndExcludeDefault	Success		0.008
testPrePersistSportsCarOverride	Success		0.012
testSetup	Success		17.836
test_null	Success		0.663
test_nullNonDeferred	Success		0.759
test_ownerTOP	Success		0.551
test_fuelTypePetrol	Success		0.208
test_schoolBusNullDriver	Success		0.056
test_ownerOwnsNonFueledVehicle	Success		0.216
testSetup	Success		21.753
testPersistPolymorphicRelationship	Success		0.025
testAssociationWithEmbeddedIdSubclassEntityInJoinedStrategy	Success		0.024
testUpateTireInfo	Success		0.039
testSetup	Success		77.493
testCreateNewMudTire	Success		0.022
testCreateNewRockTire	Success		0.016
testReadNewMudTire	Success		0.002
testReadNewRockTire	Success		0.002
testSetup	Success		10.143
testVehicleJoinCompany	Success		0.066
testVehicleJoinCompanyWherePassengerCapacity	Success		0.039
testCompanyJoinVehicles	Success		0.031
testCompanyJoinVehiclesWhereNameTOP	Success		0.018
testSetup	Success		5.848
testInitialize	Success		0.086
test1	Success		0.054
testInitialize	Success		0.040
test2	Success		0.033
testInitialize	Success		0.022
test3	Success		0.055
testInitialize	Success		0.041
test1	Success		0.036
testInitialize	Success		0.031
test2	Success		0.026
testInitialize	Success		0.021
test3	Success		0.036
testSetup	Success		5.287
testCreateBlue	Success		0.030
testReadBlue	Success		0.003
testCreateBeerConsumer	Success		0.017
testCreateNoviceBeerConsumer	Success		0.011
testCreateExpertBeerConsumer	Success		0.015
testReadNoviceBeerConsumer	Success		0.008
testReadExpertBeerConsumer	Success		0.005
testUpdateBeerConsumer	Success		0.022
testInheritedClone	Success		0.060
testCascadeRemove	Success		0.023
testSetup	Success		4.897
testPreAndPostPersistAlpine	Success		0.014
testPrePersistAlpineOnMerge	Success		0.010
testPreAndPostPersistBeerConsumer	Success		0.008
testPostLoadOnFind	Success		0.000
testPostLoadOnRefresh	Success		0.003
testPreAndPostUpdate	Success		0.009
testPreAndPostRemove	Success		0.011
testSetup	Success		5.330
testExistenceCheckingSetting	Success		0.001
testCreateBeerConsumer	Success		0.011
testCreateAlpine	Success		0.027
testCreateCanadian	Success		0.017
testCreateCertifications	Success		0.022
testCreateTelephoneNumbers	Success		0.029
testReadBeerConsumer	Success		0.002
testReadAlpine	Success		0.003
testReadCanadian	Success		0.004
testInsertNewAlpine	Success		0.035
testInsertNewAlpineAndModifyOrderOfExistingAlpines	Success		0.035
testUpdateAlpine	Success		0.021
testUpdateAlpineThroughBeerConsumer	Success		0.020
testUpdateBeerConsumer	Success		0.092
testUpdateCanadian	Success		0.042
testUpdateCanadianThroughBeerConsumer	Success		0.023
testUpdateCertifications	Success		0.028
testUpdateTelephoneNumberThroughBeerConsumer	Success		0.015
testShuffleTelephoneNumbersOnBeerConsumers	Success		0.019
testDeleteAlpine	Success		0.012
testDeleteCanadian	Success		0.012
testDeleteBeerConsumer	Success		0.020
testOptimisticLockingTest	Success		0.028
testgetReference	Success		5.322
testcreateNativeQuery	Success		3.907
testcreateNativeQueryWithSelectSQL	Success		6.584
testNativeNamedQuery	Success		4.067
testSetParameterUsingNull	Success		4.254
testExcludingUnneccesaryJoin	Success		4.533
testRemoveUnneccesaryDistinctFromJoin	Success		4.387
testLeftTrimWithTrimChar	Success		4.787
testLeftTrimWithoutTrimChar	Success		5.555
testRightTrimWithTrimChar	Success		7.029
testRightTrimWithoutTrimChar	Success		4.630
testTrimWithTrimChar	Success		4.409
testTrimWithoutTrimChar	Success		4.358
testLocateWithSingleArgument	Success		4.346
testLocateWithDoubleArgument	Success		4.264
testSetup	Success		0.447
testInsertVirtualAttribute	Success		0.042
testReadVirtualAttribute	Success		0.002
testUpdateVirtualAttribute	Success		0.014
testDeleteVirtualAttribute	Success		0.012
testCacheIsolation_PropertiesDefault_Config	Success		0.098
testCacheIsolation_XMLDefault_Config	Success		0.179
testJTADatasource_Config_Override	Success		0.004
testNonJTADatasource_Config_Override	Success		0.208
testPKClassTypeValidation	Success		0.000
testParameterNameValidation	Success		0.003
testParameterPositionValidation	Success		0.001
testParameterPositionValidation2	Success		0.002
selfReferencingManyToManyCreateTest	Success		4.521
testManyToManyClearDelete	Success		4.536
testSetup	Success		4.429
testCreateItem	Success		0.029
testModifyItem	Success		0.012
testVerifyItem	Success		0.002
testInstantiationCopyPolicy	Success		0.001
testCopyPolicy	Success		0.000
testCloneCopyPolicy	Success		0.001
testCollectionImplementation	Success		0.008
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLUnitTestSuite.testSetup(JUnitJPQLUnitTestSuite.java:111) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.782
testSelectPhoneNumberAreaCode	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLUnitTestSuite.testSelectPhoneNumberAreaCode(JUnitJPQLUnitTestSuite.java:215) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
testSelectPhoneNumberAreaCodeWithEmployee	Error	N/A`java.util.NoSuchElementException at java.util.Vector.firstElement(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLUnitTestSuite.testSelectPhoneNumberAreaCodeWithEmployee(JUnitJPQLUnitTestSuite.java:225) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
testSelectPhoneNumberNumberWithEmployeeWithExplicitJoin	Error	N/A`java.util.NoSuchElementException at java.util.Vector.firstElement(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLUnitTestSuite.testSelectPhoneNumberNumberWithEmployeeWithExplicitJoin(JUnitJPQLUnitTestSuite.java:262) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
testSelectPhoneNumberNumberWithEmployeeWithFirstNameFirst	Error	N/A`java.util.NoSuchElementException at java.util.Vector.firstElement(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLUnitTestSuite.testSelectPhoneNumberNumberWithEmployeeWithFirstNameFirst(JUnitJPQLUnitTestSuite.java:300) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
testSelectEmployeeWithSameParameterUsedMultipleTimes	Success		0.018
testOuterJoinOnOneToOne	Failure	Outer join was not properly added to the query`junit.framework.AssertionFailedError: Outer join was not properly added to the query at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLUnitTestSuite.testOuterJoinOnOneToOne(JUnitJPQLUnitTestSuite.java:178) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.037
testOuterJoinPolymorphic	Success		0.013
testFirstResultOnNamedQuery	Success		0.005
testInvertedSelectionCriteriaNullPK	Success		0.004
testInvertedSelectionCriteriaInvalidQueryKey	Success		0.003
testMaxAndFirstResultsOnDataQuery	Success		0.003
testMaxAndFirstResultsOnDataQueryWithGroupBy	Success		0.004
testDistinctSelectForEmployeeWithNullAddress	Success		0.013
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.testSetup(JUnitJPQLSimpleTestSuite.java:178) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	159.600
simpleJoinFetchTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleJoinFetchTest(JUnitJPQLSimpleTestSuite.java:255) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleJoinFetchTest(JUnitJPQLSimpleTestSuite.java:205) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.144
simpleJoinFetchTest2	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleJoinFetchTest(JUnitJPQLSimpleTestSuite.java:255) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleJoinFetchTest2(JUnitJPQLSimpleTestSuite.java:222) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.085
baseTestCase	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.baseTestCase(JUnitJPQLSimpleTestSuite.java:300) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.015
simpleABSTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleABSTest(JUnitJPQLSimpleTestSuite.java:320) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.018
simpleBetweenAndTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleBetweenAndTest(JUnitJPQLSimpleTestSuite.java:344) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.019
simpleBetweenTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleBetweenTest(JUnitJPQLSimpleTestSuite.java:369) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.015
simpleConcatTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleConcatTest(JUnitJPQLSimpleTestSuite.java:397) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
simpleConcatTestWithParameters	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleConcatTestWithParameters(JUnitJPQLSimpleTestSuite.java:425) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
simpleConcatTestWithConstants1	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleConcatTestWithConstants1(JUnitJPQLSimpleTestSuite.java:458) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
simpleDistinctTest	Success		0.005
simpleDistinctNullTest	Success		0.039
simpleDistinctMultipleResultTest	Success		0.005
simpleDoubleOrTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleDoubleOrTest(JUnitJPQLSimpleTestSuite.java:551) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.013
simpleEqualsBracketsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleEqualsBracketsTest(JUnitJPQLSimpleTestSuite.java:569) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
simpleEqualsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleEqualsTest(JUnitJPQLSimpleTestSuite.java:587) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
simpleEqualsTestWithJoin	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleEqualsTestWithJoin(JUnitJPQLSimpleTestSuite.java:606) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
simpleEqualsWithAs	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleEqualsWithAs(JUnitJPQLSimpleTestSuite.java:621) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
collectionMemberIdentifierEqualsTest	Error	N/A`java.util.NoSuchElementException at java.util.Vector.firstElement(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.collectionMemberIdentifierEqualsTest(JUnitJPQLSimpleTestSuite.java:630) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
abstractSchemaIdentifierEqualsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.abstractSchemaIdentifierEqualsTest(JUnitJPQLSimpleTestSuite.java:654) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.008
abstractSchemaIdentifierNotEqualsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.abstractSchemaIdentifierNotEqualsTest(JUnitJPQLSimpleTestSuite.java:672) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.015
simpleInOneDotTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleInOneDotTest(JUnitJPQLSimpleTestSuite.java:692) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
simpleInTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleInTest(JUnitJPQLSimpleTestSuite.java:722) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.008
simpleLengthTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleLengthTest(JUnitJPQLSimpleTestSuite.java:741) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
simpleLikeTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleLikeTest(JUnitJPQLSimpleTestSuite.java:757) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
simpleLikeTestWithParameter	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleLikeTestWithParameter(JUnitJPQLSimpleTestSuite.java:784) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.008
simpleLikeEscapeTestWithParameter	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleLikeEscapeTestWithParameter(JUnitJPQLSimpleTestSuite.java:818) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
simpleNotBetweenTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleNotBetweenTest(JUnitJPQLSimpleTestSuite.java:847) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
simpleNotEqualsVariablesInteger	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleNotEqualsVariablesInteger(JUnitJPQLSimpleTestSuite.java:866) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.015
simpleNotInTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleNotInTest(JUnitJPQLSimpleTestSuite.java:893) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.017
simpleNotLikeTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleNotLikeTest(JUnitJPQLSimpleTestSuite.java:918) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.017
simpleOrFollowedByAndTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleOrFollowedByAndTest(JUnitJPQLSimpleTestSuite.java:934) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.012
simpleOrFollowedByAndTestWithStaticNames	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleOrFollowedByAndTestWithStaticNames(JUnitJPQLSimpleTestSuite.java:956) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
simpleOrTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleOrTest(JUnitJPQLSimpleTestSuite.java:974) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
simpleParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleParameterTest(JUnitJPQLSimpleTestSuite.java:1003) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.008
simpleParameterTestChangingParameters	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleParameterTestChangingParameters(JUnitJPQLSimpleTestSuite.java:1045) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
simpleReverseAbsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseAbsTest(JUnitJPQLSimpleTestSuite.java:1059) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.017
simpleReverseConcatTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseConcatTest(JUnitJPQLSimpleTestSuite.java:1083) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.008
simpleReverseEqualsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseEqualsTest(JUnitJPQLSimpleTestSuite.java:1099) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
simpleReverseLengthTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseLengthTest(JUnitJPQLSimpleTestSuite.java:1114) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.012
simpleReverseParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseParameterTest(JUnitJPQLSimpleTestSuite.java:1145) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
simpleReverseSqrtTest	Error	N/A`java.util.NoSuchElementException at java.util.Vector.firstElement(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseSqrtTest(JUnitJPQLSimpleTestSuite.java:1159) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
simpleReverseSubstringTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleReverseSubstringTest(JUnitJPQLSimpleTestSuite.java:1191) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
simpleSqrtTest	Error	N/A`java.util.NoSuchElementException at java.util.Vector.firstElement(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleSqrtTest(JUnitJPQLSimpleTestSuite.java:1207) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
simpleSubstringTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleSubstringTest(JUnitJPQLSimpleTestSuite.java:1234) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
simpleNullTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleNullTest(JUnitJPQLSimpleTestSuite.java:1269) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.038
simpleNotNullTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleNotNullTest(JUnitJPQLSimpleTestSuite.java:1303) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.168
distinctTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.distinctTest(JUnitJPQLSimpleTestSuite.java:1324) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
conformResultsInUnitOfWorkTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.conformResultsInUnitOfWorkTest(JUnitJPQLSimpleTestSuite.java:1382) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.084
simpleModTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleModTest(JUnitJPQLSimpleTestSuite.java:1407) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
simpleIsEmptyTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleIsEmptyTest(JUnitJPQLSimpleTestSuite.java:1438) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.015
simpleIsNotEmptyTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleIsNotEmptyTest(JUnitJPQLSimpleTestSuite.java:1459) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
simpleApostrohpeTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleApostrohpeTest(JUnitJPQLSimpleTestSuite.java:1485) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
simpleEscapeUnderscoreTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.simpleEscapeUnderscoreTest(JUnitJPQLSimpleTestSuite.java:1516) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
simpleEnumTest	Success		0.004
smallProjectMemberOfProjectsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.smallProjectMemberOfProjectsTest(JUnitJPQLSimpleTestSuite.java:1538) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
smallProjectNOTMemberOfProjectsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.smallProjectNOTMemberOfProjectsTest(JUnitJPQLSimpleTestSuite.java:1570) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.013
selectCountOneToOneTest	Success		0.010
selectOneToOneTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectOneToOneTest(JUnitJPQLSimpleTestSuite.java:1618) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
selectPhonenumberDeclaredInINClauseTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectPhonenumberDeclaredInINClauseTest(JUnitJPQLSimpleTestSuite.java:1646) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.017
selectPhoneUsingALLTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectPhoneUsingALLTest(JUnitJPQLSimpleTestSuite.java:1719) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
selectSimpleMemberOfWithParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectSimpleMemberOfWithParameterTest(JUnitJPQLSimpleTestSuite.java:1756) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.026
selectSimpleNotMemberOfWithParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectSimpleNotMemberOfWithParameterTest(JUnitJPQLSimpleTestSuite.java:1796) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.036
selectSimpleBetweenWithParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectSimpleBetweenWithParameterTest(JUnitJPQLSimpleTestSuite.java:1845) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.018
selectSimpleInWithParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLSimpleTestSuite.selectSimpleInWithParameterTest(JUnitJPQLSimpleTestSuite.java:1876) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
selectAverageQueryForByteColumnTest	Success		0.003
selectUsingLockModeQueryHintTest	Success		0.007
multipleExecutionOfNamedQueryTest	Success		0.004
selectNamedNativeQueryWithPositionalParameterTest	Success		0.007
selectNativeQueryWithPositionalParameterTest	Success		0.002
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.testSetup(JUnitJPQLComplexTestSuite.java:161) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.464
complexABSTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexABSTest(JUnitJPQLComplexTestSuite.java:204) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.025
complexABSWithParameterTest	Success		0.020
compexInTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.compexInTest(JUnitJPQLComplexTestSuite.java:263) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.017
complexLengthTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexLengthTest(JUnitJPQLComplexTestSuite.java:284) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
complexLikeTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexLikeTest(JUnitJPQLComplexTestSuite.java:310) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
complexNotInTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNotInTest(JUnitJPQLComplexTestSuite.java:346) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.027
complexNotLikeTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNotLikeTest(JUnitJPQLComplexTestSuite.java:375) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.021
complexParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexParameterTest(JUnitJPQLComplexTestSuite.java:415) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
complexReverseAbsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexReverseAbsTest(JUnitJPQLComplexTestSuite.java:439) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.022
complexReverseLengthTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexReverseLengthTest(JUnitJPQLComplexTestSuite.java:462) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
complexReverseParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexReverseParameterTest(JUnitJPQLComplexTestSuite.java:502) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
complexReverseSqrtTest	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexReverseSqrtTest(JUnitJPQLComplexTestSuite.java:521) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
complexSqrtTest	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexSqrtTest(JUnitJPQLComplexTestSuite.java:555) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
complexStringInTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexStringInTest(JUnitJPQLComplexTestSuite.java:603) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.018
complexStringNotInTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexStringNotInTest(JUnitJPQLComplexTestSuite.java:641) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.025
complexSubstringTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexSubstringTest(JUnitJPQLComplexTestSuite.java:667) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.012
complexLocateTest	Error	getSingleResult() did not retrieve any entities.javax.persistence.NoResultException: getSingleResult() did not retrieve any entities. at org.eclipse.persistence.internal.jpa.EJBQueryImpl.throwNoResultException(EJBQueryImpl.java:945) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:552) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexLocateTest(JUnitJPQLComplexTestSuite.java:675) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)	0.004
complexNestedOneToManyUsingInClause	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNestedOneToManyUsingInClause(JUnitJPQLComplexTestSuite.java:713) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.012
complexUnusedVariableTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexUnusedVariableTest(JUnitJPQLComplexTestSuite.java:737) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
complexJoinTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexJoinTest(JUnitJPQLComplexTestSuite.java:774) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
complexMultipleJoinOfSameRelationship	Error	getSingleResult() did not retrieve any entities.javax.persistence.NoResultException: getSingleResult() did not retrieve any entities. at org.eclipse.persistence.internal.jpa.EJBQueryImpl.throwNoResultException(EJBQueryImpl.java:945) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:552) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexMultipleJoinOfSameRelationship(JUnitJPQLComplexTestSuite.java:797) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)	0.004
complexMultipleLeftOuterJoinOfSameRelationship	Error	getSingleResult() did not retrieve any entities.javax.persistence.NoResultException: getSingleResult() did not retrieve any entities. at org.eclipse.persistence.internal.jpa.EJBQueryImpl.throwNoResultException(EJBQueryImpl.java:945) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:552) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexMultipleLeftOuterJoinOfSameRelationship(JUnitJPQLComplexTestSuite.java:811) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)	0.003
complexFetchJoinTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexFetchJoinTest(JUnitJPQLComplexTestSuite.java:837) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
complexOneToOneFetchJoinTest	Success		0.042
complexSelectRelationshipTest	Failure	Select Relationship Test Case Failed (employee with manager) expected:<Employee: 29515> but was:<Employee: 29515>`junit.framework.AssertionFailedError: Select Relationship Test Case Failed (employee with manager) expected: but was: at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexSelectRelationshipTest(JUnitJPQLComplexTestSuite.java:905) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
complexConstructorTest	Success		0.011
complexConstructorVariableTest	Success		0.010
complexConstructorRelationshipTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexConstructorRelationshipTest(JUnitJPQLComplexTestSuite.java:998) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
complexConstructorAggregatesTest	Success		0.012
complexConstructorCountOnJoinedVariableTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexConstructorCountOnJoinedVariableTest(JUnitJPQLComplexTestSuite.java:1071) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.062
complexResultPropertiesTest	Success		0.025
complexInSubqueryTest	Success		0.006
complexExistsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexExistsTest(JUnitJPQLComplexTestSuite.java:1208) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.125
complexNotExistsTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNotExistsTest(JUnitJPQLComplexTestSuite.java:1230) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.034
complexMemberOfTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexMemberOfTest(JUnitJPQLComplexTestSuite.java:1245) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.009
complexNotMemberOfTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNotMemberOfTest(JUnitJPQLComplexTestSuite.java:1272) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.016
complexNavigatingEmbedded	Failure	Complex navigation of embedded in the select/where clause failed`junit.framework.AssertionFailedError: Complex navigation of embedded in the select/where clause failed at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNavigatingEmbedded(JUnitJPQLComplexTestSuite.java:1352) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
complexNavigatingTwoLevelOfEmbeddeds	Failure	Complex navigation of two level of embeddeds in the select clause failed`junit.framework.AssertionFailedError: Complex navigation of two level of embeddeds in the select clause failed at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexNavigatingTwoLevelOfEmbeddeds(JUnitJPQLComplexTestSuite.java:1367) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
complexNamedQueryResultPropertiesTest	Success		0.027
complexOuterJoinQuery	Failure	Complex outer join query (1): unexpected result size expected:<2> but was:<0>`junit.framework.AssertionFailedError: Complex outer join query (1): unexpected result size expected:<2> but was:<0> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.complexOuterJoinQuery(JUnitJPQLComplexTestSuite.java:1394) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.006
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLInheritanceTestSuite.testSetup(JUnitJPQLInheritanceTestSuite.java:101) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.601
testStraightReadSuperClass	Success		0.049
testStraightReadSubClass	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLInheritanceTestSuite.testStraightReadSubClass(JUnitJPQLInheritanceTestSuite.java:134) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
testJoinSuperClass	Success		0.012
testJoinSubClass	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLInheritanceTestSuite.testJoinSubClass(JUnitJPQLInheritanceTestSuite.java:159) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
testJoinFetchSuperClass	Success		0.011
testJoinFetchSubClass	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLInheritanceTestSuite.testJoinFetchSubClass(JUnitJPQLInheritanceTestSuite.java:185) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
testJoinedInheritance	Error	getSingleResult() did not retrieve any entities.javax.persistence.NoResultException: getSingleResult() did not retrieve any entities. at org.eclipse.persistence.internal.jpa.EJBQueryImpl.throwNoResultException(EJBQueryImpl.java:945) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:552) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLInheritanceTestSuite.testJoinedInheritance(JUnitJPQLInheritanceTestSuite.java:205) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)	0.004
testJoinedInheritanceWithLeftOuterJoin1	Success		0.004
testJoinedInheritanceWithLeftOuterJoin2	Success		0.004
testJoinedInheritanceWithLeftOuterJoin3	Success		0.004
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLValidationTestSuite.testSetup(JUnitJPQLValidationTestSuite.java:144) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.498
generalExceptionTest	Success		0.011
recognitionExceptionTest	Success		0.002
missingSelectExceptionTest	Success		0.001
malformedJPQLExceptionTest1	Success		0.002
malformedJPQLExceptionTest2	Success		0.001
malformedJPQLExceptionTest3	Success		0.001
malformedJPQLExceptionTest4	Success		0.001
malformedJPQLExceptionTest5	Success		0.003
malformedJPQLExceptionTest6	Success		0.009
malformedJPQLExceptionTest7	Success		0.002
malformedJPQLExceptionTest8	Success		0.003
noAliasWithWHEREAndParameterExceptionTest	Success		0.001
multipleDeclarationOfIdentificationVariable	Success		0.002
aliasResolutionException	Success		0.004
illegalArgumentExceptionTest	Success		0.001
createNamedQueryThrowsIllegalArgumentExceptionTest	Success		0.000
flushTxExceptionTest	Success		0.000
testExecuteUpdateTxException	Success		0.002
noResultExceptionTest	Success		0.003
testGetSingleResultOnUpdate	Success		0.002
testGetSingleResultOnDelete	Success		0.001
testExecuteUpdateOnSelect	Success		0.001
flushOptimisticLockExceptionTest	Failure	N/A`junit.framework.AssertionFailedError at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLValidationTestSuite.flushOptimisticLockExceptionTest(JUnitJPQLValidationTestSuite.java:870) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.855
commitOptimisticLockExceptionTest	Failure	Exception not instance of opt Lock exception`junit.framework.AssertionFailedError: Exception not instance of opt Lock exception at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLValidationTestSuite.commitOptimisticLockExceptionTest(JUnitJPQLValidationTestSuite.java:920) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
JTAOptimisticLockExceptionTest	Failure	N/A`junit.framework.AssertionFailedError at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLValidationTestSuite.JTAOptimisticLockExceptionTest(JUnitJPQLValidationTestSuite.java:970) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
testParameterNameValidation	Success		0.000
testModArgumentValidation	Success		0.003
testInExpressionValidation	Success		0.001
testOrderableTypeInOrderByItem	Success		0.002
testInvalidNavigation	Success		0.003
testInvalidCollectionNavigation	Success		0.002
testUnknownAttribute	Success		0.002
testUnknownEnumConstant	Success		0.002
testCommitRollbackException	Failure	N/A`junit.framework.AssertionFailedError at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLValidationTestSuite.testCommitRollbackException(JUnitJPQLValidationTestSuite.java:1144) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
testParameterPositionValidation	Success		0.001
testParameterPositionValidation2	Success		0.001
testParameterTypeValidation	Success		0.001
testEjbqlCaseSensitivity	Success		0.009
testEjbqlUnsupportJoinArgument	Success		0.002
testInvalidSetClause	Success		0.003
testUnsupportedCountDistinctOnOuterJoinedCompositePK	Success		0.002
testInvalidHint	Success		0.002
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.testSetup(JUnitJPQLComplexAggregateTestSuite.java:122) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.896
complexAVGTest	Success		0.006
complexCountDistinctWithGroupByAndHavingTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountDistinctWithGroupByAndHavingTest(JUnitJPQLComplexAggregateTestSuite.java:202) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.006
complexCountDistinctWithGroupByTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountDistinctWithGroupByTest(JUnitJPQLComplexAggregateTestSuite.java:232) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
complexCountDistinctWithGroupByTest2	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountDistinctWithGroupByTest2(JUnitJPQLComplexAggregateTestSuite.java:262) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
complexHavingWithAggregate	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexHavingWithAggregate(JUnitJPQLComplexAggregateTestSuite.java:291) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.029
complexCountTest	Success		0.004
complexCountWithGroupByTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountWithGroupByTest(JUnitJPQLComplexAggregateTestSuite.java:370) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
complexDistinctCountTest	Success		0.004
complexMaxTest	Success		0.005
complexMinTest	Success		0.003
complexSumTest	Success		0.003
complexCountDistinctOnBaseQueryClass	Success		0.010
complexCountOnJoinedVariableSimplePK	Failure	Complex COUNT on joined variable simple PK expected:<[0, 0, 1, 1]> but was:<[0]>`junit.framework.AssertionFailedError: Complex COUNT on joined variable simple PK expected:<[0, 0, 1, 1]> but was:<[0]> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountOnJoinedVariableSimplePK(JUnitJPQLComplexAggregateTestSuite.java:506) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
complexCountOnJoinedVariableCompositePK	Failure	Complex COUNT on outer joined variable composite PK expected:<[2, 3, 5]> but was:<[]>`junit.framework.AssertionFailedError: Complex COUNT on outer joined variable composite PK expected:<[2, 3, 5]> but was:<[]> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountOnJoinedVariableCompositePK(JUnitJPQLComplexAggregateTestSuite.java:533) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
complexCountOnJoinedVariableOverManyToManySelfRefRelationship	Failure	Complex COUNT on joined variable over ManyToMany self refrenceing relationship failed expected:<[0, 0, 0, 0]> but was:<[0]>`junit.framework.AssertionFailedError: Complex COUNT on joined variable over ManyToMany self refrenceing relationship failed expected:<[0, 0, 0, 0]> but was:<[0]> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexAggregateTestSuite.complexCountOnJoinedVariableOverManyToManySelfRefRelationship(JUnitJPQLComplexAggregateTestSuite.java:598) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
complexCountOnJoinedCompositePK	Success		0.033
testSetup	Success		0.232
testSqlDate	Success		0.004
testSqlDateToTS	Success		0.003
testTime	Success		0.006
testTimeToTS	Success		0.002
testTimestamp	Success		0.002
testTimestampToDate	Success		0.002
testTimestampToTime	Success		0.001
testUtilDate	Success		0.006
testCalenderWithUtilDate	Success		0.002
testSqlDateWithCal	Success		0.001
testTimeWithCal	Success		0.002
testTimestampWithCal	Success		0.001
testUtilDateWithCal	Success		0.002
testCalendar	Success		0.001
testTimestampGreaterThan	Success		0.003
testTimestampLessThan	Success		0.004
testTimestampIn	Success		0.009
testTimestampBetween	Success		0.003
testSetup	Success		0.216
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLParameterTestSuite.testSetup(JUnitJPQLParameterTestSuite.java:97) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	6.531
multipleParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLParameterTestSuite.multipleParameterTest(JUnitJPQLParameterTestSuite.java:126) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.010
updateEnumParameter	Success		0.072
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testSetup(JUnitJPQLExamplesTestSuite.java:135) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	12.587
findAllOrders	Failure	Find all orders test failed: data validation error expected:<0> but was:<4>`junit.framework.AssertionFailedError: Find all orders test failed: data validation error expected:<0> but was:<4> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findAllOrders(JUnitJPQLExamplesTestSuite.java:161) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
findEmployeesInOntario	Failure	Find Employees in Ontario test failed: data validation error expected:<0> but was:<9>`junit.framework.AssertionFailedError: Find Employees in Ontario test failed: data validation error expected:<0> but was:<9> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findEmployeesInOntario(JUnitJPQLExamplesTestSuite.java:175) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
findAllProvinceWithEmployees	Failure	Find Province with employees test failed: data validation error expected:<0> but was:<5>`junit.framework.AssertionFailedError: Find Province with employees test failed: data validation error expected:<0> but was:<5> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findAllProvinceWithEmployees(JUnitJPQLExamplesTestSuite.java:200) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
findAllEmployeesWithPhoneNumbers	Failure	Ejbql statements returned different results: data validation error expected:<6> but was:<14>`junit.framework.AssertionFailedError: Ejbql statements returned different results: data validation error expected:<6> but was:<14> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findAllEmployeesWithPhoneNumbers(JUnitJPQLExamplesTestSuite.java:221) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.011
findAllEmployeesWithOutPhoneNumbers	Failure	Find all employees WITHOUT phone numbers test failed: data validation error expected:<68> but was:<1>`junit.framework.AssertionFailedError: Find all employees WITHOUT phone numbers test failed: data validation error expected:<68> but was:<1> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findAllEmployeesWithOutPhoneNumbers(JUnitJPQLExamplesTestSuite.java:240) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.012
findAllEmployeesWithCellPhones	Failure	Find all employees with cellular phone numbers test failed: data validation error expected:<0> but was:<4>`junit.framework.AssertionFailedError: Find all employees with cellular phone numbers test failed: data validation error expected:<0> but was:<4> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findAllEmployeesWithCellPhones(JUnitJPQLExamplesTestSuite.java:260) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
findOrdersWithDifferentBilledCustomer	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findOrdersWithDifferentBilledCustomer(JUnitJPQLExamplesTestSuite.java:281) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
findEmployeeWithWorkPhone2258812	Failure	Find employee with 2258812 number test failed: data validation error expected:<0> but was:<8>`junit.framework.AssertionFailedError: Find employee with 2258812 number test failed: data validation error expected:<0> but was:<8> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.findEmployeeWithWorkPhone2258812(JUnitJPQLExamplesTestSuite.java:300) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
parameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.parameterTest(JUnitJPQLExamplesTestSuite.java:320) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.015
getOrderLargerThan	Failure	Get order larger than test failed: data validation error expected:<0> but was:<1>`junit.framework.AssertionFailedError: Get order larger than test failed: data validation error expected:<0> but was:<1> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.getOrderLargerThan(JUnitJPQLExamplesTestSuite.java:346) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
getSalesPersonForOrders	Failure	Get SalesPerson for Orders test failed: data validation error expected:<0> but was:<2>`junit.framework.AssertionFailedError: Get SalesPerson for Orders test failed: data validation error expected:<0> but was:<2> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.getSalesPersonForOrders(JUnitJPQLExamplesTestSuite.java:380) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
getOrderForCustomer	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.getOrderForCustomer(JUnitJPQLExamplesTestSuite.java:358) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.001
testOuterJoin	Failure	Get SalesPerson for Orders test failed: data validation error expected:<0> but was:<4>`junit.framework.AssertionFailedError: Get SalesPerson for Orders test failed: data validation error expected:<0> but was:<4> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testOuterJoin(JUnitJPQLExamplesTestSuite.java:397) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
testExistsExpression	Failure	Exists Expression test failed: data validation error expected:<12> but was:<8>`junit.framework.AssertionFailedError: Exists Expression test failed: data validation error expected:<12> but was:<8> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testExistsExpression(JUnitJPQLExamplesTestSuite.java:428) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.007
testAllExpressions	Failure	All Expression test failed: data validation error expected:<74> but was:<12>`junit.framework.AssertionFailedError: All Expression test failed: data validation error expected:<74> but was:<12> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testAllExpressions(JUnitJPQLExamplesTestSuite.java:457) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.021
testCountInSubQuery	Failure	Count subquery test failed: data validation error expected:<0> but was:<2>`junit.framework.AssertionFailedError: Count subquery test failed: data validation error expected:<0> but was:<2> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testCountInSubQuery(JUnitJPQLExamplesTestSuite.java:477) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.078
testGroupByHavingExpression	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testGroupByHavingExpression(JUnitJPQLExamplesTestSuite.java:493) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.004
testGroupByHavingCount	Failure	GroupBy Having count expression test failed: data validation error expected:<0> but was:<1>`junit.framework.AssertionFailedError: GroupBy Having count expression test failed: data validation error expected:<0> but was:<1> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testGroupByHavingCount(JUnitJPQLExamplesTestSuite.java:560) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.006
testConstructorQuery	Error	Array index out of range: 0`java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 at java.util.Vector.elementAt(Unknown Source) at java.util.Vector.get(Unknown Source) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testConstructorQuery(JUnitJPQLExamplesTestSuite.java:569) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
testSumExpression	Success		0.003
testAvgExpression	Success		0.002
testOrderByExpression	Failure	OrderBy expression test failed: data validation error expected:<0> but was:<13>`junit.framework.AssertionFailedError: OrderBy expression test failed: data validation error expected:<0> but was:<13> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testOrderByExpression(JUnitJPQLExamplesTestSuite.java:637) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
testCountInSubQuery	Failure	Count subquery test failed: data validation error expected:<0> but was:<2>`junit.framework.AssertionFailedError: Count subquery test failed: data validation error expected:<0> but was:<2> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testCountInSubQuery(JUnitJPQLExamplesTestSuite.java:477) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.003
testOrderByExpressionWithSelect	Failure	OrderBy expression test failed: data validation error expected:<0> but was:<13>`junit.framework.AssertionFailedError: OrderBy expression test failed: data validation error expected:<0> but was:<13> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testOrderByExpressionWithSelect(JUnitJPQLExamplesTestSuite.java:670) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
testDeleteExpression	Failure	Delete Expression test failed: customer to delete not found expected:<1> but was:<0>`junit.framework.AssertionFailedError: Delete Expression test failed: customer to delete not found expected:<1> but was:<0> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testDeleteExpression(JUnitJPQLExamplesTestSuite.java:684) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.029
testComplexDeleteExpression	Failure	Complex Delete Expression test failed: customer to delete not found expected:<1> but was:<0>`junit.framework.AssertionFailedError: Complex Delete Expression test failed: customer to delete not found expected:<1> but was:<0> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testComplexDeleteExpression(JUnitJPQLExamplesTestSuite.java:714) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.043
updateAllTest	Error	getSingleResult() did not retrieve any entities.javax.persistence.NoResultException: getSingleResult() did not retrieve any entities. at org.eclipse.persistence.internal.jpa.EJBQueryImpl.throwNoResultException(EJBQueryImpl.java:945) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:552) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.updateAllTest(JUnitJPQLExamplesTestSuite.java:762) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)	0.004
namedQueryCloneTest	Failure	Named query clone test failed: the first result should be 4 expected:<1> but was:<4>`junit.framework.AssertionFailedError: Named query clone test failed: the first result should be 4 expected:<1> but was:<4> at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.namedQueryCloneTest(JUnitJPQLExamplesTestSuite.java:806) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
aggregateParameterTest	Error	N/A`java.lang.NullPointerException at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.aggregateParameterTest(JUnitJPQLExamplesTestSuite.java:839) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.005
testEJBQLQueryString	Failure	No employees were read, debug and look at the SQL that was generated. `junit.framework.AssertionFailedError: No employees were read, debug and look at the SQL that was generated. at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLExamplesTestSuite.testEJBQLQueryString(JUnitJPQLExamplesTestSuite.java:701) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.002
updateEmbeddedFieldTest	Success		0.060
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.640
simpleUpdate	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.569
updateWithSubquery	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.730
updateEmbedded	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.822
updateEmbeddedFieldTest	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	5.974
updateUnqualifiedAttributeInSet	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.690
updateUnqualifiedAttributeInWhere	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.965
updateDateTimeFields	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.953
simpleDelete	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.790
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	5.197
simpleUpdate	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.574
updateWithSubquery	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	4.926
updateEmbedded	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.872
updateEmbeddedFieldTest	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.436
updateUnqualifiedAttributeInSet	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.330
updateUnqualifiedAttributeInWhere	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.674
updateDateTimeFields	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.596
simpleDelete	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLModifyTestSuite.setUp(JUnitJPQLModifyTestSuite.java:66) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.923
testSetup	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, DEPT_ID BIGINT, STATUS BIGINT, PAY_SCALE VARCHAR(40), ROOM_NUM BIGINT, FORMER_COMPANY VARCHAR(40), FORMER_START_DATE DATE, FORMER_END_DATE DATE, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testSetup(AdvancedQueryTestSuite.java:97) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	3.752
testQueryCacheFirstCacheHits	Success		0.028
testQueryCacheOnlyCacheHits	Success		0.014
testQueryCacheOnlyCacheHitsOnSession	Success		0.018
testQueryPrimaryKeyCacheHits	Success		0.015
testQueryExactPrimaryKeyCacheHits	Success		0.014
testQueryTypeCacheHits	Success		0.014
unknown	Error	Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_XML_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_XML_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), SIN VARCHAR(10), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery()Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_XML_EMPLOYEE' already exists Error Code: 1050 Call: CREATE TABLE CMP3_XML_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME VARCHAR(40), L_NAME VARCHAR(40), SIN VARCHAR(10), GENDER VARCHAR(1), START_DATE DATE, END_DATE DATE, START_TIME TIME, END_TIME TIME, START_OVERTIME TIME, END_OVERTIME TIME, ADDR_ID BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, PRIMARY KEY (EMP_ID)) Query: DataModifyQuery() at java.lang.Throwable.(Throwable.java:67) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:47) at org.eclipse.persistence.exceptions.EclipseLinkException.(EclipseLinkException.java:57) at org.eclipse.persistence.exceptions.DatabaseException.(DatabaseException.java:66) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:757) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:823) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:557) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:233) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:213) at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:66) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:877) at org.eclipse.persistence.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase(DatabaseObjectDefinition.java:81) at org.eclipse.persistence.tools.schemaframework.SchemaManager.createObject(SchemaManager.java:187) at org.eclipse.persistence.tools.schemaframework.SchemaManager.replaceObject(SchemaManager.java:882) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:297) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248) at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240) at org.eclipse.persistence.testing.tests.jpa.xml.advanced.EntityMappingsAdvancedJUnitTestCase$1.setUp(EntityMappingsAdvancedJUnitTestCase.java:122) at junit.extensions.TestSetup$1.protect(TestSetup.java:20) at junit.extensions.TestSetup.run(TestSetup.java:25) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'CMP3_XML_EMPLOYEE' already exists at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:748)	0.000
testCreateCustomer	Success		0.032
testCreateItem	Success		0.011
testCreateOrder	Success		0.015
testReadCustomer	Success		0.001
testReadItem	Success		0.001
testReadOrder	Success		0.002
testNamedQueryOnCustomer	Success		0.002
testNamedQueryOnItem	Success		0.002
testNamedQueryOnOrder	Success		0.002
testUpdateCustomer	Success		0.013
testUpdateItem	Success		0.019
testUpdateOrder	Success		0.015
testDeleteOrder	Success		0.012
testDeleteCustomer	Success		0.016
testDeleteItem	Success		0.016
testUnidirectionalOneToOneCreate	Success		0.034
testUnidirectionalOneToOneRead	Success		0.001
testUnidirectionalOneToOneDeleteNonowning	Success		0.015
testUnidirectionalOneToOneDeleteOwning	Success		0.007
testUnidirectionalOneToManyCreate	Success		0.019
testUnidirectionalOneToManyRead	Success		0.001
testUnidirectionalOneToManyDeleteNonowning	Success		0.012
testUnidirectionalOneToManyDeleteOwning	Success		0.019
testUnidirectionalManyToOneCreate	Success		0.028
testUnidirectionalManyToOneRead	Success		0.001
testUnidirectionalManyToOneDeleteNonowning	Success		0.015
testUnidirectionalManyToOneDeleteOwning	Success		0.012
testUnidirectionalManyToManyCreate	Success		0.019
testUnidirectionalManyToManyRead	Success		0.001
testUnidirectionalManyToManyDeleteNonowning	Success		0.011
testUnidirectionalManyToManyDeleteOwning	Success		0.016
testCreateFueledVehicle	Success		0.023
testCreateBusFueledVehicle	Success		0.011
testCreateNonFueledVehicle	Success		0.061
testReadFueledVehicle	Success		0.001
testReadNonFueledVehicle	Success		0.001
testNamedNativeQueryOnSportsCar	Success		0.001
testUpdateBusFueledVehicle	Success		0.015
testUpdateFueledVehicle	Success		0.010
testUpdateNonFueledVehicle	Success		0.012
testDeleteBusFueledVehicle	Success		0.012
testDeleteFueledVehicle	Success		0.012
testDeleteNonFueledVehicle	Success		0.012
testOneToManyRelationships	Success		0.016
testVerifyOneToManyRelationships	Success		0.007
testCreateBeerConsumer	Success		0.040
testReadBeerConsumer	Success		0.001
testNamedNativeQueryBeerConsumers	Success		0.007
testNamedNativeQueryCertifications	Success		0.004
testUpdateBeerConsumer	Success		0.018
testDeleteBeerConsumer	Success		0.020
testInheritanceDiscriminatorFieldValue	Success		0.000
testMappingsTypes	Success		0.000
testCustomerOrdersMapping	Success		0.001
testOrderCustomerMapping	Success		0.000
testItemNameMapping	Success		0.001
testCreateCustomer	Success		0.012
testCreateItem	Success		0.024
testCreateOrder	Success		0.011
testReadCustomer	Success		0.000
testReadItem	Success		0.001
testReadOrder	Success		0.000
testNamedQueryOnCustomer	Success		0.002
testNamedQueryOnItem	Success		0.001
testNamedQueryOnOrder	Success		0.001
testUpdateCustomer	Success		0.013
testUpdateItem	Success		0.024
testUpdateOrder	Success		0.016
testDeleteOrder	Success		0.022
testDeleteCustomer	Success		0.012
testDeleteItem	Success		0.012
testCreateCustomer	Success		0.016
testCreateItem	Success		0.015
testCreateOrder	Success		0.011
testReadCustomer	Success		0.001
testReadItem	Success		0.001
testReadOrder	Success		0.001
testUpdateCustomer	Success		0.010
testUpdateItem	Success		0.031
testUpdateOrder	Success		0.011
testDeleteOrder	Success		0.014
testDeleteCustomer	Success		0.012
testDeleteItem	Success		0.012
testCreateEmployee	Success		0.052
testReadEmployee	Success		0.001
testUpdateEmployee	Success		0.012
testDeleteEmployee	Success		0.012
testOneToManyRelationships	Success		7.784
testVerifyOneToManyRelationships	Success		0.008
testCreateBeerConsumer	Success		0.036
testReadBeerConsumer	Success		0.001
testNamedNativeQueryBeerConsumers	Success		0.010
testNamedNativeQueryCertifications	Success		0.004
testMappedSuperclassTransientField	Success		0.001
testTransientField	Success		0.001
testUpdateBeerConsumer	Success		0.012
testDeleteBeerConsumer	Success		0.032
testBeerLifeCycleMethodAnnotationIgnored	Success		0.011
testMappedSuperclassEntityListener	Success		0.007
testMappedSuperclassEmbeddedXMLElement	Success		0.000
testSetup	Success		0.000
testDDLPkConstraintErrorIncludingRelationTableColumnName	Success		0.018
testDDLUniqueKeysAsJoinColumns	Success		0.013
testDDLUniqueConstraintsByAnnotations	Success		0.041
testDDLUniqueConstraintsByXML	Success		0.039
testDDLSubclassEmbeddedIdPkColumnsInJoinedStrategy	Success		0.019
testBug241308	Success		0.007
testSetup	Success		2.530
testSessionXMLProperty	Error	java.util.ArrayList incompatible with java.util.Vector`java.lang.ClassCastException: java.util.ArrayList incompatible with java.util.Vector at org.eclipse.persistence.testing.tests.jpa.jpaadvancedproperties.JPAAdvPropertiesJUnitTestCase.testSessionXMLProperty(JPAAdvPropertiesJUnitTestCase.java:262) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)`	0.183
testSessionEventListenerProperty	Success		0.022
testExceptionHandlerProperty	Error	Exception Description: Missing descriptor for [class org.eclipse.persistence.testing.models.jpa.jpaadvancedproperties.Customer]. Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.jpaadvancedproperties.Customer)Local Exception Stack: Exception [EclipseLink-6007] (Eclipse Persistence Services - 1.0.2 (Build SNAPSHOT-20081015)): org.eclipse.persistence.exceptions.QueryException Exception Description: Missing descriptor for [class org.eclipse.persistence.testing.models.jpa.jpaadvancedproperties.Customer]. Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.jpaadvancedproperties.Customer) at org.eclipse.persistence.exceptions.QueryException.descriptorIsMissing(QueryException.java:417) at org.eclipse.persistence.queries.ReadObjectQuery.checkDescriptor(ReadObjectQuery.java:218) at org.eclipse.persistence.queries.ObjectLevelReadQuery.prePrepare(ObjectLevelReadQuery.java:1642) at org.eclipse.persistence.queries.ReadObjectQuery.prePrepare(ReadObjectQuery.java:673) at org.eclipse.persistence.queries.ObjectLevelReadQuery.checkPrePrepare(ObjectLevelReadQuery.java:632) at org.eclipse.persistence.queries.ObjectLevelReadQuery.checkEarlyReturn(ObjectLevelReadQuery.java:567) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:615) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840) at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:398) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2207) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1108) at org.eclipse.persistence.internal.sessions.AbstractSession.readObject(AbstractSession.java:2609) at org.eclipse.persistence.testing.tests.jpa.jpaadvancedproperties.JPAAdvPropertiesJUnitTestCase.testExceptionHandlerProperty(JPAAdvPropertiesJUnitTestCase.java:139) at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)	0.001
testNativeSQLProperty	Success		0.000
testCacheStatementsAndItsSizeProperty	Success		0.000
testBatchwritingProperty	Success		0.000
testCopyDescriptorNamedQueryToSessionProperty	Success		0.000
testLoggingTyperProperty	Success		0.000
testProfilerTyperProperty	Success		0.883
testSetup	Success		1.342
testCreateWrapperTypes	Success		0.040
testNullifyBigDecimal	Success		0.025
testNullifyBigInteger	Success		0.011
testNullifyBoolean	Success		0.025
testNullifyByte	Success		0.010
testNullifyCharacter	Success		0.011
testNullifyShort	Success		0.012
testNullifyInteger	Success		0.011
testNullifyLong	Success		0.012
testNullifyFloat	Success		0.012
testNullifyDouble	Success		0.013
testNullifyString	Success		0.015
testCreateByteArrayType	Success		0.025
testCreatePrimitiveByteArrayType	Success		0.027
testCreateCharacterArrayType	Success		0.023
testCreateCharArrayType	Success		0.024
testPrimitiveByteArrayPK	Success		0.000
testSetup	Success		0.193
testCreateDateTime	Success		0.016
testNullifySqlDate	Success		0.010
testNullifyTime	Success		0.012
testNullifyTimestamp	Success		0.018
testNullifyUtilDate	Success		0.011
testNullifyCalendar	Success		0.011
testSetup	Success		0.340
testCreate	Success		0.039
testRead	Success		0.012
testUpdate	Success		0.025
testDelete	Success		0.031

Properties »