| Name | Status | Type | Time(s) |
| testNamedNativeQuery | Success | | 0.012 |
| testPersistThenRemoveCalls | Success | | 0.120 |
| testRemoveUnmanagedNewEntity | Success | | 0.051 |
| testPersistOnRegisteredObject | Success | | 0.040 |
| testPreUpdateEvent_UpdateAltered | Success | | 0.079 |
| testPreUpdateEvent_UpdateReverted | Success | | 0.055 |
| testMergeCascadeTriggersPrePersist | Success | | 0.043 |
| testSetup | Success | | 7.767 |
| testWeaving | Success | | 0.002 |
| testClearEntityManagerWithoutPersistenceContext | Success | | 0.001 |
| testUpdateAllProjects | Success | | 0.104 |
| testUpdateUsingTempStorage | Success | | 0.180 |
| testSequenceObjectDefinition | Success | | 0.001 |
| testFindDeleteAllPersist | Success | | 0.114 |
| testExtendedPersistenceContext | Success | | 0.178 |
| testRemoveFlushFind | Success | | 0.033 |
| testRemoveFlushPersistContains | Success | | 0.055 |
| testTransactionRequired | Success | | 0.005 |
| testSubString | Success | | 0.035 |
| testFlushModeOnUpdateQuery | Success | | 0.052 |
| testContainsRemoved | Success | | 0.027 |
| testRefreshRemoved | Success | | 0.031 |
| testRefreshNotManaged | Success | | 0.001 |
| testDoubleMerge | Success | | 0.014 |
| testDescriptorNamedQueryForMultipleQueries | Success | | 0.011 |
| testDescriptorNamedQuery | Success | | 0.028 |
| testClearEntityManagerWithoutPersistenceContextSimulateJTA | Success | | 0.004 |
| testMultipleEntityManagerFactories | Success | | 5.066 |
| testOneToManyDefaultJoinTableName | Success | | 0.249 |
| testClosedEmShouldThrowException | Success | | 0.001 |
| testRollbackOnlyOnException | Success | | 0.001 |
| testUpdateAllProjectsWithNullTeamLeader | Success | | 0.118 |
| testUpdateAllLargeProjectsWithNullTeamLeader | Success | | 0.112 |
| testUpdateAllSmallProjectsWithNullTeamLeader | Success | | 0.092 |
| testUpdateAllProjectsWithName | Success | | 0.052 |
| testUpdateAllLargeProjectsWithName | Success | | 0.059 |
| testUpdateAllSmallProjectsWithName | Success | | 0.063 |
| testUpdateAllLargeProjects | Success | | 0.051 |
| testUpdateAllSmallProjects | Success | | 0.224 |
| testUpdateUsingTempStorageWithParameter | Success | | 0.264 |
| testDeleteAllLargeProjectsWithNullTeamLeader | Success | | 0.086 |
| testDeleteAllSmallProjectsWithNullTeamLeader | Success | | 0.036 |
| testDeleteAllProjectsWithNullTeamLeader | Success | | 0.047 |
| testDeleteAllPhonesWithNullOwner | Success | | 0.003 |
| testSetFieldForPropertyAccessWithNewEM | Success | | 0.092 |
| testSetFieldForPropertyAccessWithRefresh | Success | | 0.095 |
| testSetFieldForPropertyAccess | Success | | 0.092 |
| testInitializeFieldForPropertyAccess | Success | | 0.040 |
| testCascadePersistToNonEntitySubclass | Success | | 0.017 |
| testCascadeMergeManaged | Success | | 0.047 |
| testCascadeMergeDetached | Success | | 0.035 |
| testPrimaryKeyUpdatePKFK | Success | | 0.020 |
| testPrimaryKeyUpdateSameValue | Success | | 0.010 |
| testPrimaryKeyUpdate | Success | | 0.014 |
| testRemoveNull | Success | | 0.001 |
| testContainsNull | Success | | 0.001 |
| testPersistNull | Success | | 0.001 |
| testMergeNull | Success | | 0.000 |
| testMergeRemovedObject | Success | | 0.020 |
| testMergeDetachedObject | Success | | 0.027 |
| testSerializedLazy | Success | | 0.148 |
| testCloneable | Success | | 0.043 |
| testLeftJoinOneToOneQuery | Success | | 0.007 |
| testNullifyAddressIn | Success | | 0.008 |
| testQueryOnClosedEM | Success | | 0.002 |
| testIncorrectBatchQueryHint | Success | | 0.004 |
| testFetchQueryHint | Success | | 0.088 |
| testBatchQueryHint | Success | | 0.079 |
| testQueryHints | Success | | 0.003 |
| testParallelMultipleFactories | Success | | 0.002 |
| testMultipleFactories | Success | | 4.980 |
| testPersistenceProperties | Success | | 0.001 |
| testBeginTransactionCloseCommitTransaction | Success | | 0.085 |
| testBeginTransactionClose | Success | | 0.001 |
| testClose | Success | | 0.000 |
| testPersistOnNonEntity | Success | | 0.000 |
| testWRITELock | Success | | 0.058 |
| testOPTIMISTIC_FORCE_INCREMENTLock | Success | | 0.028 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush | Success | | 0.080 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh | Success | | 0.040 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush | Success | | 0.044 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll | Success | | 0.035 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush | Success | | 0.048 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh | Success | | 0.040 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush | Success | | 0.043 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate | Success | | 0.044 |
| testReadTransactionIsolation_UpdateAll_Refresh_Flush | Success | | 0.056 |
| testReadTransactionIsolation_UpdateAll_Refresh | Success | | 0.059 |
| testReadTransactionIsolation_UpdateAll_Flush | Success | | 0.092 |
| testReadTransactionIsolation_UpdateAll | Success | | 0.035 |
| testReadTransactionIsolation_CustomUpdate_Refresh_Flush | Success | | 0.065 |
| testReadTransactionIsolation_CustomUpdate_Refresh | Success | | 0.043 |
| testReadTransactionIsolation_CustomUpdate_Flush | Success | | 0.062 |
| testReadTransactionIsolation_CustomUpdate | Success | | 0.035 |
| testClearInTransaction | Success | | 0.038 |
| testClearWithFlush | Success | | 0.061 |
| testClear | Success | | 0.016 |
| testCheckVersionOnMerge | Success | | 0.016 |
| testFindWithNullPk | Success | | 0.000 |
| testFindWithWrongTypePk | Success | | 0.000 |
| testPersistManagedNoException | Success | | 0.018 |
| testPersistManagedException | Success | | 0.007 |
| testPersistRemoved | Success | | 0.856 |
| testREADLock | Success | | 0.043 |
| testOPTIMISTICLock | Success | | 0.056 |
| testPESSIMISTICLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT ID, NAME FROM CMP3_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT bind => [9201] Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Department)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT ID, NAME FROM CMP3_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
bind => [9201]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Department)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:596)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.lock(EntityManagerImpl.java:1179)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.lock(EntityManagerImpl.java:1147)
at org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTICLock(EntityManagerJUnitTestSuite.java:1313)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT ID, NAME FROM CMP3_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
bind => [9201]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Department)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:619)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2549)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2519)
at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:425)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:398)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1120)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:574)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.034 |
| testPESSIMISTIC_FORCE_INCREMENTLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.MANAGER_EMP_ID, t1.DEPT_ID, t1.ADDR_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((t1.EMP_ID = ?) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT bind => [39001] Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.MANAGER_EMP_ID, t1.DEPT_ID, t1.ADDR_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((t1.EMP_ID = ?) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [39001]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:596)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:491)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:406)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:357)
at org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_FORCE_INCREMENTLock(EntityManagerJUnitTestSuite.java:1374)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.MANAGER_EMP_ID, t1.DEPT_ID, t1.ADDR_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((t1.EMP_ID = ?) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [39001]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:619)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2549)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2519)
at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:425)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:398)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1120)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:574)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.022 |
| testPESSIMISTIC_TIMEOUTLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.MANAGER_EMP_ID, t1.DEPT_ID, t1.ADDR_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((t1.EMP_ID = ?) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT bind => [41] Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.MANAGER_EMP_ID, t1.DEPT_ID, t1.ADDR_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((t1.EMP_ID = ?) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [41]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:596)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.findInternal(EntityManagerImpl.java:491)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:406)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.find(EntityManagerImpl.java:357)
at org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_TIMEOUTLock(EntityManagerJUnitTestSuite.java:1400)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.MANAGER_EMP_ID, t1.DEPT_ID, t1.ADDR_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE ((t1.EMP_ID = ?) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [41]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:619)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2549)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2519)
at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:425)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:398)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1120)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:574)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.035 |
| testRefreshOPTIMISTICLock | Success | | 0.031 |
| testRefreshPESSIMISTICLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT ID, NAME FROM CMP3_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT bind => [9202] Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Department)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT ID, NAME FROM CMP3_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
bind => [9202]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Department)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:596)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.lock(EntityManagerImpl.java:1179)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.lock(EntityManagerImpl.java:1147)
at org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testRefreshPESSIMISTICLock(EntityManagerJUnitTestSuite.java:438)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT ID, NAME FROM CMP3_DEPT WHERE (ID = ?) FOR UPDATE NOWAIT
bind => [9202]
Query: ReadObjectQuery(org.eclipse.persistence.testing.models.jpa.advanced.Department)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:619)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2549)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2519)
at org.eclipse.persistence.queries.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:425)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadObjectQuery.execute(ReadObjectQuery.java:398)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1120)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.executeQuery(EntityManagerImpl.java:574)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.024 |
| testIgnoreRemovedObjectsOnDatabaseSync | Success | | 0.061 |
| testIdentityOutsideTransaction | Success | | 0.014 |
| testIdentityInsideTransaction | Success | | 0.002 |
| testDatabaseSyncNewObject | Success | | 0.001 |
| testSetRollbackOnly | Success | | 0.053 |
| testFlushModeEmCommitQueryAuto | Success | | 0.016 |
| testFlushModeEmCommit | Success | | 0.006 |
| testFlushModeEmCommitQueryCommit | Success | | 0.006 |
| testFlushModeEmAutoQueryAuto | Success | | 0.011 |
| testFlushModeEmAuto | Success | | 0.012 |
| testFlushModeEmAutoQueryCommit | Success | | 0.006 |
| testCacheUsage | Success | | 0.058 |
| testSequencePreallocationUsingCallbackTest | Success | | 0.028 |
| testForceSQLExceptionFor219097 | Success | | 0.005 |
| testRefreshInvalidateDeletedObject | Success | | 0.015 |
| testClearWithFlush2 | Success | | 0.171 |
| testEMFWrapValidationException | Success | | 0.165 |
| testEMDefaultTxType | Success | | 0.782 |
| testMergeNewObject | Success | | 0.002 |
| testMergeNewObject2 | Success | | 0.028 |
| testMergeNewObject3_UseSequencing | Success | | 0.002 |
| testMergeNewObject3_DontUseSequencing | Success | | 0.028 |
| testCreateEntityManagerFactory | Success | | 0.002 |
| testCreateEntityManagerFactory2 | Success | | 1.018 |
| testPessimisticLockHintStartsTransaction | Success | | 0.007 |
| testManyToOnePersistCascadeOnFlush | Success | | 0.034 |
| testDiscoverNewReferencedObject | Success | | 0.038 |
| testBulkDeleteThenMerge | Success | | 0.053 |
| testNativeSequences | Success | | 0.000 |
| testGetReference | Success | | 0.014 |
| testGetReferenceUpdate | Success | | 0.030 |
| testGetReferenceUsedInUpdate | Success | | 0.029 |
| testBadGetReference | Success | | 0.003 |
| testClassInstanceConverter | Success | | 0.021 |
| test210280EntityManagerFromPUwithSpaceInNameButNotInPath | Success | | 0.151 |
| test210280EntityManagerFromPUwithSpaceInPathButNotInName | Success | | 0.215 |
| test210280EntityManagerFromPUwithSpaceInNameAndPath | Success | | 0.153 |
| testNewObjectNotCascadePersist | Success | | 0.001 |
| testConnectionPolicy | Success | | 0.006 |
| testConverterIn | Success | | 0.066 |
| testExceptionForPersistNonEntitySubclass | Success | | 0.000 |
| testEnabledPersistNonEntitySubclass | Success | | 0.000 |
| testCloneEmbeddable | Success | | 0.000 |
| testCloseOnCommit | Success | | 0.132 |
| testPersistOnCommit | Success | | 0.060 |
| testFlushMode | Success | | 0.004 |
| testEmbeddedNPE | Success | | 0.982 |
| testInheritanceNoDiscriminatorColumn | Success | | 0.010 |
| testComplicateResultWithInheritance | Success | | 0.040 |
| testRefresh | Success | | 0.075 |
| testBindParameters | Success | | 0.005 |
| testBindParametersWithPostitional | Success | | 0.004 |
| testSimpleInheritance | Success | | 0.015 |
| testPessimisticLocking | Success | | 0.011 |
| testComplicateResults | Success | | 0.006 |
| testProjectJoinTeamMembers | Success | | 0.331 |
| testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull | Success | | 0.230 |
| testProjectJoinTeamMembersJoinAddress | Success | | 0.141 |
| testProjectOuterJoinTeamMembersJoinAddress | Success | | 0.138 |
| testProjectOuterJoinTeamMembersOuterJoinAddress | Success | | 0.138 |
| testProjectJoinTeamMembersOuterJoinAddress | Success | | 0.121 |
| testProblemReporterProjectJoinTeamMembersJoinAddress | Success | | 0.149 |
| testEmployeeJoinProjects | Success | | 0.120 |
| testEmployeeJoinProjectsOnUOW | Success | | 0.113 |
| testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull | Success | | 0.089 |
| testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName | Success | | 0.101 |
| testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones | Success | | 0.185 |
| testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhonesOnUOW | Success | | 0.272 |
| testEmployeeJoinManagerAddressOuterJoinManagerAddress | Success | | 0.101 |
| testTwoUnrelatedResultWithOneToManyJoins | Success | | 0.138 |
| testMultipleUnrelatedResultWithOneToManyJoins | Success | | 0.312 |
| testTwoUnrelatedResultWithOneToOneJoins | Success | | 0.333 |
| testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem | Success | | 0.275 |
| testSimpleReturnDirectToField | Success | | 0.002 |
| testSimpleReturnObject | Success | | 0.071 |
| testReturnObjectAndDirectToField | Success | | 0.008 |
| testReturnUnrelatedObjectAndDirectToField | Success | | 0.019 |
| testInheritanceMultiTableException | Success | | 0.003 |
| testReturnRootObject | Success | | 0.009 |
| testPhoneCountGroupByOwner | Success | | 0.195 |
| testPhoneCountGroupByOwnersAddress | Success | | 0.177 |
| testProjectCountGroupByTeamMembers | Success | | 0.068 |
| testProjectCountGroupByTeamMemberAddress | Success | | 0.083 |
| testProjectCountGroupByTeamMemberPhone | Success | | 0.071 |
| testExtendedPersistenceContext | Success | | 0.006 |
| testSimpleConstructorExpression | Success | | 0.007 |
| testSimpleConstructorExpressionWithNamedQuery | Success | | 0.003 |
| testMultipleTypeConstructorExpression | Success | | 0.005 |
| testNonExistantConstructorConstructorExpression | Success | | 0.001 |
| testPrimitiveConstructorExpression | Success | | 0.005 |
| testConstructorEJBQLWithInheritance | Success | | 0.002 |
| testConstructorExpressionWithOtherAttributes | Success | | 0.005 |
| testCreateProjects | Success | | 0.014 |
| testCreateEmployeeWithFlush | Success | | 0.020 |
| testVersionUpdateWithCorrectValue | Success | | 0.024 |
| testVersionUpdateWithIncorrectValue | Success | | 0.014 |
| testVersionUpdateWithNullValue | Success | | 0.015 |
| testExistenceCheckingSetting | Success | | 0.001 |
| testJoinFetchAnnotation | Success | | 0.001 |
| testVerifyEmployeeCacheSettings | Success | | 0.853 |
| testVerifyEmployeeCustomizerSettings | Success | | 0.000 |
| testUpdateEmployee | Success | | 0.042 |
| testVerifyUpdatedEmployee | Success | | 0.006 |
| testCreateNewBuyer | Success | | 0.033 |
| testVerifyNewBuyer | Success | | 0.009 |
| testBuyerOptimisticLocking | Success | | 0.033 |
| testGiveFredASexChange | Success | | 0.015 |
| testUpdatePenelopesPhoneNumberStatus | Success | | 0.017 |
| testRemoveJillWithPrivateOwnedPhoneNumbers | Success | | 0.048 |
| testCreateNewEquipment | Success | | 0.012 |
| testAddNewEquipmentToDepartment | Success | | 0.013 |
| testRemoveDepartmentWithPrivateOwnedEquipment | Success | | 0.020 |
| testUpdateReadOnlyEquipmentCode | Success | | 0.002 |
| testNamedStoredProcedureQuery | Success | | 0.363 |
| testNamedStoredProcedureQueryInOut | Success | | 0.188 |
| testMethodBasedTransformationMapping | Success | | 0.038 |
| testClassBasedTransformationMapping | Success | | 0.028 |
| testProperty | Success | | 0.002 |
| testBackpointerOnMerge | Success | | 0.030 |
| testUnidirectionalPersist | Success | | 0.096 |
| testUnidirectionalUpdate | Success | | 0.155 |
| testUnidirectionalFetchJoin | Success | | 0.067 |
| testUnidirectionalTargetLocking_AddRemoveTarget | Success | | 0.083 |
| testUnidirectionalTargetLocking_DeleteSource | Success | | 0.083 |
| testGF1818 | Success | | 0.013 |
| testGF1894 | Success | | 0.012 |
| testGF894 | Success | | 0.015 |
| testManAndWoman | Success | | 0.016 |
| testStringArrayField | Success | | 0.016 |
| testCreateDepartment | Success | | 0.017 |
| testCreateScientists | Success | | 0.064 |
| testReadDepartment | Success | | 0.012 |
| testReadJuniorScientist | Success | | 0.011 |
| testAnyAndAll | Success | | 0.034 |
| testNamedNativeQuery | Success | | 0.001 |
| testPersistThenRemoveCalls | Success | | 0.042 |
| testRemoveUnmanagedNewEntity | Success | | 0.028 |
| testPersistOnRegisteredObject | Success | | 0.020 |
| testPreUpdateEvent_UpdateAltered | Success | | 0.028 |
| testPreUpdateEvent_UpdateReverted | Success | | 0.032 |
| testSetup | Success | | 7.411 |
| testWeaving | Success | | 0.001 |
| testClearEntityManagerWithoutPersistenceContext | Success | | 0.000 |
| testUpdateAllProjects | Success | | 0.076 |
| testUpdateUsingTempStorage | Success | | 0.116 |
| testSequenceObjectDefinition | Success | | 0.000 |
| testFindDeleteAllPersist | Success | | 0.071 |
| testExtendedPersistenceContext | Success | | 0.101 |
| testRemoveFlushFind | Success | | 0.022 |
| testRemoveFlushPersistContains | Success | | 0.035 |
| testTransactionRequired | Success | | 0.001 |
| testSubString | Success | | 0.023 |
| testFlushModeOnUpdateQuery | Success | | 0.031 |
| testContainsRemoved | Success | | 0.015 |
| testRefreshRemoved | Success | | 0.020 |
| testRefreshNotManaged | Success | | 0.001 |
| testDoubleMerge | Success | | 0.007 |
| testDescriptorNamedQueryForMultipleQueries | Success | | 0.016 |
| testDescriptorNamedQuery | Success | | 0.008 |
| testClearEntityManagerWithoutPersistenceContextSimulateJTA | Success | | 0.002 |
| testMultipleEntityManagerFactories | Success | | 2.976 |
| testOneToManyDefaultJoinTableName | Success | | 0.030 |
| testClosedEmShouldThrowException | Success | | 0.001 |
| testRollbackOnlyOnException | Success | | 0.001 |
| testUpdateAllProjectsWithNullTeamLeader | Success | | 0.105 |
| testUpdateAllLargeProjectsWithNullTeamLeader | Success | | 0.072 |
| testUpdateAllSmallProjectsWithNullTeamLeader | Success | | 0.056 |
| testUpdateAllProjectsWithName | Success | | 0.044 |
| testUpdateAllLargeProjectsWithName | Success | | 0.063 |
| testUpdateAllSmallProjectsWithName | Success | | 0.048 |
| testUpdateAllLargeProjects | Success | | 0.077 |
| testUpdateAllSmallProjects | Success | | 0.055 |
| testUpdateUsingTempStorageWithParameter | Success | | 0.075 |
| testDeleteAllLargeProjectsWithNullTeamLeader | Success | | 0.034 |
| testDeleteAllSmallProjectsWithNullTeamLeader | Success | | 0.029 |
| testDeleteAllProjectsWithNullTeamLeader | Success | | 0.060 |
| testDeleteAllPhonesWithNullOwner | Success | | 0.003 |
| testSetFieldForPropertyAccessWithNewEM | Success | | 0.054 |
| testSetFieldForPropertyAccessWithRefresh | Success | | 0.047 |
| testSetFieldForPropertyAccess | Success | | 0.052 |
| testInitializeFieldForPropertyAccess | Success | | 0.032 |
| testCascadePersistToNonEntitySubclass | Success | | 0.011 |
| testCascadeMergeManaged | Success | | 0.035 |
| testCascadeMergeDetached | Success | | 0.027 |
| testPrimaryKeyUpdatePKFK | Success | | 0.017 |
| testPrimaryKeyUpdateSameValue | Success | | 0.009 |
| testPrimaryKeyUpdate | Success | | 0.013 |
| testRemoveNull | Success | | 0.000 |
| testContainsNull | Success | | 0.000 |
| testPersistNull | Success | | 0.001 |
| testMergeNull | Success | | 0.000 |
| testMergeRemovedObject | Success | | 0.023 |
| testMergeDetachedObject | Success | | 0.026 |
| testSerializedLazy | Success | | 0.073 |
| testCloneable | Success | | 0.028 |
| testLeftJoinOneToOneQuery | Success | | 0.003 |
| testNullifyAddressIn | Success | | 0.005 |
| testQueryOnClosedEM | Success | | 0.001 |
| testIncorrectBatchQueryHint | Success | | 0.003 |
| testFetchQueryHint | Success | | 0.055 |
| testBatchQueryHint | Success | | 0.056 |
| testQueryHints | Success | | 0.003 |
| testParallelMultipleFactories | Success | | 0.154 |
| testMultipleFactories | Success | | 0.000 |
| testPersistenceProperties | Success | | 0.001 |
| testBeginTransactionCloseCommitTransaction | Success | | 0.033 |
| testBeginTransactionClose | Success | | 0.000 |
| testClose | Success | | 0.000 |
| testPersistOnNonEntity | Success | | 0.001 |
| testWRITELock | Success | | 0.038 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush | Success | | 0.064 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh | Success | | 0.043 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush | Success | | 0.116 |
| testReadTransactionIsolation_OriginalInCache_UpdateAll | Success | | 0.036 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush | Success | | 0.048 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh | Success | | 0.036 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush | Success | | 0.036 |
| testReadTransactionIsolation_OriginalInCache_CustomUpdate | Success | | 0.044 |
| testReadTransactionIsolation_UpdateAll_Refresh_Flush | Success | | 0.052 |
| testReadTransactionIsolation_UpdateAll_Refresh | Success | | 0.044 |
| testReadTransactionIsolation_UpdateAll_Flush | Success | | 0.052 |
| testReadTransactionIsolation_UpdateAll | Success | | 0.040 |
| testReadTransactionIsolation_CustomUpdate_Refresh_Flush | Success | | 0.052 |
| testReadTransactionIsolation_CustomUpdate_Refresh | Success | | 0.044 |
| testReadTransactionIsolation_CustomUpdate_Flush | Success | | 0.040 |
| testReadTransactionIsolation_CustomUpdate | Success | | 0.048 |
| testClearInTransaction | Success | | 0.018 |
| testClearWithFlush | Success | | 0.026 |
| testClear | Success | | 0.008 |
| testCheckVersionOnMerge | Success | | 0.028 |
| testFindWithNullPk | Success | | 0.001 |
| testFindWithWrongTypePk | Success | | 0.001 |
| testPersistManagedNoException | Success | | 0.054 |
| testPersistManagedException | Success | | 0.035 |
| testPersistRemoved | Success | | 0.508 |
| testREADLock | Success | | 0.028 |
| testIgnoreRemovedObjectsOnDatabaseSync | Success | | 0.036 |
| testIdentityOutsideTransaction | Success | | 0.004 |
| testIdentityInsideTransaction | Success | | 0.001 |
| testDatabaseSyncNewObject | Success | | 0.000 |
| testSetRollbackOnly | Success | | 0.030 |
| testFlushModeEmCommitQueryAuto | Success | | 0.016 |
| testFlushModeEmCommit | Success | | 0.004 |
| testFlushModeEmCommitQueryCommit | Success | | 0.006 |
| testFlushModeEmAutoQueryAuto | Success | | 0.013 |
| testFlushModeEmAuto | Success | | 0.012 |
| testFlushModeEmAutoQueryCommit | Success | | 0.006 |
| testCacheUsage | Success | | 0.022 |
| testSuperclassFieldInSubclass | Success | | 0.024 |
| testCopyingAddress | Success | | 0.001 |
| testSequencePreallocationUsingCallbackTest | Success | | 1.885 |
| testInheritanceNoDiscriminatorColumn | Success | | 0.004 |
| testComplicateResultWithInheritance | Success | | 0.015 |
| testRefresh | Success | | 0.022 |
| testBindParameters | Success | | 0.070 |
| testBindParametersWithPostitional | Success | | 0.002 |
| testSimpleInheritance | Success | | 0.006 |
| testPessimisticLocking | Success | | 0.013 |
| testComplicateResults | Success | | 0.004 |
| testProjectJoinTeamMembers | Success | | 0.180 |
| testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull | Success | | 0.151 |
| testProjectJoinTeamMembersJoinAddress | Success | | 0.087 |
| testProjectOuterJoinTeamMembersJoinAddress | Success | | 0.087 |
| testProjectOuterJoinTeamMembersOuterJoinAddress | Success | | 0.090 |
| testProjectJoinTeamMembersOuterJoinAddress | Success | | 0.086 |
| testProblemReporterProjectJoinTeamMembersJoinAddress | Success | | 0.065 |
| testEmployeeJoinProjects | Success | | 0.142 |
| testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull | Success | | 0.065 |
| testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName | Success | | 0.076 |
| testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones | Success | | 0.151 |
| testEmployeeJoinManagerAddressOuterJoinManagerAddress | Success | | 0.073 |
| testTwoUnrelatedResultWithOneToManyJoins | Success | | 0.122 |
| testMultipleUnrelatedResultWithOneToManyJoins | Success | | 0.276 |
| testTwoUnrelatedResultWithOneToOneJoins | Success | | 0.196 |
| testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem | Success | | 0.222 |
| testSimpleReturnDirectToField | Success | | 0.002 |
| testSimpleReturnObject | Success | | 0.071 |
| testReturnObjectAndDirectToField | Success | | 0.006 |
| testReturnUnrelatedObjectAndDirectToField | Success | | 0.011 |
| testInheritanceMultiTableException | Success | | 0.002 |
| testReturnRootObject | Success | | 0.007 |
| testExtendedPersistenceContext | Success | | 0.007 |
| testSimpleConstructorExpression | Success | | 0.005 |
| testSimpleConstructorExpressionWithNamedQuery | Success | | 0.002 |
| testMultipleTypeConstructorExpression | Success | | 0.005 |
| testNonExistantConstructorConstructorExpression | Success | | 0.000 |
| testPrimitiveConstructorExpression | Success | | 0.004 |
| testConstructorEJBQLWithInheritance | Success | | 0.001 |
| testConstructorExpressionWithOtherAttributes | Success | | 0.003 |
| testCreateProjects | Success | | 0.014 |
| testCreateEmployeeWithFlush | Success | | 0.016 |
| testVersionUpdateWithCorrectValue | Success | | 0.012 |
| testVersionUpdateWithIncorrectValue | Success | | 0.015 |
| testVersionUpdateWithNullValue | Success | | 0.019 |
| testJoinFetchAnnotation | Success | | 0.001 |
| testVerifyEmployeeCustomizerSettings | Success | | 0.000 |
| testUpdateEmployee | Success | | 0.022 |
| testVerifyUpdatedEmployee | Success | | 0.004 |
| testCreateNewBuyer | Success | | 0.017 |
| testVerifyNewBuyer | Success | | 0.005 |
| testBuyerOptimisticLocking | Success | | 0.021 |
| testGiveFredASexChange | Success | | 0.013 |
| testUpdatePenelopesPhoneNumberStatus | Success | | 0.013 |
| testRemoveJillWithPrivateOwnedPhoneNumbers | Success | | 0.024 |
| testCreateNewEquipment | Success | | 0.017 |
| testAddNewEquipmentToDepartment | Success | | 0.012 |
| testRemoveDepartmentWithPrivateOwnedEquipment | Success | | 0.018 |
| testUpdateReadOnlyEquipmentCode | Success | | 0.002 |
| testNamedStoredProcedureQuery | Success | | 0.017 |
| testNamedStoredProcedureQueryInOut | Success | | 0.010 |
| testGF1818 | Success | | 0.011 |
| testGF1894 | Success | | 0.012 |
| testGF894 | Success | | 0.015 |
| testManAndWoman | Success | | 0.011 |
| testStringArrayField | Success | | 0.009 |
| testBUG241388 | Success | | 0.023 |
| selfReferencingManyToManyTest | Success | | 1.697 |
| testManyToManyClearDelete | Success | | 1.754 |
| testLeftTrimWithTrimChar | Success | | 1.713 |
| testLeftTrimWithoutTrimChar | Success | | 1.650 |
| testRightTrimWithTrimChar | Success | | 1.775 |
| testRightTrimWithoutTrimChar | Success | | 1.711 |
| testTrimWithTrimChar | Success | | 1.788 |
| testTrimWithoutTrimChar | Success | | 1.672 |
| testLocateWithSingleArgument | Success | | 1.801 |
| testLocateWithDoubleArgument | Success | | 1.702 |
| testInsertVirtualAttribute | Success | | 0.044 |
| testReadVirtualAttribute | Success | | 0.003 |
| testUpdateVirtualAttribute | Success | | 0.013 |
| testDeleteVirtualAttribute | Success | | 0.013 |
| testSetup | Success | | 1.794 |
| testMarshal | Success | | 0.159 |
| testSetup | Success | | 7.433 |
| testPrePersistBusOverrideAndAbstractInheritAndDefault | Success | | 0.030 |
| testPostPersistBusInheritAndDefault | Success | | 0.013 |
| testPostLoadBusInheritAndDefault | Success | | 0.001 |
| testPrePersistSportsCarInheritAndExcludeDefault | Success | | 0.013 |
| testPostPersistSportsCarInheritAndExcludeDefault | Success | | 0.007 |
| testPrePersistSportsCarOverride | Success | | 0.008 |
| testSetup | Success | | 7.439 |
| test_null | Success | | 0.522 |
| test_nullNonDeferred | Success | | 0.433 |
| test_ownerTOP | Success | | 0.370 |
| test_fuelTypePetrol | Success | | 0.237 |
| test_schoolBusNullDriver | Success | | 0.044 |
| test_ownerOwnsNonFueledVehicle | Success | | 0.187 |
| testSetup | Success | | 7.374 |
| testPersistPolymorphicRelationship | Success | | 0.016 |
| testAssociationWithEmbeddedIdSubclassEntityInJoinedStrategy | Success | | 0.025 |
| testUpateTireInfo | Success | | 0.014 |
| testSetup | Success | | 7.103 |
| testCreateNewMudTire | Success | | 0.022 |
| testCreateNewRockTire | Success | | 0.012 |
| testReadNewMudTire | Success | | 0.002 |
| testReadNewRockTire | Success | | 0.002 |
| testSetup | Success | | 8.179 |
| testVehicleJoinCompany | Success | | 0.065 |
| testVehicleJoinCompanyWherePassengerCapacity | Success | | 0.036 |
| testCompanyJoinVehicles | Success | | 0.026 |
| testCompanyJoinVehiclesWhereNameTOP | Success | | 0.017 |
| testSetup | Success | | 4.259 |
| testInitialize | Success | | 0.054 |
| test1 | Success | | 0.056 |
| testInitialize | Success | | 0.031 |
| test2 | Success | | 0.036 |
| testInitialize | Success | | 0.022 |
| test3 | Success | | 0.044 |
| testInitialize | Success | | 0.166 |
| test1 | Success | | 0.046 |
| testInitialize | Success | | 0.046 |
| test2 | Success | | 0.024 |
| testInitialize | Success | | 0.018 |
| test3 | Success | | 0.034 |
| testSetup | Success | | 3.887 |
| testCreateBlue | Success | | 0.021 |
| testReadBlue | Success | | 0.002 |
| testCreateBeerConsumer | Success | | 0.017 |
| testCreateNoviceBeerConsumer | Success | | 0.019 |
| testCreateExpertBeerConsumer | Success | | 0.011 |
| testReadNoviceBeerConsumer | Success | | 0.006 |
| testReadExpertBeerConsumer | Success | | 0.004 |
| testUpdateBeerConsumer | Success | | 0.021 |
| testInheritedClone | Success | | 0.040 |
| testCascadeRemove | Success | | 0.024 |
| testSetup | Success | | 3.824 |
| testPreAndPostPersistAlpine | Success | | 0.011 |
| testPrePersistAlpineOnMerge | Success | | 0.011 |
| testPreAndPostPersistBeerConsumer | Success | | 0.007 |
| testPostLoadOnFind | Success | | 0.000 |
| testPostLoadOnRefresh | Success | | 0.003 |
| testPreAndPostUpdate | Success | | 0.007 |
| testPreAndPostRemove | Success | | 0.012 |
| testSetup | Success | | 3.711 |
| testExistenceCheckingSetting | Success | | 0.000 |
| testCreateBeerConsumer | Success | | 0.007 |
| testCreateAlpine | Success | | 0.034 |
| testCreateCanadian | Success | | 0.016 |
| testCreateCertifications | Success | | 0.022 |
| testCreateTelephoneNumbers | Success | | 0.025 |
| testReadBeerConsumer | Success | | 0.005 |
| testReadAlpine | Success | | 0.002 |
| testReadCanadian | Success | | 0.005 |
| testInsertNewAlpine | Success | | 0.032 |
| testInsertNewAlpineAndModifyOrderOfExistingAlpines | Success | | 0.034 |
| testUpdateAlpine | Success | | 0.014 |
| testUpdateAlpineThroughBeerConsumer | Success | | 0.028 |
| testUpdateBeerConsumer | Success | | 0.024 |
| testUpdateCanadian | Success | | 0.027 |
| testUpdateCanadianThroughBeerConsumer | Success | | 0.039 |
| testUpdateCertifications | Success | | 0.019 |
| testUpdateTelephoneNumberThroughBeerConsumer | Success | | 0.015 |
| testShuffleTelephoneNumbersOnBeerConsumers | Success | | 0.019 |
| testDeleteAlpine | Success | | 0.012 |
| testDeleteCanadian | Success | | 0.012 |
| testDeleteBeerConsumer | Success | | 0.028 |
| testOptimisticLockingTest | Success | | 0.028 |
| testgetReference | Success | | 3.407 |
| testcreateNativeQuery | Success | | 3.926 |
| testcreateNativeQueryWithSelectSQL | Success | | 3.432 |
| testNativeNamedQuery | Success | | 3.295 |
| testSetParameterUsingNull | Success | | 3.307 |
| testExcludingUnneccesaryJoin | Success | | 3.584 |
| testRemoveUnneccesaryDistinctFromJoin | Success | | 3.438 |
| testLeftTrimWithTrimChar | Success | | 3.297 |
| testLeftTrimWithoutTrimChar | Success | | 3.393 |
| testRightTrimWithTrimChar | Success | | 3.400 |
| testRightTrimWithoutTrimChar | Success | | 3.442 |
| testTrimWithTrimChar | Success | | 3.493 |
| testTrimWithoutTrimChar | Success | | 3.190 |
| testLocateWithSingleArgument | Success | | 3.469 |
| testLocateWithDoubleArgument | Success | | 3.327 |
| testSetup | Success | | 0.403 |
| testInsertVirtualAttribute | Success | | 0.022 |
| testReadVirtualAttribute | Success | | 0.002 |
| testUpdateVirtualAttribute | Success | | 0.006 |
| testDeleteVirtualAttribute | Success | | 0.009 |
| testCacheIsolation_PropertiesDefault_Config | Success | | 0.077 |
| testCacheIsolation_XMLDefault_Config | Success | | 0.214 |
| testJTADatasource_Config_Override | Success | | 0.003 |
| testNonJTADatasource_Config_Override | Success | | 0.260 |
| testPKClassTypeValidation | Success | | 0.001 |
| testParameterNameValidation | Success | | 0.003 |
| testParameterPositionValidation | Success | | 0.001 |
| testParameterPositionValidation2 | Success | | 0.001 |
| selfReferencingManyToManyCreateTest | Success | | 3.527 |
| testManyToManyClearDelete | Success | | 3.647 |
| testSetup | Success | | 3.435 |
| testCreateItem | Success | | 0.025 |
| testModifyItem | Success | | 0.011 |
| testVerifyItem | Success | | 0.002 |
| testInstantiationCopyPolicy | Success | | 0.000 |
| testCopyPolicy | Success | | 0.000 |
| testCloneCopyPolicy | Success | | 0.000 |
| testCollectionImplementation | Success | | 0.008 |
| testSetup | Success | | 7.941 |
| testSelectPhoneNumberAreaCode | Success | | 0.006 |
| testSelectPhoneNumberAreaCodeWithEmployee | Success | | 0.012 |
| testSelectPhoneNumberNumberWithEmployeeWithExplicitJoin | Success | | 0.009 |
| testSelectPhoneNumberNumberWithEmployeeWithFirstNameFirst | Success | | 0.007 |
| testSelectEmployeeWithSameParameterUsedMultipleTimes | Success | | 0.011 |
| testOuterJoinOnOneToOne | Success | | 0.023 |
| testOuterJoinPolymorphic | Success | | 0.011 |
| testFirstResultOnNamedQuery | Success | | 0.003 |
| testInvertedSelectionCriteriaNullPK | Success | | 0.007 |
| testInvertedSelectionCriteriaInvalidQueryKey | Success | | 0.011 |
| testMaxAndFirstResultsOnDataQuery | Success | | 0.004 |
| testMaxAndFirstResultsOnDataQueryWithGroupBy | Success | | 0.004 |
| testDistinctSelectForEmployeeWithNullAddress | Success | | 0.015 |
| testSetup | Success | | 8.018 |
| simpleJoinFetchTest | Success | | 0.275 |
| simpleJoinFetchTest2 | Success | | 0.233 |
| baseTestCase | Success | | 0.081 |
| simpleABSTest | Success | | 0.012 |
| simpleBetweenAndTest | Success | | 0.085 |
| simpleBetweenTest | Success | | 0.079 |
| simpleConcatTest | Success | | 0.012 |
| simpleConcatTestWithParameters | Success | | 0.011 |
| simpleConcatTestWithConstants1 | Success | | 0.012 |
| simpleDistinctTest | Success | | 0.011 |
| simpleDistinctNullTest | Success | | 0.025 |
| simpleDistinctMultipleResultTest | Success | | 0.015 |
| simpleDoubleOrTest | Success | | 0.031 |
| simpleEqualsBracketsTest | Success | | 0.011 |
| simpleEqualsTest | Success | | 0.010 |
| simpleEqualsTestWithJoin | Success | | 0.012 |
| simpleEqualsWithAs | Success | | 0.010 |
| collectionMemberIdentifierEqualsTest | Success | | 0.015 |
| abstractSchemaIdentifierEqualsTest | Success | | 0.012 |
| abstractSchemaIdentifierNotEqualsTest | Success | | 0.081 |
| simpleInOneDotTest | Success | | 0.014 |
| simpleInTest | Success | | 0.011 |
| simpleLengthTest | Success | | 0.014 |
| simpleLikeTest | Success | | 0.011 |
| simpleLikeTestWithParameter | Success | | 0.013 |
| simpleLikeEscapeTestWithParameter | Success | | 0.008 |
| simpleNotBetweenTest | Success | | 0.009 |
| simpleNotEqualsVariablesInteger | Success | | 0.078 |
| simpleNotInTest | Success | | 0.078 |
| simpleNotLikeTest | Success | | 0.147 |
| simpleOrFollowedByAndTest | Success | | 0.014 |
| simpleOrFollowedByAndTestWithStaticNames | Success | | 0.022 |
| simpleOrTest | Success | | 0.016 |
| simpleParameterTest | Success | | 0.012 |
| simpleParameterTestChangingParameters | Success | | 0.018 |
| simpleReverseAbsTest | Success | | 0.011 |
| simpleReverseConcatTest | Success | | 0.011 |
| simpleReverseEqualsTest | Success | | 0.011 |
| simpleReverseLengthTest | Success | | 0.012 |
| simpleReverseParameterTest | Success | | 0.011 |
| simpleReverseSqrtTest | Success | | 0.008 |
| simpleReverseSubstringTest | Success | | 0.010 |
| simpleSqrtTest | Success | | 0.006 |
| simpleSubstringTest | Success | | 0.010 |
| simpleNullTest | Success | | 0.045 |
| simpleNotNullTest | Success | | 0.096 |
| distinctTest | Success | | 0.020 |
| conformResultsInUnitOfWorkTest | Success | | 0.069 |
| simpleModTest | Success | | 0.078 |
| simpleIsEmptyTest | Success | | 0.008 |
| simpleIsNotEmptyTest | Success | | 0.071 |
| simpleApostrohpeTest | Success | | 0.004 |
| simpleEscapeUnderscoreTest | Success | | 0.007 |
| simpleEnumTest | Success | | 0.003 |
| smallProjectMemberOfProjectsTest | Success | | 0.033 |
| smallProjectNOTMemberOfProjectsTest | Success | | 0.050 |
| selectCountOneToOneTest | Success | | 0.033 |
| selectOneToOneTest | Success | | 0.004 |
| selectPhonenumberDeclaredInINClauseTest | Success | | 0.043 |
| selectPhoneUsingALLTest | Success | | 0.024 |
| selectSimpleMemberOfWithParameterTest | Success | | 0.020 |
| selectSimpleNotMemberOfWithParameterTest | Success | | 0.157 |
| selectSimpleBetweenWithParameterTest | Success | | 0.076 |
| selectSimpleInWithParameterTest | Success | | 0.011 |
| selectAverageQueryForByteColumnTest | Success | | 0.002 |
| selectUsingLockModeQueryHintTest | Success | | 0.005 |
| multipleExecutionOfNamedQueryTest | Success | | 0.004 |
| selectNamedNativeQueryWithPositionalParameterTest | Success | | 0.003 |
| selectNativeQueryWithPositionalParameterTest | Success | | 0.002 |
| testSetup | Success | | 8.441 |
| complexABSTest | Success | | 0.028 |
| complexABSWithParameterTest | Success | | 0.007 |
| compexInTest | Success | | 0.032 |
| complexLengthTest | Success | | 0.013 |
| complexLikeTest | Success | | 0.013 |
| complexNotInTest | Success | | 0.092 |
| complexNotLikeTest | Success | | 0.070 |
| complexParameterTest | Success | | 0.013 |
| complexReverseAbsTest | Success | | 0.017 |
| complexReverseLengthTest | Success | | 0.013 |
| complexReverseParameterTest | Success | | 0.014 |
| complexReverseSqrtTest | Success | | 0.011 |
| complexSqrtTest | Success | | 0.010 |
| complexStringInTest | Success | | 0.024 |
| complexStringNotInTest | Success | | 0.066 |
| complexSubstringTest | Success | | 0.010 |
| complexLocateTest | Success | | 0.008 |
| complexNestedOneToManyUsingInClause | Success | | 0.083 |
| complexUnusedVariableTest | Success | | 0.074 |
| complexJoinTest | Success | | 0.013 |
| complexMultipleJoinOfSameRelationship | Success | | 0.004 |
| complexMultipleLeftOuterJoinOfSameRelationship | Success | | 0.003 |
| complexFetchJoinTest | Success | | 0.069 |
| complexOneToOneFetchJoinTest | Success | | 0.007 |
| complexSelectRelationshipTest | Success | | 0.008 |
| complexConstructorTest | Success | | 0.008 |
| complexConstructorVariableTest | Success | | 0.008 |
| complexConstructorRelationshipTest | Success | | 0.009 |
| complexConstructorAggregatesTest | Success | | 0.009 |
| complexConstructorCountOnJoinedVariableTest | Success | | 0.011 |
| complexResultPropertiesTest | Success | | 0.012 |
| complexInSubqueryTest | Success | | 0.005 |
| complexExistsTest | Success | | 0.012 |
| complexNotExistsTest | Success | | 0.013 |
| complexMemberOfTest | Success | | 0.028 |
| complexNotMemberOfTest | Success | | 0.044 |
| complexNavigatingEmbedded | Success | | 0.002 |
| complexNavigatingTwoLevelOfEmbeddeds | Success | | 0.002 |
| complexNamedQueryResultPropertiesTest | Success | | 0.015 |
| complexOuterJoinQuery | Success | | 0.009 |
| testSetup | Success | | 15.605 |
| testStraightReadSuperClass | Success | | 0.015 |
| testStraightReadSubClass | Success | | 0.005 |
| testJoinSuperClass | Success | | 0.019 |
| testJoinSubClass | Success | | 0.017 |
| testJoinFetchSuperClass | Success | | 0.015 |
| testJoinFetchSubClass | Success | | 0.007 |
| testJoinedInheritance | Success | | 0.003 |
| testJoinedInheritanceWithLeftOuterJoin1 | Success | | 0.003 |
| testJoinedInheritanceWithLeftOuterJoin2 | Success | | 0.003 |
| testJoinedInheritanceWithLeftOuterJoin3 | Success | | 0.002 |
| testSetup | Success | | 8.013 |
| generalExceptionTest | Success | | 0.008 |
| recognitionExceptionTest | Success | | 0.001 |
| missingSelectExceptionTest | Success | | 0.000 |
| malformedJPQLExceptionTest1 | Success | | 0.001 |
| malformedJPQLExceptionTest2 | Success | | 0.002 |
| malformedJPQLExceptionTest3 | Success | | 0.001 |
| malformedJPQLExceptionTest4 | Success | | 0.000 |
| malformedJPQLExceptionTest5 | Success | | 0.002 |
| malformedJPQLExceptionTest6 | Success | | 0.007 |
| malformedJPQLExceptionTest7 | Success | | 0.002 |
| malformedJPQLExceptionTest8 | Success | | 0.001 |
| noAliasWithWHEREAndParameterExceptionTest | Success | | 0.001 |
| multipleDeclarationOfIdentificationVariable | Success | | 0.003 |
| aliasResolutionException | Success | | 0.005 |
| illegalArgumentExceptionTest | Success | | 0.001 |
| createNamedQueryThrowsIllegalArgumentExceptionTest | Success | | 0.000 |
| flushTxExceptionTest | Success | | 0.000 |
| testExecuteUpdateTxException | Success | | 0.002 |
| noResultExceptionTest | Success | | 0.002 |
| testGetSingleResultOnUpdate | Success | | 0.003 |
| testGetSingleResultOnDelete | Success | | 0.002 |
| testExecuteUpdateOnSelect | Success | | 0.001 |
| flushOptimisticLockExceptionTest | Success | | 0.045 |
| commitOptimisticLockExceptionTest | Success | | 0.036 |
| JTAOptimisticLockExceptionTest | Success | | 0.025 |
| testParameterNameValidation | Success | | 0.000 |
| testModArgumentValidation | Success | | 0.002 |
| testInExpressionValidation | Success | | 0.001 |
| testOrderableTypeInOrderByItem | Success | | 0.002 |
| testInvalidNavigation | Success | | 0.002 |
| testInvalidCollectionNavigation | Success | | 0.002 |
| testUnknownAttribute | Success | | 0.002 |
| testUnknownEnumConstant | Success | | 0.002 |
| testCommitRollbackException | Success | | 0.006 |
| testParameterPositionValidation | Success | | 0.001 |
| testParameterPositionValidation2 | Success | | 0.001 |
| testParameterTypeValidation | Success | | 0.002 |
| testEjbqlCaseSensitivity | Success | | 0.008 |
| testEjbqlUnsupportJoinArgument | Success | | 0.002 |
| testInvalidSetClause | Success | | 0.003 |
| testUnsupportedCountDistinctOnOuterJoinedCompositePK | Success | | 0.001 |
| testInvalidHint | Success | | 0.002 |
| testSetup | Success | | 13.555 |
| complexAVGTest | Success | | 0.005 |
| complexCountDistinctWithGroupByAndHavingTest | Success | | 0.005 |
| complexCountDistinctWithGroupByTest | Success | | 0.004 |
| complexCountDistinctWithGroupByTest2 | Success | | 0.004 |
| complexHavingWithAggregate | Success | | 0.014 |
| complexCountTest | Success | | 0.002 |
| complexCountWithGroupByTest | Success | | 0.001 |
| complexDistinctCountTest | Success | | 0.003 |
| complexMaxTest | Success | | 0.003 |
| complexMinTest | Success | | 0.003 |
| complexSumTest | Success | | 0.003 |
| complexCountDistinctOnBaseQueryClass | Success | | 0.009 |
| complexCountOnJoinedVariableSimplePK | Success | | 0.004 |
| complexCountOnJoinedVariableCompositePK | Success | | 0.010 |
| complexCountOnJoinedVariableOverManyToManySelfRefRelationship | Success | | 0.002 |
| complexCountOnJoinedCompositePK | Success | | 0.026 |
| testSetup | Success | | 0.152 |
| testSqlDate | Success | | 0.003 |
| testSqlDateToTS | Success | | 0.002 |
| testTime | Success | | 0.004 |
| testTimeToTS | Success | | 0.001 |
| testTimestamp | Success | | 0.002 |
| testTimestampToDate | Success | | 0.001 |
| testTimestampToTime | Success | | 0.000 |
| testUtilDate | Success | | 0.005 |
| testCalenderWithUtilDate | Success | | 0.002 |
| testSqlDateWithCal | Success | | 0.001 |
| testTimeWithCal | Success | | 0.001 |
| testTimestampWithCal | Success | | 0.001 |
| testUtilDateWithCal | Success | | 0.000 |
| testCalendar | Success | | 0.001 |
| testTimestampGreaterThan | Success | | 0.003 |
| testTimestampLessThan | Success | | 0.002 |
| testTimestampIn | Success | | 0.002 |
| testTimestampBetween | Success | | 0.003 |
| testSetup | Success | | 0.146 |
| testSetup | Success | | 8.572 |
| multipleParameterTest | Success | | 0.017 |
| updateEnumParameter | Success | | 0.039 |
| testSetup | Success | | 11.557 |
| findAllOrders | Success | | 0.006 |
| findEmployeesInOntario | Success | | 0.056 |
| findAllProvinceWithEmployees | Success | | 0.003 |
| findAllEmployeesWithPhoneNumbers | Success | | 0.063 |
| findAllEmployeesWithOutPhoneNumbers | Success | | 0.005 |
| findAllEmployeesWithCellPhones | Success | | 0.026 |
| findOrdersWithDifferentBilledCustomer | Success | | 0.005 |
| findEmployeeWithWorkPhone2258812 | Success | | 0.031 |
| parameterTest | Success | | 0.029 |
| getOrderLargerThan | Success | | 0.003 |
| getSalesPersonForOrders | Success | | 0.005 |
| getOrderForCustomer | Success | | 0.008 |
| testOuterJoin | Success | | 0.018 |
| testExistsExpression | Success | | 0.005 |
| testAllExpressions | Success | | 0.006 |
| testCountInSubQuery | Success | | 0.004 |
| testGroupByHavingExpression | Success | | 0.011 |
| testGroupByHavingCount | Success | | 0.004 |
| testConstructorQuery | Success | | 0.002 |
| testSumExpression | Success | | 0.003 |
| testAvgExpression | Success | | 0.002 |
| testOrderByExpression | Success | | 0.015 |
| testCountInSubQuery | Success | | 0.001 |
| testOrderByExpressionWithSelect | Success | | 0.005 |
| testDeleteExpression | Success | | 0.034 |
| testComplexDeleteExpression | Success | | 0.044 |
| updateAllTest | Success | | 0.052 |
| namedQueryCloneTest | Success | | 0.013 |
| aggregateParameterTest | Success | | 0.032 |
| testEJBQLQueryString | Success | | 0.008 |
| updateEmbeddedFieldTest | Success | | 0.041 |
| testSetup | Success | | 8.416 |
| simpleUpdate | Success | | 8.420 |
| updateWithSubquery | Success | | 8.421 |
| updateEmbedded | Success | | 8.560 |
| updateEmbeddedFieldTest | Success | | 8.279 |
| updateUnqualifiedAttributeInSet | Success | | 9.069 |
| updateUnqualifiedAttributeInWhere | Success | | 8.430 |
| updateDateTimeFields | Success | | 9.019 |
| simpleDelete | Success | | 8.447 |
| testSetup | Success | | 9.025 |
| simpleUpdate | Success | | 8.512 |
| updateWithSubquery | Success | | 8.415 |
| updateEmbedded | Success | | 9.299 |
| updateEmbeddedFieldTest | Success | | 8.327 |
| updateUnqualifiedAttributeInSet | Success | | 8.899 |
| updateUnqualifiedAttributeInWhere | Success | | 10.446 |
| updateDateTimeFields | Success | | 9.187 |
| simpleDelete | Success | | 8.670 |
| testSetup | Success | | 11.141 |
| testQueryCacheFirstCacheHits | Success | | 0.015 |
| testQueryCacheOnlyCacheHits | Success | | 0.005 |
| testQueryCacheOnlyCacheHitsOnSession | Success | | 0.008 |
| testQueryPrimaryKeyCacheHits | Success | | 0.007 |
| testQueryExactPrimaryKeyCacheHits | Success | | 0.006 |
| testQueryTypeCacheHits | Success | | 0.006 |
| testQueryCache | Success | | 0.008 |
| testQueryREADLock | Success | | 0.033 |
| testQueryWRITELock | Success | | 0.089 |
| testQueryOPTIMISTICLock | Success | | 0.024 |
| testQueryOPTIMISTIC_FORCE_INCREMENTLock | Success | | 0.020 |
| testQueryPESSIMISTICLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (t2.EMP_ID = t1.EMP_ID) FOR UPDATE NOWAIT Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (t2.EMP_ID = t1.EMP_ID) FOR UPDATE NOWAIT
Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:394)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:537)
at org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testQueryPESSIMISTICLock(AdvancedQueryTestSuite.java:610)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (t2.EMP_ID = t1.EMP_ID) FOR UPDATE NOWAIT
Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:599)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2506)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2464)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:478)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:456)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1148)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1130)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:368)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.007 |
| testQueryPESSIMISTIC_FORCE_INCREMENTLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (((t1.EMP_ID = ?) AND (t1.F_NAME = ?)) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT bind => [39659, Guillaume] Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (((t1.EMP_ID = ?) AND (t1.F_NAME = ?)) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [39659, Guillaume]
Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:394)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:567)
at org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testQueryPESSIMISTIC_FORCE_INCREMENTLock(AdvancedQueryTestSuite.java:680)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (((t1.EMP_ID = ?) AND (t1.F_NAME = ?)) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [39659, Guillaume]
Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:599)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2506)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2464)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:478)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:456)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1148)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1130)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:368)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.013 |
| testQueryPESSIMISTICTIMEOUTLock | Error | Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1 Error Code: 1064 Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (((t1.EMP_ID = ?) AND (t1.F_NAME = ?)) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT bind => [39644, OptimisticForceIncrement] Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
javax.persistence.PessimisticLockException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (((t1.EMP_ID = ?) AND (t1.F_NAME = ?)) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [39644, OptimisticForceIncrement]
Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:394)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:567)
at org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testQueryPESSIMISTICTIMEOUTLock(AdvancedQueryTestSuite.java:713)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:357)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20081017)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
Error Code: 1064
Call: SELECT t1.EMP_ID, t2.EMP_ID, t1.GENDER, t1.L_NAME, t1.PAY_SCALE, t1.ROOM_NUM, t2.SALARY, t1.STATUS, t1.VERSION, t1.F_NAME, t1.START_DATE, t1.END_DATE, t1.START_TIME, t1.END_TIME, t1.START_OVERTIME, t1.END_OVERTIME, t1.FORMER_COMPANY, t1.FORMER_START_DATE, t1.FORMER_END_DATE, t1.ADDR_ID, t1.DEPT_ID, t1.MANAGER_EMP_ID, t0.ID, t0.NAME FROM CMP3_EMPLOYEE t1 LEFT OUTER JOIN CMP3_DEPT t0 ON (t0.ID = t1.DEPT_ID), CMP3_SALARY t2 WHERE (((t1.EMP_ID = ?) AND (t1.F_NAME = ?)) AND (t2.EMP_ID = t1.EMP_ID)) FOR UPDATE NOWAIT
bind => [39644, OptimisticForceIncrement]
Query: ReadAllQuery(org.eclipse.persistence.testing.models.jpa.advanced.Employee)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:867)
at org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:132)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:599)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2506)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2464)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:478)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:879)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:647)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:840)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:456)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:902)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2634)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1174)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1148)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1130)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:368)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOWAIT' at line 1
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.executeQuery(PreparedStatement.java:1467)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:846)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:572)
| 0.015 |
| testCreateEmployee | Success | | 0.012 |
| testReadEmployee | Success | | 0.003 |
| testNamedNativeQueryOnAddress | Success | | 0.011 |
| testNamedQueryOnEmployee | Success | | 0.001 |
| testUpdateEmployee | Success | | 0.011 |
| testRefreshNotManagedEmployee | Success | | 0.001 |
| testRefreshRemovedEmployee | Success | | 0.033 |
| testDeleteEmployee | Success | | 0.012 |
| testUnidirectionalPersist | Success | | 0.122 |
| testUnidirectionalUpdate | Success | | 0.083 |
| testUnidirectionalFetchJoin | Success | | 0.071 |
| testUnidirectionalTargetLocking_AddRemoveTarget | Success | | 0.076 |
| testUnidirectionalTargetLocking_DeleteSource | Success | | 0.084 |
| testCreateCustomer | Success | | 0.017 |
| testCreateItem | Success | | 0.008 |
| testCreateOrder | Success | | 0.020 |
| testReadCustomer | Success | | 0.001 |
| testReadItem | Success | | 0.001 |
| testReadOrder | Success | | 0.001 |
| testNamedQueryOnCustomer | Success | | 0.001 |
| testNamedQueryOnItem | Success | | 0.002 |
| testNamedQueryOnOrder | Success | | 0.001 |
| testUpdateCustomer | Success | | 0.029 |
| testUpdateItem | Success | | 0.024 |
| testUpdateOrder | Success | | 0.036 |
| testDeleteOrder | Success | | 0.013 |
| testDeleteCustomer | Success | | 0.011 |
| testDeleteItem | Success | | 0.011 |
| testUnidirectionalOneToOneCreate | Success | | 0.032 |
| testUnidirectionalOneToOneRead | Success | | 0.002 |
| testUnidirectionalOneToOneDeleteNonowning | Success | | 0.014 |
| testUnidirectionalOneToOneDeleteOwning | Success | | 0.007 |
| testUnidirectionalOneToManyCreate | Success | | 0.015 |
| testUnidirectionalOneToManyRead | Success | | 0.002 |
| testUnidirectionalOneToManyDeleteNonowning | Success | | 0.011 |
| testUnidirectionalOneToManyDeleteOwning | Success | | 0.011 |
| testUnidirectionalManyToOneCreate | Success | | 0.028 |
| testUnidirectionalManyToOneRead | Success | | 0.001 |
| testUnidirectionalManyToOneDeleteNonowning | Success | | 0.014 |
| testUnidirectionalManyToOneDeleteOwning | Success | | 0.012 |
| testUnidirectionalManyToManyCreate | Success | | 0.014 |
| testUnidirectionalManyToManyRead | Success | | 0.001 |
| testUnidirectionalManyToManyDeleteNonowning | Success | | 0.007 |
| testUnidirectionalManyToManyDeleteOwning | Success | | 0.012 |
| testCreateFueledVehicle | Success | | 0.008 |
| testCreateBusFueledVehicle | Success | | 0.008 |
| testCreateNonFueledVehicle | Success | | 0.029 |
| testReadFueledVehicle | Success | | 0.000 |
| testReadNonFueledVehicle | Success | | 0.000 |
| testNamedNativeQueryOnSportsCar | Success | | 0.001 |
| testUpdateBusFueledVehicle | Success | | 0.012 |
| testUpdateFueledVehicle | Success | | 0.009 |
| testUpdateNonFueledVehicle | Success | | 0.011 |
| testDeleteBusFueledVehicle | Success | | 0.012 |
| testDeleteFueledVehicle | Success | | 0.012 |
| testDeleteNonFueledVehicle | Success | | 0.012 |
| testOneToManyRelationships | Success | | 0.013 |
| testVerifyOneToManyRelationships | Success | | 0.004 |
| testCreateBeerConsumer | Success | | 0.031 |
| testReadBeerConsumer | Success | | 0.001 |
| testNamedNativeQueryBeerConsumers | Success | | 0.003 |
| testNamedNativeQueryCertifications | Success | | 0.002 |
| testUpdateBeerConsumer | Success | | 0.013 |
| testDeleteBeerConsumer | Success | | 0.017 |
| testInheritanceDiscriminatorFieldValue | Success | | 0.000 |
| testMappingsTypes | Success | | 0.001 |
| testCustomerOrdersMapping | Success | | 0.001 |
| testOrderCustomerMapping | Success | | 0.000 |
| testItemNameMapping | Success | | 0.000 |
| testCreateCustomer | Success | | 0.006 |
| testCreateItem | Success | | 0.024 |
| testCreateOrder | Success | | 0.010 |
| testReadCustomer | Success | | 0.000 |
| testReadItem | Success | | 0.000 |
| testReadOrder | Success | | 0.000 |
| testNamedQueryOnCustomer | Success | | 0.001 |
| testNamedQueryOnItem | Success | | 0.002 |
| testNamedQueryOnOrder | Success | | 0.001 |
| testUpdateCustomer | Success | | 0.010 |
| testUpdateItem | Success | | 0.024 |
| testUpdateOrder | Success | | 0.012 |
| testDeleteOrder | Success | | 0.058 |
| testDeleteCustomer | Success | | 0.008 |
| testDeleteItem | Success | | 0.008 |
| testCreateCustomer | Success | | 0.027 |
| testCreateItem | Success | | 0.029 |
| testCreateOrder | Success | | 0.011 |
| testReadCustomer | Success | | 0.001 |
| testReadItem | Success | | 0.000 |
| testReadOrder | Success | | 0.001 |
| testUpdateCustomer | Success | | 0.011 |
| testUpdateItem | Success | | 0.082 |
| testUpdateOrder | Success | | 0.033 |
| testDeleteOrder | Success | | 0.059 |
| testDeleteCustomer | Success | | 0.036 |
| testDeleteItem | Success | | 0.027 |
| testCreateEmployee | Success | | 0.044 |
| testReadEmployee | Success | | 0.001 |
| testUpdateEmployee | Success | | 0.016 |
| testDeleteEmployee | Success | | 0.016 |
| testOneToManyRelationships | Success | | 5.296 |
| testVerifyOneToManyRelationships | Success | | 0.007 |
| testCreateBeerConsumer | Success | | 0.048 |
| testReadBeerConsumer | Success | | 0.001 |
| testNamedNativeQueryBeerConsumers | Success | | 0.003 |
| testNamedNativeQueryCertifications | Success | | 0.003 |
| testMappedSuperclassTransientField | Success | | 0.004 |
| testTransientField | Success | | 0.001 |
| testUpdateBeerConsumer | Success | | 0.010 |
| testDeleteBeerConsumer | Success | | 0.020 |
| testBeerLifeCycleMethodAnnotationIgnored | Success | | 0.011 |
| testMappedSuperclassEntityListener | Success | | 0.011 |
| testMappedSuperclassEmbeddedXMLElement | Success | | 0.000 |
| testSetup | Success | | 0.000 |
| testDDLPkConstraintErrorIncludingRelationTableColumnName | Success | | 0.019 |
| testDDLUniqueKeysAsJoinColumns | Success | | 0.013 |
| testDDLUniqueConstraintsByAnnotations | Success | | 0.050 |
| testDDLUniqueConstraintsByXML | Success | | 0.043 |
| testDDLSubclassEmbeddedIdPkColumnsInJoinedStrategy | Success | | 0.011 |
| testBug241308 | Success | | 0.008 |
| testSetup | Success | | 1.257 |
| testSessionXMLProperty | Success | | 0.085 |
| testSessionEventListenerProperty | Success | | 0.018 |
| testExceptionHandlerProperty | Success | | 0.002 |
| testNativeSQLProperty | Success | | 0.000 |
| testCacheStatementsAndItsSizeProperty | Success | | 0.000 |
| testBatchwritingProperty | Success | | 0.000 |
| testCopyDescriptorNamedQueryToSessionProperty | Success | | 0.001 |
| testLoggingTyperProperty | Success | | 0.000 |
| testProfilerTyperProperty | Success | | 0.220 |
| testSetup | Success | | 0.684 |
| testCreateWrapperTypes | Success | | 0.019 |
| testNullifyBigDecimal | Success | | 0.010 |
| testNullifyBigInteger | Success | | 0.010 |
| testNullifyBoolean | Success | | 0.007 |
| testNullifyByte | Success | | 0.007 |
| testNullifyCharacter | Success | | 0.007 |
| testNullifyShort | Success | | 0.007 |
| testNullifyInteger | Success | | 0.007 |
| testNullifyLong | Success | | 0.015 |
| testNullifyFloat | Success | | 0.007 |
| testNullifyDouble | Success | | 0.007 |
| testNullifyString | Success | | 0.007 |
| testCreateByteArrayType | Success | | 0.020 |
| testCreatePrimitiveByteArrayType | Success | | 0.020 |
| testCreateCharacterArrayType | Success | | 0.020 |
| testCreateCharArrayType | Success | | 0.019 |
| testPrimitiveByteArrayPK | Success | | 0.000 |
| testSetup | Success | | 0.161 |
| testCreateDateTime | Success | | 0.009 |
| testNullifySqlDate | Success | | 0.010 |
| testNullifyTime | Success | | 0.009 |
| testNullifyTimestamp | Success | | 0.008 |
| testNullifyUtilDate | Success | | 0.017 |
| testNullifyCalendar | Success | | 0.009 |
| testSetup | Success | | 0.228 |
| testCreate | Success | | 0.032 |
| testRead | Success | | 0.011 |
| testUpdate | Success | | 0.020 |
| testDelete | Success | | 0.015 |