Hi,
running the tests from entity-persistence-tests on derby results in 9
failures and 3 errors. You find the testsresults file attached.
Failures
- 8 failures are issues with queries using date, time, or timestamp values.
- testReadJuniorScientist fails reading a persistence instance.
Errors:
- Test testBindParametersWithPostitional results in a SqlException
because the generated SQL uses JPQL input parameter syntax, so '?1'
instead of '?': ... AND t1.BUDGET > ?1 ...
- Test testPessimisticLocking results in a SqlException: FOR UPDATE is
not permitted in this type of statement.
- Test testTrimWithoutTrimChar results in a SqlException: 'TRIM' is not
recognized as a function or procedure.
Regards Michael
Testsuite: oracle.toplink.essentials.testing.tests.FullRegressionTestSuite
Tests run: 432, Failures: 9, Errors: 3, Time elapsed: 384.766 sec
------------- Standard Output ---------------
[]
------------- ---------------- ---------------
Testcase: testNamedNativeQuery took 0.063 sec
Testcase: testPersistThenRemoveCalls took 0.531 sec
Testcase: testRemoveUnmanagedNewEntity took 0.078 sec
Testcase: testPersistOnRegisteredObject took 0.062 sec
Testcase: testPreUpdateEvent_UpdateAltered took 0.125 sec
Testcase: testPreUpdateEvent_UpdateReverted took 0.125 sec
Testcase: testRefreshNotManaged took 0.016 sec
Testcase: testRefreshRemoved took 0.265 sec
Testcase: testContainsRemoved took 0.125 sec
Testcase: testFlushModeEmAutoQueryCommit took 0.125 sec
Testcase: testFlushModeEmAuto took 0.047 sec
Testcase: testFlushModeEmAutoQueryAuto took 0.047 sec
Testcase: testFlushModeEmCommitQueryCommit took 0.016 sec
Testcase: testFlushModeEmCommit took 0.031 sec
Testcase: testFlushModeEmCommitQueryAuto took 0.063 sec
Testcase: testFlushModeOnUpdateQuery took 0.296 sec
Testcase: testSetRollbackOnly took 0.157 sec
Testcase: testSubString took 0.156 sec
Testcase: testDatabaseSyncNewObject took 0 sec
Testcase: testTransactionRequired took 0.016 sec
Testcase: testIgnoreRemovedObjectsOnDatabaseSync took 0.359 sec
Testcase: testREADLock took 0.062 sec
Testcase: testPersistRemoved took 1.485 sec
Testcase: testPersistManagedException took 0.031 sec
Testcase: testPersistManagedNoException took 0.063 sec
Testcase: testRemoveFlushPersistContains took 0.125 sec
Testcase: testRemoveFlushFind took 0.125 sec
Testcase: testFindWithWrongTypePk took 0 sec
Testcase: testCheckVersionOnMerge took 0.031 sec
Testcase: testClear took 0.062 sec
Testcase: testClearWithFlush took 0.078 sec
Testcase: testClearInTransaction took 0.032 sec
Testcase: testExtendedPersistenceContext took 0.453 sec
Testcase: testReadTransactionIsolation_CustomUpdate took 0.172 sec
Testcase: testReadTransactionIsolation_CustomUpdate_Flush took 0.078 sec
Testcase: testReadTransactionIsolation_CustomUpdate_Refresh took 0.094 sec
Testcase: testReadTransactionIsolation_CustomUpdate_Refresh_Flush took 0.109 sec
Testcase: testReadTransactionIsolation_UpdateAll took 0.094 sec
Testcase: testReadTransactionIsolation_UpdateAll_Flush took 0.125 sec
Testcase: testReadTransactionIsolation_UpdateAll_Refresh took 0.109 sec
Testcase: testReadTransactionIsolation_UpdateAll_Refresh_Flush took 0.109 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate took 0.079 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush took 0.093 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh took 0.11 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush took 0.093 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll took 0.079 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush took 0.078 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh took 0.109 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush took 0.094 sec
Testcase: testFindDeleteAllPersist took 0.234 sec
Testcase: testWRITELock took 0.063 sec
Testcase: testEMFWrapValidationException took 0.39 sec
Testcase: testEMDefaultTxType took 0.407 sec
Testcase: testPersistOnNonEntity took 0 sec
Testcase: testClose took 0 sec
Testcase: testBeginTransactionClose took 0 sec
Testcase: testBeginTransactionCloseCommitTransaction took 0.109 sec
Testcase: testPersistenceProperties took 0 sec
Testcase: testMultipleFactories took 0.109 sec
Testcase: testNullifyAddressIn took 0.032 sec
Testcase: testLeftJoinOneToOneQuery took 0.062 sec
Testcase: testInheritanceNoDiscriminatorColumn took 0.031 sec
Testcase: testComplicateResultWithInheritance took 0.141 sec
Testcase: testRefresh took 0.141 sec
Testcase: testBindParameters took 0.187 sec
Testcase: testBindParametersWithPostitional took 0.016 sec
Caused an ERROR
Internal Exception: org.apache.derby.client.am.SqlException: Syntax error: Encountered "1" at line 1, column 199.Error Code: -1
Call:SELECT t0.PROJ_ID, t0.PROJ_TYPE AS SMALL_DESCRIM, t0.PROJ_NAME, t0.DESCRIP, t0.LEADER_ID, t0.VERSION, t1.BUDGET FROM CMP3_PROJECT t0, CMP3_LPROJECT t1 WHERE t1.PROJ_ID = t0.PROJ_ID AND t1.BUDGET > ?1 AND t1.BUDGET < 30000000
bind => [4000]
Query:ResultSetMappingQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.5 (Build 060511)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: org.apache.derby.client.am.SqlException: Syntax error: Encountered "1" at line 1, column 199.Error Code: -1
Call:SELECT t0.PROJ_ID, t0.PROJ_TYPE AS SMALL_DESCRIM, t0.PROJ_NAME, t0.DESCRIP, t0.LEADER_ID, t0.VERSION, t1.BUDGET FROM CMP3_PROJECT t0, CMP3_LPROJECT t1 WHERE t1.PROJ_ID = t0.PROJ_ID AND t1.BUDGET > ?1 AND t1.BUDGET < 30000000
bind => [4000]
Query:ResultSetMappingQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:252)
at oracle.toplink.essentials.queryframework.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:198)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
at oracle.toplink.essentials.testing.tests.cmp3.advanced.SQLResultSetMappingTestSuite.testBindParametersWithPostitional(SQLResultSetMappingTestSuite.java:192)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "1" at line 1, column 199.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1137)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:597)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:470)
... 34 more
Testcase: testSimpleInheritance took 0.063 sec
Testcase: testPessimisticLocking took 0.047 sec
Caused an ERROR
Internal Exception: org.apache.derby.client.am.SqlException: FOR UPDATE is not permitted in this type of statement. Error Code: -1
Call:SELECT t0.PROJ_ID, t0.PROJ_TYPE, t0.PROJ_NAME, t0.DESCRIP, t0.LEADER_ID, t0.VERSION, t1.BUDGET FROM CMP3_PROJECT t0, CMP3_LPROJECT t1 WHERE t1.PROJ_ID = t0.PROJ_ID AND t1.PROJ_ID = 1 FOR UPDATE
Query:ResultSetMappingQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.5 (Build 060511)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: org.apache.derby.client.am.SqlException: FOR UPDATE is not permitted in this type of statement. Error Code: -1
Call:SELECT t0.PROJ_ID, t0.PROJ_TYPE, t0.PROJ_NAME, t0.DESCRIP, t0.LEADER_ID, t0.VERSION, t1.BUDGET FROM CMP3_PROJECT t0, CMP3_LPROJECT t1 WHERE t1.PROJ_ID = t0.PROJ_ID AND t1.PROJ_ID = 1 FOR UPDATE
Query:ResultSetMappingQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.executeCall(UnitOfWorkImpl.java:1362)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:252)
at oracle.toplink.essentials.queryframework.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:198)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:536)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
at oracle.toplink.essentials.testing.tests.cmp3.advanced.SQLResultSetMappingTestSuite.testPessimisticLocking(SQLResultSetMappingTestSuite.java:229)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: org.apache.derby.client.am.SqlException: FOR UPDATE is not permitted in this type of statement.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1137)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:597)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:470)
... 34 more
Testcase: testComplicateResults took 0.047 sec
Testcase: testProjectJoinTeamMembers took 1.703 sec
Testcase: testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull took 1.609 sec
Testcase: testProjectJoinTeamMembersJoinAddress took 2 sec
Testcase: testProjectOuterJoinTeamMembersJoinAddress took 1.047 sec
Testcase: testProjectOuterJoinTeamMembersOuterJoinAddress took 1.141 sec
Testcase: testProjectJoinTeamMembersOuterJoinAddress took 0.968 sec
Testcase: testProblemReporterProjectJoinTeamMembersJoinAddress took 0.844 sec
Testcase: testEmployeeJoinProjects took 0.813 sec
Testcase: testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull took 0.968 sec
Testcase: testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName took 0.797 sec
Testcase: testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones took 1.563 sec
Testcase: testEmployeeJoinManagerAddressOuterJoinManagerAddress took 1.484 sec
Testcase: testTwoUnrelatedResultWithOneToManyJoins took 1.109 sec
Testcase: testMultipleUnrelatedResultWithOneToManyJoins took 1.657 sec
Testcase: testTwoUnrelatedResultWithOneToOneJoins took 1.562 sec
Testcase: testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem took 1.5 sec
Testcase: testSimpleReturnDirectToField took 0.016 sec
Testcase: testSimpleReturnObject took 0.031 sec
Testcase: testReturnObjectAndDirectToField took 0.047 sec
Testcase: testReturnUnrelatedObjectAndDirectToField took 0.156 sec
Testcase: testInheritanceMultiTableException took 0 sec
Testcase: testReturnRootObject took 0.047 sec
Testcase: testExtendedPersistenceContext took 0.015 sec
Testcase: testSimpleConstructorExpression took 0.032 sec
Testcase: testSimpleConstructorExpressionWithNamedQuery took 0 sec
Testcase: testMultipleTypeConstructorExpression took 0.047 sec
Testcase: testNonExistantConstructorConstructorExpression took 0 sec
Testcase: testPrimitiveConstructorExpression took 0.015 sec
Testcase: testConstructorEJBQLWithInheritance took 0.016 sec
Testcase: testConstructorExpressionWithOtherAttributes took 0.015 sec
Testcase: testCreateDepartment took 0.031 sec
Testcase: testCreateScientists took 0.156 sec
Testcase: testReadDepartment took 0.078 sec
Testcase: testReadJuniorScientist took 0.016 sec
FAILED
Error on reading back the junior scientist.
junit.framework.AssertionFailedError: Error on reading back the junior scientist.
at oracle.toplink.essentials.testing.tests.cmp3.advanced.compositepk.AdvancedCompositePKJunitTest.testReadJuniorScientist(AdvancedCompositePKJunitTest.java:189)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testPrePersistBusOverrideAndAbstractInheritAndDefault took 0.094 sec
Testcase: testPostPersistBusInheritAndDefault took 0.062 sec
Testcase: testPostLoadBusInheritAndDefault took 0 sec
Testcase: testPrePersistSportsCarInheritAndExcludeDefault took 0.031 sec
Testcase: testPostPersistSportsCarInheritAndExcludeDefault took 0.016 sec
Testcase: testPrePersistSportsCarOverride took 0 sec
Testcase: test_null took 2.016 sec
Testcase: test_nullNonDeferred took 1.281 sec
Testcase: test_ownerTOP took 1.828 sec
Testcase: test_fuelTypePetrol took 0.656 sec
Testcase: test_schoolBusNullDriver took 0.141 sec
Testcase: test_ownerOwnsNonFueledVehicle took 0.953 sec
Testcase: testInitialize took 0.141 sec
Testcase: test1 took 0.125 sec
Testcase: testInitialize took 0.031 sec
Testcase: test2 took 0.047 sec
Testcase: testInitialize took 0.047 sec
Testcase: test3 took 0.094 sec
Testcase: testCreateBlue took 0.015 sec
Testcase: testReadBlue took 0.016 sec
Testcase: testPreAndPostPersistAlpine took 0.016 sec
Testcase: testPreAndPostPersistBeerConsumer took 0.031 sec
Testcase: testPostLoadOnFind took 0 sec
Testcase: testPostLoadOnRefresh took 0.047 sec
Testcase: testPreAndPostUpdate took 0.016 sec
Testcase: testPreAndPostRemove took 0.047 sec
Testcase: testCreateBeerConsumer took 0.016 sec
Testcase: testCreateAlpine took 0.078 sec
Testcase: testCreateCanadian took 0.047 sec
Testcase: testCreateCertifications took 0.047 sec
Testcase: testCreateTelephoneNumbers took 0.078 sec
Testcase: testReadBeerConsumer took 0.015 sec
Testcase: testReadAlpine took 0.016 sec
Testcase: testReadCanadian took 0.016 sec
Testcase: testInsertNewAlpine took 0.078 sec
Testcase: testInsertNewAlpineAndModifyOrderOfExistingAlpines took 0.093 sec
Testcase: testUpdateAlpine took 0.032 sec
Testcase: testUpdateAlpineThroughBeerConsumer took 0.031 sec
Testcase: testUpdateBeerConsumer took 0.031 sec
Testcase: testUpdateCanadian took 0.031 sec
Testcase: testUpdateCanadianThroughBeerConsumer took 0.032 sec
Testcase: testUpdateCertifications took 0.109 sec
Testcase: testUpdateTelephoneNumberThroughBeerConsumer took 0.063 sec
Testcase: testShuffleTelephoneNumbersOnBeerConsumers took 0.093 sec
Testcase: testDeleteAlpine took 0.032 sec
Testcase: testDeleteCanadian took 0.031 sec
Testcase: testDeleteBeerConsumer took 0.062 sec
Testcase: testgetReference took 4.657 sec
Testcase: testcreateNativeQuery took 5.796 sec
Testcase: testcreateNativeQueryWithSelectSQL took 3.985 sec
Testcase: testNativeNamedQuery took 4 sec
Testcase: testSetParameterUsingNull took 3.687 sec
Testcase: testLeftTrimWithTrimChar took 3.672 sec
Testcase: testTrimWithTrimChar took 4.031 sec
Testcase: testTrimWithoutTrimChar took 4.204 sec
Caused an ERROR
Internal Exception: org.apache.derby.client.am.SqlException: 'TRIM' is not recognized as a function or procedure.Error Code: -1
Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (TRIM(NAME) = 'tem')
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.5 (Build 060511)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: org.apache.derby.client.am.SqlException: 'TRIM' is not recognized as a function or procedure.Error Code: -1
Call:SELECT ID, ITEM_VERSION, DESCRIPTION, NAME FROM CMP3_ITEM WHERE (TRIM(NAME) = 'tem')
Query:ReadAllQuery(oracle.toplink.essentials.testing.models.cmp3.relationships.Item)
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2111)
at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2089)
at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:302)
at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1820)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
at oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.testTrimWithoutTrimChar(ExpressionJUnitTestSuite.java:179)
Caused by: org.apache.derby.client.am.SqlException: 'TRIM' is not recognized as a function or procedure.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1137)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:597)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:470)
... 33 more
Testcase: testLocateWithSingleArgument took 4.547 sec
Testcase: testLocateWithDoubleArgument took 3.938 sec
Testcase: testInsertVirtualAttribute took 0.063 sec
Testcase: testReadVirtualAttribute took 0.031 sec
Testcase: testUpdateVirtualAttribute took 0.015 sec
Testcase: testDeleteVirtualAttribute took 0.047 sec
Testcase: testPKClassTypeValidation took 0.016 sec
Testcase: testParameterNameValidation took 0 sec
Testcase: testParameterPositionValidation took 0 sec
Testcase: testParameterPositionValidation2 took 0 sec
Testcase: testSelectPhoneNumberAreaCode took 0.031 sec
Testcase: testSelectPhoneNumberAreaCodeWithEmployee took 0.203 sec
Testcase: testSelectPhoneNumberNumberWithEmployeeWithExplicitJoin took 0.156 sec
Testcase: testSelectPhoneNumberNumberWithEmployeeWithFirstNameFirst took 0.156 sec
Testcase: testSelectEmployeeWithSameParameterUsedMultipleTimes took 0.016 sec
Testcase: testOuterJoinOnOneToOne took 0.063 sec
Testcase: testOuterJoinPolymorphic took 0.046 sec
Testcase: testFirstResultOnNamedQuery took 0.032 sec
Testcase: simpleJoinFetchTest took 0.578 sec
Testcase: baseTestCase took 0.359 sec
Testcase: simpleABSTest took 0.047 sec
Testcase: simpleBetweenAndTest took 0.344 sec
Testcase: simpleBetweenTest took 0.328 sec
Testcase: simpleConcatTest took 0.063 sec
Testcase: simpleConcatTestWithParameters took 0.031 sec
Testcase: simpleConcatTestWithConstants1 took 0.062 sec
Testcase: simpleDistinctTest took 0.063 sec
Testcase: simpleDistinctNullTest took 0.062 sec
Testcase: simpleDistinctMultipleResultTest took 0.063 sec
Testcase: simpleDoubleOrTest took 0.094 sec
Testcase: simpleEqualsBracketsTest took 0.046 sec
Testcase: simpleEqualsTest took 0.047 sec
Testcase: simpleEqualsTestWithJoin took 0.282 sec
Testcase: simpleEqualsWithAs took 0.046 sec
Testcase: collectionMemberIdentifierEqualsTest took 0.079 sec
Testcase: abstractSchemaIdentifierEqualsTest took 0.031 sec
Testcase: abstractSchemaIdentifierNotEqualsTest took 0.328 sec
Testcase: simpleInOneDotTest took 0.062 sec
Testcase: simpleInTest took 0.047 sec
Testcase: simpleLengthTest took 0.047 sec
Testcase: simpleLikeTest took 0.047 sec
Testcase: simpleLikeTestWithParameter took 0.047 sec
Testcase: simpleLikeEscapeTestWithParameter took 0.094 sec
Testcase: simpleNotBetweenTest took 0.156 sec
Testcase: simpleNotEqualsVariablesInteger took 0.328 sec
Testcase: simpleNotInTest took 0.344 sec
Testcase: simpleNotLikeTest took 0.344 sec
Testcase: simpleOrFollowedByAndTest took 0.062 sec
Testcase: simpleOrFollowedByAndTestWithStaticNames took 0.094 sec
Testcase: simpleOrTest took 0.078 sec
Testcase: simpleParameterTest took 0.047 sec
Testcase: simpleParameterTestChangingParameters took 0.094 sec
Testcase: simpleReverseAbsTest took 0.031 sec
Testcase: simpleReverseConcatTest took 0.047 sec
Testcase: simpleReverseEqualsTest took 0.047 sec
Testcase: simpleReverseLengthTest took 0.046 sec
Testcase: simpleReverseParameterTest took 0.063 sec
Testcase: simpleReverseSqrtTest took 0.047 sec
Testcase: simpleReverseSubstringTest took 0.047 sec
Testcase: simpleSqrtTest took 0.031 sec
Testcase: simpleSubstringTest took 0.047 sec
Testcase: simpleNullTest took 0.297 sec
Testcase: simpleNotNullTest took 0.328 sec
Testcase: distinctTest took 0.078 sec
Testcase: conformResultsInUnitOfWorkTest took 0.078 sec
Testcase: simpleModTest took 0.109 sec
Testcase: simpleIsEmptyTest took 0.063 sec
Testcase: simpleIsNotEmptyTest took 0.312 sec
Testcase: simpleApostrohpeTest took 0.063 sec
Testcase: simpleEscapeUnderscoreTest took 0.016 sec
Testcase: smallProjectMemberOfProjectsTest took 0.39 sec
Testcase: smallProjectNOTMemberOfProjectsTest took 0.313 sec
Testcase: selectCountOneToOneTest took 0.031 sec
Testcase: selectOneToOneTest took 0.047 sec
Testcase: selectPhonenumberDeclaredInINClauseTest took 0.25 sec
Testcase: selectSimpleMemberOfWithParameterTest took 0.062 sec
Testcase: selectSimpleNotMemberOfWithParameterTest took 0.313 sec
Testcase: selectSimpleBetweenWithParameterTest took 0.594 sec
Testcase: selectSimpleInWithParameterTest took 0.078 sec
Testcase: selectAverageQueryForByteColumnTest took 0.032 sec
Testcase: selectUsingLockModeQueryHintTest took 0.031 sec
Testcase: complexABSTest took 0.047 sec
Testcase: compexInTest took 0.156 sec
Testcase: complexLengthTest took 0.031 sec
Testcase: complexLikeTest took 0.063 sec
Testcase: complexNotInTest took 0.359 sec
Testcase: complexNotLikeTest took 0.313 sec
Testcase: complexParameterTest took 0.062 sec
Testcase: complexReverseAbsTest took 0.063 sec
Testcase: complexReverseLengthTest took 0.031 sec
Testcase: complexReverseParameterTest took 0.062 sec
Testcase: complexReverseSqrtTest took 0.063 sec
Testcase: complexSqrtTest took 0.062 sec
Testcase: complexStringInTest took 0.094 sec
Testcase: complexStringNotInTest took 0.313 sec
Testcase: complexSubstringTest took 0.031 sec
Testcase: complexNestedOneToManyUsingInClause took 1.562 sec
Testcase: complexUnusedVariableTest took 0.547 sec
Testcase: complexFetchJoinTest took 0.437 sec
Testcase: complexSelectRelationshipTest took 0.032 sec
Testcase: complexConstructorTest took 0.031 sec
Testcase: complexConstructorRelationshipTest took 0.047 sec
Testcase: complexConstructorAggregatesTest took 0.062 sec
Testcase: complexResultPropertiesTest took 0.047 sec
Testcase: complexInSubqueryTest took 0.609 sec
Testcase: complexExistsTest took 0.25 sec
Testcase: complexNotExistsTest took 0.25 sec
Testcase: testStraightReadSuperClass took 0.062 sec
Testcase: testStraightReadSubClass took 0.063 sec
Testcase: testJoinSuperClass took 0.187 sec
Testcase: testJoinSubClass took 0.125 sec
Testcase: testJoinFetchSuperClass took 0.094 sec
Testcase: testJoinFetchSubClass took 0.062 sec
Testcase: generalExceptionTest took 0 sec
Testcase: recognitionExceptionTest took 0 sec
Testcase: missingSelectExceptionTest took 0 sec
Testcase: malformedEjbqlExceptionTest1 took 0.016 sec
Testcase: malformedEjbqlExceptionTest2 took 0 sec
Testcase: malformedEjbqlExceptionTest3 took 0 sec
Testcase: malformedEjbqlExceptionTest4 took 0 sec
Testcase: badAliasExceptionTest took 0 sec
Testcase: noAliasWithWHEREAndParameterExceptionTest took 0 sec
Testcase: missingDescriptorExceptionTest took 0 sec
Testcase: multipleDeclarationOfIdentificationVariable took 0 sec
Testcase: aliasResolutionException took 0 sec
Testcase: illegalArgumentExceptionTest took 0 sec
Testcase: createNamedQueryThrowsIllegalArgumentExceptionTest took 0.015 sec
Testcase: flushTxExceptionTest took 0 sec
Testcase: noResultExceptionTest took 0.016 sec
Testcase: testGetSingleResultOnUpdate took 0 sec
Testcase: testGetSingleResultOnDelete took 0 sec
Testcase: testExecuteUpdateOnSelect took 0 sec
Testcase: flushOptimisticLockExceptionTest took 0.172 sec
Testcase: commitOptimisticLockExceptionTest took 0.047 sec
Testcase: JTAOptimisticLockExceptionTest took 0.031 sec
Testcase: testParameterNameValidation took 0 sec
Testcase: testModArgumentValidation took 0 sec
Testcase: testInExpressionValidation took 0 sec
Testcase: testOrderableTypeInOrderByItem took 0 sec
Testcase: testCommitRollbackException took 0.016 sec
Testcase: testParameterPositionValidation took 0 sec
Testcase: testParameterPositionValidation2 took 0 sec
Testcase: testParameterTypeValidation took 0.281 sec
Testcase: testEjbqlCaseSensitivity took 0.031 sec
Testcase: complexAVGTest took 0.047 sec
Testcase: complexCountTest took 0.016 sec
Testcase: complexDistinctCountTest took 0.031 sec
Testcase: complexMaxTest took 0.031 sec
Testcase: complexMinTest took 0.047 sec
Testcase: complexSumTest took 0.031 sec
Testcase: testSqlDate took 0.032 sec
Testcase: testSqlDateToTS took 0 sec
Testcase: testTime took 0.015 sec
Testcase: testTimeToTS took 0 sec
Testcase: testTimestamp took 0.016 sec
FAILED
There should be one result
junit.framework.AssertionFailedError: There should be one result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testTimestamp(JUnitEJBQLDateTimeTestSuite.java:98)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testTimestampToDate took 0.015 sec
Testcase: testTimestampToTime took 0 sec
Testcase: testUtilDate took 0.016 sec
FAILED
There should be one result
junit.framework.AssertionFailedError: There should be one result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testUtilDate(JUnitEJBQLDateTimeTestSuite.java:134)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testCalenderWithUtilDate took 0.016 sec
FAILED
There should be one result
junit.framework.AssertionFailedError: There should be one result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testCalenderWithUtilDate(JUnitEJBQLDateTimeTestSuite.java:146)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testSqlDateWithCal took 0.015 sec
Testcase: testTimeWithCal took 0 sec
Testcase: testTimestampWithCal took 0 sec
FAILED
There should be one result
junit.framework.AssertionFailedError: There should be one result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testTimestampWithCal(JUnitEJBQLDateTimeTestSuite.java:182)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testUtilDateWithCal took 0.016 sec
FAILED
There should be one result
junit.framework.AssertionFailedError: There should be one result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testUtilDateWithCal(JUnitEJBQLDateTimeTestSuite.java:194)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testCalendar took 0 sec
FAILED
There should be one result
junit.framework.AssertionFailedError: There should be one result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testCalendar(JUnitEJBQLDateTimeTestSuite.java:206)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testTimestampGreaterThan took 0.015 sec
FAILED
There should be three result
junit.framework.AssertionFailedError: There should be three result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testTimestampGreaterThan(JUnitEJBQLDateTimeTestSuite.java:218)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testTimestampLessThan took 0.016 sec
Testcase: testTimestampIn took 0 sec
FAILED
There should be two result
junit.framework.AssertionFailedError: There should be two result
at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLDateTimeTestSuite.testTimestampIn(JUnitEJBQLDateTimeTestSuite.java:248)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testTimestampBetween took 0.015 sec
Testcase: multipleParameterTest took 0.047 sec
Testcase: findAllOrders took 0.015 sec
Testcase: findEmployeesInOntario took 0.313 sec
Testcase: findAllProvinceWithEmployees took 0.015 sec
Testcase: findAllEmployeesWithPhoneNumbers took 0.391 sec
Testcase: findAllEmployeesWithOutPhoneNumbers took 0.062 sec
Testcase: findAllEmployeesWithCellPhones took 0.125 sec
Testcase: findOrdersWithDifferentBilledCustomer took 0.047 sec
Testcase: findEmployeeWithWorkPhone2258812 took 0.235 sec
Testcase: parameterTest took 0.109 sec
Testcase: getOrderLargerThan took 0.016 sec
Testcase: getSalesPersonForOrders took 0.031 sec
Testcase: getOrderForCustomer took 0.062 sec
Testcase: testOuterJoin took 0.141 sec
Testcase: testExistsExpression took 0.688 sec
Testcase: testAllExpressions took 0.515 sec
Testcase: testCountInSubQuery took 0.031 sec
Testcase: testGroupByHavingExpression took 0.125 sec
Testcase: testGroupByHavingCount took 0.047 sec
Testcase: testConstructorQuery took 0.016 sec
Testcase: testSumExpression took 0.047 sec
Testcase: testAvgExpression took 0.015 sec
Testcase: testOrderByExpression took 0.219 sec
Testcase: testCountInSubQuery took 0.016 sec
Testcase: testOrderByExpressionWithSelect took 0.078 sec
Testcase: testDeleteExpression took 0.031 sec
Testcase: testComplexDeleteExpression took 0.047 sec
Testcase: updateAllTest took 0.094 sec
Testcase: namedQueryCloneTest took 0.015 sec
Testcase: simpleUpdate took 8 sec
Testcase: updateWithSubquery took 8.063 sec
Testcase: simpleDelete took 7.312 sec
Testcase: testCreateEmployee took 0.109 sec
Testcase: testReadEmployee took 0.016 sec
Testcase: testNamedNativeQueryOnAddress took 0.031 sec
Testcase: testNamedQueryOnEmployee took 0.016 sec
Testcase: testUpdateEmployee took 0.078 sec
Testcase: testRefreshNotManagedEmployee took 0 sec
Testcase: testRefreshRemovedEmployee took 0.109 sec
Testcase: testDeleteEmployee took 0.141 sec
Testcase: testCreateCustomer took 0.109 sec
Testcase: testCreateItem took 0.016 sec
Testcase: testCreateOrder took 0.062 sec
Testcase: testReadCustomer took 0 sec
Testcase: testReadItem took 0 sec
Testcase: testReadOrder took 0 sec
Testcase: testNamedQueryOnCustomer took 0.016 sec
Testcase: testNamedQueryOnItem took 0.015 sec
Testcase: testNamedQueryOnOrder took 0.016 sec
Testcase: testUpdateCustomer took 0.016 sec
Testcase: testUpdateItem took 0.047 sec
Testcase: testUpdateOrder took 0.046 sec
Testcase: testDeleteCustomer took 0.032 sec
Testcase: testDeleteItem took 0.031 sec
Testcase: testDeleteOrder took 0.016 sec
Testcase: testCreateFueledVehicle took 0.031 sec
Testcase: testCreateBusFueledVehicle took 0.032 sec
Testcase: testCreateNonFueledVehicle took 0.343 sec
Testcase: testReadFueledVehicle took 0 sec
Testcase: testReadNonFueledVehicle took 0 sec
Testcase: testNamedNativeQueryOnSportsCar took 0.016 sec
Testcase: testUpdateBusFueledVehicle took 0.047 sec
Testcase: testUpdateFueledVehicle took 0.015 sec
Testcase: testUpdateNonFueledVehicle took 0.047 sec
Testcase: testDeleteBusFueledVehicle took 0.032 sec
Testcase: testDeleteFueledVehicle took 0.031 sec
Testcase: testDeleteNonFueledVehicle took 0.015 sec
Testcase: testCreateBeerConsumer took 0.109 sec
Testcase: testReadBeerConsumer took 0 sec
Testcase: testNamedNativeQueryBeerConsumers took 0.016 sec
Testcase: testNamedNativeQueryCertifications took 0.016 sec
Testcase: testUpdateBeerConsumer took 0 sec
Testcase: testDeleteBeerConsumer took 0.14 sec
Testcase: testInheritanceDiscriminatorFieldValue took 0 sec
Testcase: testMappingsTypes took 0 sec
Testcase: testCreateCustomer took 0.016 sec
Testcase: testCreateItem took 0.062 sec
Testcase: testCreateOrder took 0.016 sec
Testcase: testReadCustomer took 0 sec
Testcase: testReadItem took 0 sec
Testcase: testReadOrder took 0 sec
Testcase: testNamedQueryOnCustomer took 0.016 sec
Testcase: testNamedQueryOnItem took 0.015 sec
Testcase: testNamedQueryOnOrder took 0.016 sec
Testcase: testUpdateCustomer took 0.031 sec
Testcase: testUpdateItem took 0.078 sec
Testcase: testUpdateOrder took 0.047 sec
Testcase: testDeleteCustomer took 0.031 sec
Testcase: testDeleteItem took 0.063 sec
Testcase: testDeleteOrder took 0.016 sec
Testcase: testCreateCustomer took 0.032 sec
Testcase: testCreateItem took 0.031 sec
Testcase: testCreateOrder took 0.015 sec
Testcase: testReadCustomer took 0.016 sec
Testcase: testReadItem took 0 sec
Testcase: testReadOrder took 0 sec
Testcase: testUpdateCustomer took 0.031 sec
Testcase: testUpdateItem took 0.063 sec
Testcase: testUpdateOrder took 0.265 sec
Testcase: testDeleteCustomer took 0.016 sec
Testcase: testDeleteItem took 0.031 sec
Testcase: testDeleteOrder took 0.016 sec
Testcase: testCreateEmployee took 0.219 sec
Testcase: testReadEmployee took 0 sec
Testcase: testUpdateEmployee took 0.031 sec
Testcase: testDeleteEmployee took 0.141 sec