TCK Oracle results: [ERROR] Errors: [ERROR] Client1.executeTest:192 executeTest failed [ERROR] Client1.executeUpdateOfADeleteTest:1703 executeUpdateOfADeleteTest failed [ERROR] Client1.executeUpdateOfAnUpdateTest:1671 executeUpdateOfAnUpdateTest failed [ERROR] Client1.executeUpdateTransactionRequiredExceptionTest:1734 executeUpdateTransactionRequiredExceptionTest failed [ERROR] Client1.getFirstResultTest:424 getFirstResultTest failed [ERROR] Client1.getLockModeIllegalStateExceptionTest:862 getLockModeIllegalStateExceptionTest failed [ERROR] Client1.getMaxResultsTest:479 getMaxResultsTest failed [ERROR] Client1.getOutputParameterValueIntIllegalArgumentExceptionTest:369 getOutputParameterValueIntIllegalArgumentExceptionTest failed [ERROR] Client1.getOutputParameterValueIntTest:297 getOutputParameterValueIntTest failed [ERROR] Client1.getParameterIntIllegalArgumentExceptionTest:1070 getParameterIntIllegalArgumentExceptionTest failed [ERROR] Client1.getParameterStringExceptionTest:1015 getParameterStringExceptionTest failed [ERROR] Client1.getParameterValueIntIllegalArgumentExceptionTest:2026 getParameterValueIntIllegalArgumentExceptionTest failed [ERROR] Client1.getParameterValueIntIllegalStateExceptionTest:2063 getParameterValueIntIllegalStateExceptionTest failed [ERROR] Client1.getParameterValueIntTest:1988 getParameterValueIntTest failed [ERROR] Client1.getParameterValueParameterIllegalArgumentExceptionTest:1834 getParameterValueParameterIllegalArgumentExceptionTest failed [ERROR] Client1.getParameterValueParameterIllegalStateExceptionTest:1882 getParameterValueParameterIllegalStateExceptionTest failed [ERROR] Client1.getParameterValueParameterTest:1790 getParameterValueParameterTest failed [ERROR] Client1.getParametersTest:1339 getParametersTest failed [ERROR] Client1.getSingleResultNoResultExceptionTest:664 getSingleResultNoResultExceptionTest failed [ERROR] Client1.getSingleResultNonUniqueResultExceptionTest:707 getSingleResultNonUniqueResultExceptionTest failed [ERROR] Client1.getSingleResultOrNullWithNullTest:620 getSingleResultOrNullWithNullTest failed [ERROR] Client1.getSingleResultOrNullWithValueTest:577 getSingleResultOrNullWithValueTest failed [ERROR] Client1.getSingleResultTest:528 getSingleResultTest failed [ERROR] Client1.setGetParameterIntTest:913 setGetParameterIntTest failed [ERROR] Client1.setHintStringObjectTest:2094 setHintStringObjectTest failed [ERROR] Client1.setLockModeIllegalStateExceptionTest:828 setLockModeIllegalStateExceptionTest failed [ERROR] Client1.setParameterIntDateTemporalTypeIllegalArgumentExceptionTest:1477 setParameterIntDateTemporalTypeIllegalArgumentExceptionTest failed [ERROR] Client1.setParameterIntDateTemporalTypeTest:1424 setParameterIntDateTemporalTypeTest failed [ERROR] Client1.setParameterIntObjectIllegalArgumentExceptionTest:1292 setParameterIntObjectIllegalArgumentExceptionTest failed [ERROR] Client1.setParameterParameterDateTemporalTypeIllegalArgumentExceptionTest:1638 setParameterParameterDateTemporalTypeIllegalArgumentExceptionTest failed [ERROR] Client1.setParameterParameterDateTemporalTypeTest:1579 setParameterParameterDateTemporalTypeTest failed [ERROR] Client1.setParameterParameterObjectIllegalArgumentExceptionTest:1207 setParameterParameterObjectIllegalArgumentExceptionTest failed [ERROR] Client1.setParameterParameterObjectTest:1160 setParameterParameterObjectTest failed [ERROR] Client1.setgetFlushModeTest:794 setgetFlushModeTest failed [ERROR] Client1.xmlOverridesNamedStoredProcedureQueryTest:2151 xmlOverridesNamedStoredProcedureQueryTest failed [ERROR] Client1.xmlOverridesSqlResultSetMappingAnnotationTest:2206 xmlOverridesSqlResultSetMappingAnnotationTest failed [ERROR] Client2.setParameterIntCalendarTemporalTypeIllegalArgumentExceptionTest:325 setParameterIntCalendarTemporalTypeIllegalArgumentExceptionTest failed [ERROR] Client2.setParameterIntCalendarTemporalTypeTest:273 setParameterIntCalendarTemporalTypeTest failed [ERROR] Client2.setParameterParameterCalendarTemporalTypeIllegalArgumentExceptionTest:484 setParameterParameterCalendarTemporalTypeIllegalArgumentExceptionTest failed [ERROR] Client2.setParameterParameterCalendarTemporalTypeTest:424 setParameterParameterCalendarTemporalTypeTest failed [ERROR] Client1.fieldTypeTest1:98 fieldTypeTest1 failed [ERROR] Client1.fieldTypeTest10:574 fieldTypeTest10 failed [ERROR] Client1.fieldTypeTest11:643 fieldTypeTest11 failed [ERROR] Client1.fieldTypeTest12:701 fieldTypeTest12 failed [ERROR] Client1.fieldTypeTest13:757 fieldTypeTest13 failed [ERROR] Client1.fieldTypeTest14:813 fieldTypeTest14 failed [ERROR] Client1.fieldTypeTest15:874 fieldTypeTest15 failed [ERROR] Client1.fieldTypeTest16:934 fieldTypeTest16 failed [ERROR] Client1.fieldTypeTest17:999 fieldTypeTest17 failed [ERROR] Client1.fieldTypeTest2:150 fieldTypeTest2 failed [ERROR] Client1.fieldTypeTest3:201 fieldTypeTest3 failed [ERROR] Client1.fieldTypeTest4:252 fieldTypeTest4 failed [ERROR] Client1.fieldTypeTest5:302 fieldTypeTest5 failed [ERROR] Client1.fieldTypeTest6:353 fieldTypeTest6 failed [ERROR] Client1.fieldTypeTest7:403 fieldTypeTest7 failed [ERROR] Client1.fieldTypeTest8:462 fieldTypeTest8 failed [ERROR] Client1.fieldTypeTest9:519 fieldTypeTest9 failed [ERROR] Client2.mixedAccessTest:113 mixedAccessTest failed [ERROR] Client3.transientTest:119 transientTest failed [ERROR] Client4.testExtractDateQuarter:91 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal store error> org.apache.openjpa.persistence.OptimisticLockException: Unable to obtain an object lock on "null". FailedObject: SELECT EXTRACT(QUARTER FROM d.id) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractDateTimeHour:341 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30076: invalid extract field for extract source
https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 1784900706 SELECT EXTRACT(HOUR FROM t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} [code=30076, state=99999] FailedObject: SELECT EXTRACT(HOUR FROM d.tsData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractDateTimeMinute:366 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 1304579464 SELECT EXTRACT(MINUTE FROM t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} [code=30076, state=99999] FailedObject: SELECT EXTRACT(MINUTE FROM d.tsData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractDateTimeQuarter:266 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal store error> org.apache.openjpa.persistence.OptimisticLockException: Unable to obtain an object lock on "null". FailedObject: SELECT EXTRACT(QUARTER FROM d.tsData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractDateTimeSecond:391 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 1287915666 SELECT EXTRACT(SECOND FROM t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} [code=30076, state=99999] FailedObject: SELECT EXTRACT(SECOND FROM d.tsData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractTimeHour:166 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 2034320003 SELECT EXTRACT(HOUR FROM t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} [code=30076, state=99999] FailedObject: SELECT EXTRACT(HOUR FROM d.timeData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractTimeMinute:191 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 2071512077 SELECT EXTRACT(MINUTE FROM t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} [code=30076, state=99999] FailedObject: SELECT EXTRACT(MINUTE FROM d.timeData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client4.testExtractTimeSecond:216 <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 981442300 SELECT EXTRACT(SECOND FROM t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} [code=30076, state=99999] FailedObject: SELECT EXTRACT(SECOND FROM d.timeData) FROM DataTypes2 d WHERE d.id = :id [java.lang.String] [ERROR] Client1.propertyTypeTest1:111 propertyTypeTest1 failed [ERROR] Client1.propertyTypeTest10:611 propertyTypeTest10 failed [ERROR] Client1.propertyTypeTest11:668 propertyTypeTest11 failed [ERROR] Client1.propertyTypeTest12:725 propertyTypeTest12 failed [ERROR] Client1.propertyTypeTest13:776 propertyTypeTest13 failed [ERROR] Client1.propertyTypeTest2:163 propertyTypeTest2 failed [ERROR] Client1.propertyTypeTest3:213 propertyTypeTest3 failed [ERROR] Client1.propertyTypeTest4:264 propertyTypeTest4 failed [ERROR] Client1.propertyTypeTest5:315 propertyTypeTest5 failed [ERROR] Client1.propertyTypeTest6:367 propertyTypeTest6 failed [ERROR] Client1.propertyTypeTest7:428 propertyTypeTest7 failed [ERROR] Client1.propertyTypeTest8:484 propertyTypeTest8 failed [ERROR] Client1.propertyTypeTest9:553 propertyTypeTest9 failed [ERROR] Client2.transientTest:98 transientTest failed [ERROR] Client1.persistBasicTest2:218 persistBasicTest2 failed [ERROR] Client1.persistBasicTest3:306 persistBasicTest3 failed [ERROR] Client1.persistBasicTest4:402 persistBasicTest4 failed [ERROR] Client2.BigDecimalOperandResultTypeTests:418 BigDecimalOperandResultTypeTests failed [ERROR] Client2.BigIntegerOperandResultTypeTests:482 BigIntegerOperandResultTypeTests failed [ERROR] Client2.DoubleOperandResultTypeTests:198 DoubleOperandResultTypeTests failed [ERROR] Client2.FloatOperandResultTypeTests:339 FloatOperandResultTypeTests failed [ERROR] Client2.LongOperandResultTypeTests:593 LongOperandResultTypeTests failed [ERROR] Client2.ShortOperandResultTypeTests:704 ShortOperandResultTypeTests failed [ERROR] Client5.currentTime:2658 » OptimisticLock Unable to obtain an object lock on "null". [ERROR] Client5.diffNumberExpTest:1737 ClassCast class java.math.BigDecimal cannot be cast to class java.lang.Integer (java.math.BigDecimal and java.lang.Integer are in module java.base of loader 'bootstrap') [ERROR] Client5.neg:1476 ClassCast class java.math.BigDecimal cannot be cast to class java.lang.Integer (java.math.BigDecimal and java.lang.Integer are in module java.base of loader 'bootstrap') [ERROR] Client5.sumNumExpTest:340 ClassCast class java.math.BigDecimal cannot be cast to class java.lang.Integer (java.math.BigDecimal and java.lang.Integer are in module java.base of loader 'bootstrap') [ERROR] Client9.testExtractHourFromTime:813 » Persistence ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 561027769 SELECT t0.id, t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(HOUR FROM t0.TIME_VAL))} [code=30076, state=99999] [ERROR] Client9.testExtractMinuteFromTime:859 » Persistence ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 1795709202 SELECT t0.id, t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(MINUTE FROM t0.TIME_VAL))} [code=30076, state=99999] [ERROR] Client9.testExtractQuarterFromDate:1090 » OptimisticLock Unable to obtain an object lock on "null". [ERROR] Client9.testExtractSecondFromTime:906 » Persistence ORA-30076: invalid extract field for extract source https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 665883750 SELECT t0.id, t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(SECOND FROM t0.TIME_VAL))} [code=30076, state=99999] [ERROR] Client9.testExtractWeekFromDate:1138 » OptimisticLock Unable to obtain an object lock on "null". [ERROR] Client5.BigDecimalOperandResultTypeTests:540 BigDecimalOperandResultTypeTests failed [ERROR] Client5.BigIntegerOperandResultTypeTests:623 BigIntegerOperandResultTypeTests failed [ERROR] Client5.DoubleOperandResultTypeTests:250 DoubleOperandResultTypeTests failed [ERROR] Client5.FloatOperandResultTypeTests:436 FloatOperandResultTypeTests failed [ERROR] Client5.LongOperandResultTypeTests:769 LongOperandResultTypeTests failed [ERROR] Client5.ShortOperandResultTypeTests:915 ShortOperandResultTypeTests failed [ERROR] Client3.createNamedStoredProcedureQueryStringTest:406 » Rollback Procedure [GetEmpIdFNameLNameFromRS] not found [ERROR] Client3.createStoredProcedureQueryStringClassArrayTest:305 » Rollback Procedure [GetEmpASCFromRS] not found [ERROR] Client3.createStoredProcedureQueryStringStringArrayTest:356 » Rollback Procedure [GetEmpIdFNameLNameFromRS] not found [ERROR] Client3.createStoredProcedureQueryStringTest:258 » Rollback Procedure [GetEmpOneFirstNameFromOut] not found [ERROR] Client.persistBasicTest2:222 persistBasicTest2 failed [ERROR] Client.persistBasicTest3:310 persistBasicTest3 failed [ERROR] Client.persistBasicTest4:406 persistBasicTest4 failed [ERROR] Client.persistBasicTest5:504 persistBasicTest5 failed [ERROR] Client.persistBasicTest2:222 persistBasicTest2 failed [ERROR] Client.persistBasicTest3:309 persistBasicTest3 failed [ERROR] Client.persistBasicTest4:405 persistBasicTest4 failed [ERROR] Client.persistBasicTest5:503 persistBasicTest5 failed [ERROR] Client.cascadeAllMX1Test2:200 cascadeAllMX1Test2 failed [ERROR] Client.persistMX1Test2:205 persistMX1Test2 failed [ERROR] Client1.setParameterIntCalendarTemporalTypeTest:2188 setParameterIntCalendarTemporalTypeTest failed [ERROR] Client1.setParameterParameterCalendarTemporalTypeTest:2410 setParameterParameterCalendarTemporalTypeTest failed [ERROR] Client1.setParameterStringCalendarTemporalTypeTest:1753 setParameterStringCalendarTemporalTypeTest failed [ERROR] Client.autoTypeTest1:151 autoTypeTest1 failed [ERROR] Client.autoTypeTest2:212 autoTypeTest2 failed [ERROR] Client.autoTypeTest3:273 autoTypeTest3 failed [ERROR] Client.autoTypeTest4:334 autoTypeTest4 failed [ERROR] Client.autoTypeTest5:395 autoTypeTest5 failed [ERROR] Client.autoTypeTest6:456 autoTypeTest6 failed [ERROR] Client.dateTimeTest:242 dateTimeTest (Jakarta Persistence Java 8 date and time types test) failed [ERROR] Client.fieldTypeTest1:119 fieldTypeTest1 failed [ERROR] Client.fieldTypeTest10:592 fieldTypeTest10 failed [ERROR] Client.fieldTypeTest11:660 fieldTypeTest11 failed [ERROR] Client.fieldTypeTest12:717 fieldTypeTest12 failed [ERROR] Client.fieldTypeTest13:773 fieldTypeTest13 failed [ERROR] Client.fieldTypeTest14:829 fieldTypeTest14 failed [ERROR] Client.fieldTypeTest15:892 fieldTypeTest15 failed [ERROR] Client.fieldTypeTest16:955 fieldTypeTest16 failed [ERROR] Client.fieldTypeTest17:1021 fieldTypeTest17 failed [ERROR] Client.fieldTypeTest2:170 fieldTypeTest2 failed [ERROR] Client.fieldTypeTest3:221 fieldTypeTest3 failed [ERROR] Client.fieldTypeTest4:272 fieldTypeTest4 failed [ERROR] Client.fieldTypeTest5:322 fieldTypeTest5 failed [ERROR] Client.fieldTypeTest6:373 fieldTypeTest6 failed [ERROR] Client.fieldTypeTest7:423 fieldTypeTest7 failed [ERROR] Client.fieldTypeTest8:480 fieldTypeTest8 failed [ERROR] Client.fieldTypeTest9:537 fieldTypeTest9 failed [ERROR] Client.scalarExpressionsTest:1210 scalarExpressionsTest failed [ERROR] Client1.generatorTypeTest1:147 generatorTypeTest1 failed [ERROR] Client1.generatorTypeTest2:202 generatorTypeTest2 failed [ERROR] Client1.generatorTypeTest3:256 generatorTypeTest3 failed [ERROR] Client1.generatorTypeTest4:312 generatorTypeTest4 failed [ERROR] Client1.generatorTypeTest5:367 generatorTypeTest5 failed [ERROR] Client1.generatorTypeTest6:422 generatorTypeTest6 failed [ERROR] Client2.generatorTypeSequenceTest:142 generatorTypeSequenceTest failed [ERROR] Client1.propertyTypeTest1:123 propertyTypeTest1 failed [ERROR] Client1.propertyTypeTest10:626 propertyTypeTest10 failed [ERROR] Client1.propertyTypeTest11:683 propertyTypeTest11 failed [ERROR] Client1.propertyTypeTest12:740 propertyTypeTest12 failed [ERROR] Client1.propertyTypeTest2:175 propertyTypeTest2 failed [ERROR] Client1.propertyTypeTest3:226 propertyTypeTest3 failed [ERROR] Client1.propertyTypeTest4:278 propertyTypeTest4 failed [ERROR] Client1.propertyTypeTest5:330 propertyTypeTest5 failed [ERROR] Client1.propertyTypeTest6:383 propertyTypeTest6 failed [ERROR] Client1.propertyTypeTest7:443 propertyTypeTest7 failed [ERROR] Client1.propertyTypeTest8:499 propertyTypeTest8 failed [ERROR] Client1.propertyTypeTest9:568 propertyTypeTest9 failed [ERROR] Client1.scalarExpressionsTest:893 scalarExpressionsTest failed [ERROR] Client.createNamedStoredProcedureQueryStringTest:288 » Rollback Procedure [GetEmpIdFNameLNameFromRS] not found [ERROR] Client.createStoredProcedureQueryStringClassArrayTest:185 » Rollback Procedure [GetEmpASCFromRS] not found [ERROR] Client.createStoredProcedureQueryStringStringArrayTest:238 » Rollback Procedure [GetEmpIdFNameLNameFromRS] not found [ERROR] Client.createStoredProcedureQueryStringTest:137 » Rollback Procedure [GetEmpOneFirstNameFromOut] not found [INFO] [ERROR] Tests run: 2134, Failures: 0, Errors: 171, Skipped: 4 On Wed, 28 Oct 2026 at 06:24, Maxim Solodovnik <[email protected]> wrote: > > Thanks a million Richard! > > I'll re-run and will add logs to correspondent issues > > from mobile (sorry for typos ;) > > > On Tue, Oct 27, 2026, 23:36 Richard Zowalla <[email protected]> wrote: >> >> Hi Maxim, >> >> thanks for running these. Doesn't look too bad overall, because most of the >> errors fall into a few groups. >> >> I have created some issues: >> >> https://issues.apache.org/jira/browse/OPENJPA-3028 (parent) >> >> - OPENJPA-3029 Derby: EXTRACT is not supported >> - OPENJPA-3030 Derby: LEFT and RIGHT are not supported >> - OPENJPA-3031 Derby: CAST(? AS VARCHAR) without a length >> - OPENJPA-3032 StoredProcedureQuery tests fail on Derby and SQL Server >> - OPENJPA-3033 Derby: basic type, generator and numeric result type tests >> fail >> - OPENJPA-3034 Tests failing on several databases: sequence generator, >> timestamp, scalar expressions, mixed access >> - OPENJPA-3035 MySQL: numeric operations return Long where Integer is >> expected >> - OPENJPA-3036 MySQL: bulk UPDATE with a subquery on the same table >> - OPENJPA-3037 MySQL: EXTRACT(WEEK) returns a different week >> - OPENJPA-3038 MySQL: mapping, order column and map key tests fail >> >> For the Derby stored procedure errors ("Procedure ... not found") I am not >> sure yet whether it is OpenJPA or the TCK setup for Derby. >> >> For 3033, 3034 and 3038 the output only says "failed". If you still have the >> TCK logs from these runs, that would help to find the cause. >> >> Gruß >> Richard >> >> > Am 27.10.2026 um 16:58 schrieb Maxim Solodovnik <[email protected]>: >> > >> > Surprising Derby result: >> > >> > [ERROR] Errors: >> > [ERROR] Client1.executeTest:192 executeTest failed >> > [ERROR] Client1.executeUpdateOfADeleteTest:1703 >> > executeUpdateOfADeleteTest failed >> > [ERROR] Client1.executeUpdateOfAnUpdateTest:1671 >> > executeUpdateOfAnUpdateTest failed >> > [ERROR] Client1.executeUpdateTransactionRequiredExceptionTest:1734 >> > executeUpdateTransactionRequiredExceptionTest failed >> > [ERROR] Client1.getFirstResultTest:424 getFirstResultTest failed >> > [ERROR] Client1.getLockModeIllegalStateExceptionTest:862 >> > getLockModeIllegalStateExceptionTest failed >> > [ERROR] Client1.getMaxResultsTest:479 getMaxResultsTest failed >> > [ERROR] >> > Client1.getOutputParameterValueIntIllegalArgumentExceptionTest:369 >> > getOutputParameterValueIntIllegalArgumentExceptionTest failed >> > [ERROR] Client1.getOutputParameterValueIntTest:297 >> > getOutputParameterValueIntTest failed >> > [ERROR] Client1.getParameterIntIllegalArgumentExceptionTest:1070 >> > getParameterIntIllegalArgumentExceptionTest failed >> > [ERROR] Client1.getParameterStringExceptionTest:1015 >> > getParameterStringExceptionTest failed >> > [ERROR] Client1.getParameterValueIntIllegalArgumentExceptionTest:2026 >> > getParameterValueIntIllegalArgumentExceptionTest failed >> > [ERROR] Client1.getParameterValueIntIllegalStateExceptionTest:2063 >> > getParameterValueIntIllegalStateExceptionTest failed >> > [ERROR] Client1.getParameterValueIntTest:1988 getParameterValueIntTest >> > failed >> > [ERROR] >> > Client1.getParameterValueParameterIllegalArgumentExceptionTest:1834 >> > getParameterValueParameterIllegalArgumentExceptionTest failed >> > [ERROR] Client1.getParameterValueParameterIllegalStateExceptionTest:1882 >> > getParameterValueParameterIllegalStateExceptionTest failed >> > [ERROR] Client1.getParameterValueParameterTest:1790 >> > getParameterValueParameterTest failed >> > [ERROR] Client1.getParametersTest:1339 getParametersTest failed >> > [ERROR] Client1.getSingleResultNoResultExceptionTest:664 >> > getSingleResultNoResultExceptionTest failed >> > [ERROR] Client1.getSingleResultNonUniqueResultExceptionTest:707 >> > getSingleResultNonUniqueResultExceptionTest failed >> > [ERROR] Client1.getSingleResultOrNullWithNullTest:620 >> > getSingleResultOrNullWithNullTest failed >> > [ERROR] Client1.getSingleResultOrNullWithValueTest:577 >> > getSingleResultOrNullWithValueTest failed >> > [ERROR] Client1.getSingleResultTest:528 getSingleResultTest failed >> > [ERROR] Client1.setGetParameterIntTest:913 setGetParameterIntTest failed >> > [ERROR] Client1.setHintStringObjectTest:2094 setHintStringObjectTest >> > failed >> > [ERROR] Client1.setLockModeIllegalStateExceptionTest:828 >> > setLockModeIllegalStateExceptionTest failed >> > [ERROR] >> > Client1.setParameterIntDateTemporalTypeIllegalArgumentExceptionTest:1477 >> > setParameterIntDateTemporalTypeIllegalArgumentExceptionTest failed >> > [ERROR] Client1.setParameterIntDateTemporalTypeTest:1424 >> > setParameterIntDateTemporalTypeTest failed >> > [ERROR] Client1.setParameterIntObjectIllegalArgumentExceptionTest:1292 >> > setParameterIntObjectIllegalArgumentExceptionTest failed >> > [ERROR] >> > Client1.setParameterParameterDateTemporalTypeIllegalArgumentExceptionTest:1638 >> > setParameterParameterDateTemporalTypeIllegalArgumentExceptionTest >> > failed >> > [ERROR] Client1.setParameterParameterDateTemporalTypeTest:1579 >> > setParameterParameterDateTemporalTypeTest failed >> > [ERROR] >> > Client1.setParameterParameterObjectIllegalArgumentExceptionTest:1207 >> > setParameterParameterObjectIllegalArgumentExceptionTest failed >> > [ERROR] Client1.setParameterParameterObjectTest:1160 >> > setParameterParameterObjectTest failed >> > [ERROR] Client1.setgetFlushModeTest:794 setgetFlushModeTest failed >> > [ERROR] Client1.xmlOverridesNamedStoredProcedureQueryTest:2151 >> > xmlOverridesNamedStoredProcedureQueryTest failed >> > [ERROR] Client1.xmlOverridesSqlResultSetMappingAnnotationTest:2206 >> > xmlOverridesSqlResultSetMappingAnnotationTest failed >> > [ERROR] >> > Client2.setParameterIntCalendarTemporalTypeIllegalArgumentExceptionTest:325 >> > setParameterIntCalendarTemporalTypeIllegalArgumentExceptionTest >> > failed >> > [ERROR] Client2.setParameterIntCalendarTemporalTypeTest:273 >> > setParameterIntCalendarTemporalTypeTest failed >> > [ERROR] >> > Client2.setParameterParameterCalendarTemporalTypeIllegalArgumentExceptionTest:484 >> > setParameterParameterCalendarTemporalTypeIllegalArgumentExceptionTest >> > failed >> > [ERROR] Client2.setParameterParameterCalendarTemporalTypeTest:424 >> > setParameterParameterCalendarTemporalTypeTest failed >> > [ERROR] Client1.fieldTypeTest1:98 fieldTypeTest1 failed >> > [ERROR] Client1.fieldTypeTest10:574 fieldTypeTest10 failed >> > [ERROR] Client1.fieldTypeTest11:643 fieldTypeTest11 failed >> > [ERROR] Client1.fieldTypeTest12:701 fieldTypeTest12 failed >> > [ERROR] Client1.fieldTypeTest13:757 fieldTypeTest13 failed >> > [ERROR] Client1.fieldTypeTest14:813 fieldTypeTest14 failed >> > [ERROR] Client1.fieldTypeTest15:874 fieldTypeTest15 failed >> > [ERROR] Client1.fieldTypeTest16:934 fieldTypeTest16 failed >> > [ERROR] Client1.fieldTypeTest17:999 fieldTypeTest17 failed >> > [ERROR] Client1.fieldTypeTest2:150 fieldTypeTest2 failed >> > [ERROR] Client1.fieldTypeTest3:201 fieldTypeTest3 failed >> > [ERROR] Client1.fieldTypeTest4:252 fieldTypeTest4 failed >> > [ERROR] Client1.fieldTypeTest5:302 fieldTypeTest5 failed >> > [ERROR] Client1.fieldTypeTest6:353 fieldTypeTest6 failed >> > [ERROR] Client1.fieldTypeTest7:403 fieldTypeTest7 failed >> > [ERROR] Client1.fieldTypeTest8:462 fieldTypeTest8 failed >> > [ERROR] Client1.fieldTypeTest9:519 fieldTypeTest9 failed >> > [ERROR] Client2.mixedAccessTest:113 mixedAccessTest failed >> > [ERROR] Client3.transientTest:119 transientTest failed >> > [ERROR] Client4.testExtractDateDay:141 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "FROM" at line 1, column 20 {SELECT EXTRACT(DAY FROM >> > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(DAY FROM d.id) FROM DataTypes2 d WHERE >> > d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateMonth:116 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "FROM" at line 1, column 22 {SELECT EXTRACT(MONTH FROM >> > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(MONTH FROM d.id) FROM DataTypes2 d WHERE >> > d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateQuarter:91 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "FROM" at line 1, column 24 {SELECT EXTRACT(QUARTER FROM >> > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(QUARTER FROM d.id) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeDay:316 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "FROM" at line 1, column 20 {SELECT EXTRACT(DAY FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(DAY FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeHour:341 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "HOUR" at line 1, column 16 {SELECT EXTRACT(HOUR FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(HOUR FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeMinute:366 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "MINUTE" at line 1, column 16 {SELECT EXTRACT(MINUTE FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(MINUTE FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeMonth:291 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "FROM" at line 1, column 22 {SELECT EXTRACT(MONTH FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(MONTH FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeQuarter:266 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "FROM" at line 1, column 24 {SELECT EXTRACT(QUARTER FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(QUARTER FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeSecond:391 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "SECOND" at line 1, column 16 {SELECT EXTRACT(SECOND FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(SECOND FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateTimeYear:241 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "YEAR" at line 1, column 16 {SELECT EXTRACT(YEAR FROM >> > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(YEAR FROM d.tsData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractDateYear:66 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "YEAR" at line 1, column 16 {SELECT EXTRACT(YEAR FROM >> > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(YEAR FROM d.id) FROM DataTypes2 d WHERE >> > d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractTimeHour:166 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "HOUR" at line 1, column 16 {SELECT EXTRACT(HOUR FROM >> > t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(HOUR FROM d.timeData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractTimeMinute:191 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "MINUTE" at line 1, column 16 {SELECT EXTRACT(MINUTE FROM >> > t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(MINUTE FROM d.timeData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client4.testExtractTimeSecond:216 >> > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> >> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] >> > Encountered "SECOND" at line 1, column 16 {SELECT EXTRACT(SECOND FROM >> > t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} >> > [code=30000, state=42X01] >> > FailedObject: SELECT EXTRACT(SECOND FROM d.timeData) FROM DataTypes2 d >> > WHERE d.id = :id [java.lang.String] >> > [ERROR] Client1.propertyTypeTest1:111 propertyTypeTest1 failed >> > [ERROR] Client1.propertyTypeTest10:611 propertyTypeTest10 failed >> > [ERROR] Client1.propertyTypeTest11:668 propertyTypeTest11 failed >> > [ERROR] Client1.propertyTypeTest12:725 propertyTypeTest12 failed >> > [ERROR] Client1.propertyTypeTest13:776 propertyTypeTest13 failed >> > [ERROR] Client1.propertyTypeTest2:163 propertyTypeTest2 failed >> > [ERROR] Client1.propertyTypeTest3:213 propertyTypeTest3 failed >> > [ERROR] Client1.propertyTypeTest4:264 propertyTypeTest4 failed >> > [ERROR] Client1.propertyTypeTest5:315 propertyTypeTest5 failed >> > [ERROR] Client1.propertyTypeTest6:367 propertyTypeTest6 failed >> > [ERROR] Client1.propertyTypeTest7:428 propertyTypeTest7 failed >> > [ERROR] Client1.propertyTypeTest8:484 propertyTypeTest8 failed >> > [ERROR] Client1.propertyTypeTest9:553 propertyTypeTest9 failed >> > [ERROR] Client2.transientTest:98 transientTest failed >> > [ERROR] Client1.persistBasicTest2:218 persistBasicTest2 failed >> > [ERROR] Client1.persistBasicTest3:306 persistBasicTest3 failed >> > [ERROR] Client1.persistBasicTest4:402 persistBasicTest4 failed >> > [ERROR] Client2.BigDecimalOperandResultTypeTests:418 >> > BigDecimalOperandResultTypeTests failed >> > [ERROR] Client2.BigIntegerOperandResultTypeTests:482 >> > BigIntegerOperandResultTypeTests failed >> > [ERROR] Client2.DoubleOperandResultTypeTests:198 >> > DoubleOperandResultTypeTests failed >> > [ERROR] Client2.FloatOperandResultTypeTests:339 >> > FloatOperandResultTypeTests failed >> > [ERROR] Client2.LongOperandResultTypeTests:593 >> > LongOperandResultTypeTests failed >> > [ERROR] Client2.ShortOperandResultTypeTests:704 >> > ShortOperandResultTypeTests failed >> > [ERROR] Client9.testExtractDayFromDate:1044 » Persistence 42X01 : >> > [0] Encountered "FROM" at line 1, column 131 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(DAY FROM t0.DATE_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testExtractHourFromTime:813 » Persistence 42X01 : >> > [0] Encountered "HOUR" at line 1, column 127 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(HOUR FROM t0.TIME_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testExtractMinuteFromTime:859 » Persistence 42X01 : >> > [0] Encountered "MINUTE" at line 1, column 127 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(MINUTE FROM t0.TIME_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testExtractMonthFromDate:998 » Persistence 42X01 : >> > [0] Encountered "FROM" at line 1, column 133 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(MONTH FROM t0.DATE_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testExtractQuarterFromDate:1090 » Persistence 42X01 >> > : [0] Encountered "FROM" at line 1, column 135 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(QUARTER FROM t0.DATE_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testExtractSecondFromTime:906 » Persistence 42X01 : >> > [0] Encountered "SECOND" at line 1, column 146 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (CAST(? AS REAL) = CAST(EXTRACT(SECOND >> > FROM t0.TIME_VAL) AS REAL))} [code=30000, state=42X01] >> > [ERROR] Client9.testExtractWeekFromDate:1138 » Persistence 42X01 : >> > [0] Encountered "FROM" at line 1, column 132 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(WEEK FROM t0.DATE_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testExtractYearFromDate:952 » Persistence 42X01 : >> > [0] Encountered "YEAR" at line 1, column 127 {SELECT t0.id, >> > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(YEAR FROM t0.DATE_VAL))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testLeftExprLen:493 » Persistence 42X01 : [0] >> > Encountered "LEFT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, >> > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = LEFT(?, 4))} [code=30000, >> > state=42X01] >> > [ERROR] Client9.testLeftIntLen:448 » Persistence 42X01 : [0] >> > Encountered "LEFT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, >> > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = LEFT(?, 4))} [code=30000, >> > state=42X01] >> > [ERROR] Client9.testRightExprLen:583 » Persistence 42X01 : [0] >> > Encountered "RIGHT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, >> > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = RIGHT(?, 5))} >> > [code=30000, state=42X01] >> > [ERROR] Client9.testRightIntLen:538 » Persistence 42X01 : [0] >> > Encountered "RIGHT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, >> > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM >> > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = RIGHT(?, 5))} >> > [code=30000, state=42X01] >> > [ERROR] Client5.BigDecimalOperandResultTypeTests:540 >> > BigDecimalOperandResultTypeTests failed >> > [ERROR] Client5.BigIntegerOperandResultTypeTests:623 >> > BigIntegerOperandResultTypeTests failed >> > [ERROR] Client5.DoubleOperandResultTypeTests:250 >> > DoubleOperandResultTypeTests failed >> > [ERROR] Client5.FloatOperandResultTypeTests:436 >> > FloatOperandResultTypeTests failed >> > [ERROR] Client5.LongOperandResultTypeTests:769 >> > LongOperandResultTypeTests failed >> > [ERROR] Client5.ShortOperandResultTypeTests:915 >> > ShortOperandResultTypeTests failed >> > [ERROR] Client2.parameterExpressionInCollectionTest:244 » >> > Persistence 42X01 : [0] Encountered ")" at line 1, column 107 {SELECT >> > t0.ID, t0.FIRSTNAME, t0.HIREDATE, t0.LASTNAME, t0.SALARY FROM EMPLOYEE >> > t0 WHERE ((CAST(? AS VARCHAR) = CAST(? AS VARCHAR) OR CAST(? AS >> > VARCHAR) = CAST(? AS VARCHAR)) AND 1 = 1)} [code=30000, state=42X01] >> > [ERROR] Client2.parameterExpressionInExpressionArrayTest:174 » >> > Persistence 42X01 : [0] Encountered ")" at line 1, column 107 {SELECT >> > t0.ID, t0.FIRSTNAME, t0.HIREDATE, t0.LASTNAME, t0.SALARY FROM EMPLOYEE >> > t0 WHERE ((CAST(? AS VARCHAR) = CAST(? AS VARCHAR) OR CAST(? AS >> > VARCHAR) = CAST(? AS VARCHAR)) AND 1 = 1)} [code=30000, state=42X01] >> > [ERROR] Client2.parameterExpressionInExpressionTest:312 » >> > Persistence 42X01 : [0] Encountered ")" at line 1, column 106 {SELECT >> > t0.ID, t0.FIRSTNAME, t0.HIREDATE, t0.LASTNAME, t0.SALARY FROM EMPLOYEE >> > t0 WHERE (CAST(? AS VARCHAR) = CAST(? AS VARCHAR) AND 1 = 1)} >> > [code=30000, state=42X01] >> > [ERROR] Client3.createNamedStoredProcedureQueryStringTest:406 » >> > Rollback Procedure [GetEmpIdFNameLNameFromRS] not found >> > [ERROR] Client3.createStoredProcedureQueryStringClassArrayTest:305 » >> > Rollback Procedure [GetEmpASCFromRS] not found >> > [ERROR] Client3.createStoredProcedureQueryStringStringArrayTest:356 >> > » Rollback Procedure [GetEmpIdFNameLNameFromRS] not found >> > [ERROR] Client3.createStoredProcedureQueryStringTest:258 » Rollback >> > Procedure [GetEmpOneFirstNameFromOut] not found >> > [ERROR] Client.persistBasicTest2:222 persistBasicTest2 failed >> > [ERROR] Client.persistBasicTest3:310 persistBasicTest3 failed >> > [ERROR] Client.persistBasicTest4:406 persistBasicTest4 failed >> > [ERROR] Client.persistBasicTest5:504 persistBasicTest5 failed >> > [ERROR] Client.persistBasicTest2:222 persistBasicTest2 failed >> > [ERROR] Client.persistBasicTest3:309 persistBasicTest3 failed >> > [ERROR] Client.persistBasicTest4:405 persistBasicTest4 failed >> > [ERROR] Client.persistBasicTest5:503 persistBasicTest5 failed >> > [ERROR] Client.cascadeAllMX1Test2:200 cascadeAllMX1Test2 failed >> > [ERROR] Client.persistMX1Test2:205 persistMX1Test2 failed >> > [ERROR] Client3.test_leftStringExpression:972 >> > test_leftStringExpression failed >> > [ERROR] Client3.test_rightStringExpression:1003 >> > test_rightStringExpression failed >> > [ERROR] Client.autoTypeTest1:151 autoTypeTest1 failed >> > [ERROR] Client.autoTypeTest2:212 autoTypeTest2 failed >> > [ERROR] Client.autoTypeTest3:273 autoTypeTest3 failed >> > [ERROR] Client.autoTypeTest4:334 autoTypeTest4 failed >> > [ERROR] Client.autoTypeTest5:395 autoTypeTest5 failed >> > [ERROR] Client.autoTypeTest6:456 autoTypeTest6 failed >> > [ERROR] Client.dateTimeTest:242 dateTimeTest (Jakarta Persistence >> > Java 8 date and time types test) failed >> > [ERROR] Client.fieldTypeTest1:119 fieldTypeTest1 failed >> > [ERROR] Client.fieldTypeTest10:592 fieldTypeTest10 failed >> > [ERROR] Client.fieldTypeTest11:660 fieldTypeTest11 failed >> > [ERROR] Client.fieldTypeTest12:717 fieldTypeTest12 failed >> > [ERROR] Client.fieldTypeTest13:773 fieldTypeTest13 failed >> > [ERROR] Client.fieldTypeTest14:829 fieldTypeTest14 failed >> > [ERROR] Client.fieldTypeTest15:892 fieldTypeTest15 failed >> > [ERROR] Client.fieldTypeTest16:955 fieldTypeTest16 failed >> > [ERROR] Client.fieldTypeTest17:1021 fieldTypeTest17 failed >> > [ERROR] Client.fieldTypeTest2:170 fieldTypeTest2 failed >> > [ERROR] Client.fieldTypeTest3:221 fieldTypeTest3 failed >> > [ERROR] Client.fieldTypeTest4:272 fieldTypeTest4 failed >> > [ERROR] Client.fieldTypeTest5:322 fieldTypeTest5 failed >> > [ERROR] Client.fieldTypeTest6:373 fieldTypeTest6 failed >> > [ERROR] Client.fieldTypeTest7:423 fieldTypeTest7 failed >> > [ERROR] Client.fieldTypeTest8:480 fieldTypeTest8 failed >> > [ERROR] Client.fieldTypeTest9:537 fieldTypeTest9 failed >> > [ERROR] Client.scalarExpressionsTest:1210 scalarExpressionsTest failed >> > [ERROR] Client1.generatorTypeTest1:147 generatorTypeTest1 failed >> > [ERROR] Client1.generatorTypeTest2:202 generatorTypeTest2 failed >> > [ERROR] Client1.generatorTypeTest3:256 generatorTypeTest3 failed >> > [ERROR] Client1.generatorTypeTest4:312 generatorTypeTest4 failed >> > [ERROR] Client1.generatorTypeTest5:367 generatorTypeTest5 failed >> > [ERROR] Client1.generatorTypeTest6:422 generatorTypeTest6 failed >> > [ERROR] Client2.generatorTypeSequenceTest:142 >> > generatorTypeSequenceTest failed >> > [ERROR] Client1.propertyTypeTest1:123 propertyTypeTest1 failed >> > [ERROR] Client1.propertyTypeTest10:626 propertyTypeTest10 failed >> > [ERROR] Client1.propertyTypeTest11:683 propertyTypeTest11 failed >> > [ERROR] Client1.propertyTypeTest12:740 propertyTypeTest12 failed >> > [ERROR] Client1.propertyTypeTest2:175 propertyTypeTest2 failed >> > [ERROR] Client1.propertyTypeTest3:226 propertyTypeTest3 failed >> > [ERROR] Client1.propertyTypeTest4:278 propertyTypeTest4 failed >> > [ERROR] Client1.propertyTypeTest5:330 propertyTypeTest5 failed >> > [ERROR] Client1.propertyTypeTest6:383 propertyTypeTest6 failed >> > [ERROR] Client1.propertyTypeTest7:443 propertyTypeTest7 failed >> > [ERROR] Client1.propertyTypeTest8:499 propertyTypeTest8 failed >> > [ERROR] Client1.propertyTypeTest9:568 propertyTypeTest9 failed >> > [ERROR] Client1.scalarExpressionsTest:893 scalarExpressionsTest failed >> > [ERROR] Client.createNamedStoredProcedureQueryStringTest:288 » >> > Rollback Procedure [GetEmpIdFNameLNameFromRS] not found >> > [ERROR] Client.createStoredProcedureQueryStringClassArrayTest:185 » >> > Rollback Procedure [GetEmpASCFromRS] not found >> > [ERROR] Client.createStoredProcedureQueryStringStringArrayTest:238 » >> > Rollback Procedure [GetEmpIdFNameLNameFromRS] not found >> > [ERROR] Client.createStoredProcedureQueryStringTest:137 » Rollback >> > Procedure [GetEmpOneFirstNameFromOut] not found >> > [ERROR] Client.sequenceGeneratorTest:226 sequenceGeneratorTest failed >> > [ERROR] Client.sequenceGeneratorTest:229 sequenceGeneratorTest failed >> > [INFO] >> > [ERROR] Tests run: 2134, Failures: 0, Errors: 184, Skipped: 4 >> > >> > On Tue, 27 Oct 2026 at 21:29, Maxim Solodovnik <[email protected]> >> > wrote: >> >> >> >> Here are fresh TCK results: >> >> >> >> postgresql:16 - PASSED >> >> mysql:8.4.8 - FAILED [1] >> >> mssql:2017-CU12-ubuntu - FAILED [2] >> >> >> >> NOTE: TCK build is NOT working with fresh Maven 3.10.0, 3.9.16 works >> >> as expected :) >> >> >> >> ------------------------------------------------------------------- >> >> [1] mysql:8.4.8 Errors: >> >> >> >> [ERROR] Errors: >> >> [ERROR] Client.associationOverride:109 test2 failed >> >> [ERROR] Client.mapKeyClass:111 mapKeyClass Failed >> >> [ERROR] Client.mapKeyJoinColumn:108 mapKeyJoinColumn Failed >> >> [ERROR] Client1.orderByTest1:156 orderByTest1 failed >> >> [ERROR] Client1.orderByTest2:237 orderByTest2 failed >> >> [ERROR] Client1.orderByTest3:315 orderByTest3 failed >> >> [ERROR] Client1.orderByTest4:391 orderByTest4 failed >> >> [ERROR] Client1.orderColumn:137 orderColumn test failed >> >> [ERROR] Client4.timestampFieldTest:112 timestampFieldTest failed >> >> [ERROR] Client4.timestampPropertyTest:168 timestampPropertyTest failed >> >> [ERROR] Client5.diffNumberExpTest:1737 ClassCast class >> >> java.lang.Long cannot be cast to class java.lang.Integer >> >> (java.lang.Long and java.lang.Integer are in module java.base of >> >> loader 'bootstrap') >> >> [ERROR] Client5.neg:1476 ClassCast class java.lang.Long cannot be >> >> cast to class java.lang.Integer (java.lang.Long and java.lang.Integer >> >> are in module java.base of loader 'bootstrap') >> >> [ERROR] Client5.sumNumExpTest:340 ClassCast class java.lang.Long >> >> cannot be cast to class java.lang.Integer (java.lang.Long and >> >> java.lang.Integer are in module java.base of loader 'bootstrap') >> >> [ERROR] Client9.testExtractWeekFromDate:1146 » IndexOutOfBounds >> >> Index 0 out of bounds for length 0 >> >> [ERROR] Client.subquery:715 » Persistence You can't specify target >> >> table 't0' for update in FROM clause {prepstmnt 729429705 UPDATE >> >> PRODUCT_TABLE t0 INNER JOIN PRODUCT_DETAILS t2 ON t0.ID = t2.ID SET >> >> t0.QUANTITY = (t0.QUANTITY * ?) WHERE (EXISTS (SELECT t1.ID FROM >> >> PRODUCT_TABLE t1 WHERE (t0.ID = ?)))} [code=1093, state=HY000] >> >> [ERROR] Client.DIDTest:124 DIDTest failed >> >> [ERROR] Client.test1:122 test1 failed >> >> [ERROR] Client1.setParameterParameterCalendarTemporalTypeTest:2410 >> >> setParameterParameterCalendarTemporalTypeTest failed >> >> [ERROR] Client.annotationMappingTest1:142 annotationMappingTest1 failed >> >> [ERROR] Client.annotationMappingTest3:436 annotationMappingTest3 failed >> >> [ERROR] Client.annotationMappingTest4:509 annotationMappingTest4 failed >> >> [ERROR] Client.annotationMappingTest5:589 annotationMappingTest5 failed >> >> [ERROR] Client.annotationMappingTest6:749 annotationMappingTest6 failed >> >> [ERROR] Client.annotationMappingTest7:958 annotationMappingTest7 failed >> >> [ERROR] Client.annotationMappingTest8:1104 annotationMappingTest8 >> >> failed >> >> [ERROR] Client.biDirMXMTest1:172 biDirMXMTest1 failed >> >> [ERROR] Client.mappingTest1:139 mappingTest1 failed >> >> [ERROR] Client.mappingTest2:273 mappingTest2 failed >> >> [ERROR] Client.mappingTest3:366 mappingTest3 failed >> >> [ERROR] Client.mappingTest4:437 mappingTest4 failed >> >> [ERROR] Client.mappingTest5:516 mappingTest5 failed >> >> [ERROR] Client.mappingTest6:669 mappingTest6 failed >> >> [ERROR] Client.mappingTest7:876 mappingTest7 failed >> >> [ERROR] Client.mappingTest8:1019 mappingTest8 failed >> >> [ERROR] Client.test1:118 test1 failed >> >> [ERROR] Client.didTest:128 DIDTest failed >> >> [ERROR] Client.mapKeyJoinColumnTest:101 mapKeyJoinColumn Failed >> >> [ERROR] Client.sequenceGeneratorTest:226 sequenceGeneratorTest failed >> >> [ERROR] Client.joinTableTest:335 joinTableTest failed >> >> [ERROR] Client.orderColumnTest:281 orderColumnTest failed >> >> [ERROR] Client.secondaryTableTest:237 secondaryTableTest failed >> >> [ERROR] Client.sequenceGeneratorTest:229 sequenceGeneratorTest failed >> >> [ERROR] Client.uniqueConstraintTest:221 uniqueConstraintTest failed >> >> [INFO] >> >> [ERROR] Tests run: 2134, Failures: 0, Errors: 43, Skipped: 4 >> >> ------------------------------------------------------------------- >> >> >> >> ------------------------------------------------------------------- >> >> [2] mssql:2017-CU12-ubuntu >> >> >> >> [ERROR] Errors: >> >> [ERROR] Client1.executeTest:192 executeTest failed >> >> [ERROR] Client1.executeUpdateOfADeleteTest:1703 >> >> executeUpdateOfADeleteTest failed >> >> [ERROR] Client1.executeUpdateOfAnUpdateTest:1671 >> >> executeUpdateOfAnUpdateTest failed >> >> [ERROR] Client1.getFirstResultTest:424 getFirstResultTest failed >> >> [ERROR] Client1.getMaxResultsTest:479 getMaxResultsTest failed >> >> [ERROR] >> >> Client1.getOutputParameterValueIntIllegalArgumentExceptionTest:369 >> >> getOutputParameterValueIntIllegalArgumentExceptionTest failed >> >> [ERROR] Client1.getOutputParameterValueIntTest:297 >> >> getOutputParameterValueIntTest failed >> >> [ERROR] Client1.getParameterValueIntTest:1988 getParameterValueIntTest >> >> failed >> >> [ERROR] Client1.getParameterValueParameterTest:1790 >> >> getParameterValueParameterTest failed >> >> [ERROR] Client1.getParametersTest:1339 getParametersTest failed >> >> [ERROR] Client1.getSingleResultNoResultExceptionTest:664 >> >> getSingleResultNoResultExceptionTest failed >> >> [ERROR] Client1.getSingleResultNonUniqueResultExceptionTest:707 >> >> getSingleResultNonUniqueResultExceptionTest failed >> >> [ERROR] Client1.getSingleResultOrNullWithNullTest:620 >> >> getSingleResultOrNullWithNullTest failed >> >> [ERROR] Client1.getSingleResultOrNullWithValueTest:577 >> >> getSingleResultOrNullWithValueTest failed >> >> [ERROR] Client1.getSingleResultTest:528 getSingleResultTest failed >> >> [ERROR] Client1.setHintStringObjectTest:2094 setHintStringObjectTest >> >> failed >> >> [ERROR] Client1.setParameterIntDateTemporalTypeTest:1424 >> >> setParameterIntDateTemporalTypeTest failed >> >> [ERROR] Client1.setParameterParameterDateTemporalTypeTest:1579 >> >> setParameterParameterDateTemporalTypeTest failed >> >> [ERROR] Client1.setParameterParameterObjectTest:1160 >> >> setParameterParameterObjectTest failed >> >> [ERROR] Client1.xmlOverridesNamedStoredProcedureQueryTest:2151 >> >> xmlOverridesNamedStoredProcedureQueryTest failed >> >> [ERROR] Client1.xmlOverridesSqlResultSetMappingAnnotationTest:2206 >> >> xmlOverridesSqlResultSetMappingAnnotationTest failed >> >> [ERROR] Client2.setParameterIntCalendarTemporalTypeTest:273 >> >> setParameterIntCalendarTemporalTypeTest failed >> >> [ERROR] Client2.setParameterParameterCalendarTemporalTypeTest:424 >> >> setParameterParameterCalendarTemporalTypeTest failed >> >> [ERROR] Client2.mixedAccessTest:113 mixedAccessTest failed >> >> [ERROR] Client3.transientTest:119 transientTest failed >> >> [ERROR] Client1.propertyTypeTest1:111 propertyTypeTest1 failed >> >> [ERROR] Client2.transientTest:98 transientTest failed >> >> [ERROR] Client4.timestampFieldTest:112 timestampFieldTest failed >> >> [ERROR] Client4.timestampPropertyTest:168 timestampPropertyTest failed >> >> [ERROR] Client3.createNamedStoredProcedureQueryStringTest:409 >> >> createNamedStoredProcedureQueryStringTest failed >> >> [ERROR] Client3.createStoredProcedureQueryStringClassArrayTest:308 >> >> createStoredProcedureQueryStringClassArrayTest failed >> >> [ERROR] Client3.createStoredProcedureQueryStringStringArrayTest:359 >> >> createStoredProcedureQueryStringStringArrayTest failed >> >> [ERROR] Client3.createStoredProcedureQueryStringTest:261 >> >> createStoredProcedureQueryStringTest failed >> >> [ERROR] Client.cascadeAllMX1Test2:200 cascadeAllMX1Test2 failed >> >> [ERROR] Client.persistMX1Test2:205 persistMX1Test2 failed >> >> [ERROR] Client1.setParameterParameterCalendarTemporalTypeTest:2410 >> >> setParameterParameterCalendarTemporalTypeTest failed >> >> [ERROR] Client.autoTypeTest1:151 autoTypeTest1 failed >> >> [ERROR] Client.scalarExpressionsTest:1210 scalarExpressionsTest failed >> >> [ERROR] Client1.scalarExpressionsTest:893 scalarExpressionsTest failed >> >> [ERROR] Client.createNamedStoredProcedureQueryStringTest:291 >> >> createNamedStoredProcedureQueryStringTest failed >> >> [ERROR] Client.createStoredProcedureQueryStringClassArrayTest:188 >> >> createStoredProcedureQueryStringClassArrayTest failed >> >> [ERROR] Client.createStoredProcedureQueryStringStringArrayTest:241 >> >> createStoredProcedureQueryStringStringArrayTest failed >> >> [ERROR] Client.createStoredProcedureQueryStringTest:140 >> >> createStoredProcedureQueryStringTest failed >> >> [ERROR] Client.sequenceGeneratorTest:226 sequenceGeneratorTest failed >> >> [ERROR] Client.sequenceGeneratorTest:229 sequenceGeneratorTest failed >> >> [INFO] >> >> [ERROR] Tests run: 2134, Failures: 0, Errors: 45, Skipped: 4 >> >> >> >> ------------------------------------------------------------------- >> >> >> >> >> >> On Tue, 27 Oct 2026 at 09:04, Maxim Solodovnik <[email protected]> >> >> wrote: >> >>> >> >>> (sorry for double post) >> >>> >> >>> I agree TCK shouldn't be green (as it is not green at 4.1.x :))) >> >>> I would like to check if it can be improved with some minor fixes :) >> >>> >> >>> BTW we need to check our site with next build, currently it looks too >> >>> old-school ... :) >> >>> Maybe I can add reflow-skin >> >>> https://devacfr.github.io/reflow-maven-skin/doc/reflow-documentation.html#doc-get-started >> >>> for ex.? >> >>> >> >>> On Tue, 27 Oct 2026 at 07:13, Maxim Solodovnik <[email protected]> >> >>> wrote: >> >>>> >> >>>> OpenMeetings is green :) >> >>>> The only issue was converted to OpenJPA test and you have fixed it :) >> >>>> >> >>>> from mobile (sorry for typos ;) >> >>>> >> >>>> >> >>>> On Tue, Oct 27, 2026, 01:35 Richard Zowalla <[email protected]> wrote: >> >>>>> >> >>>>> Hi, >> >>>>> >> >>>>> I think we can go with a M0 soonish. I don’t think that we need to >> >>>>> clear all TCK failures across all rdbms for a milestone release as >> >>>>> long as our own build and tests are fine / green. >> >>>>> >> >>>>> Did you test in your projects (syncope, open meetings) ? That would be >> >>>>> beneficial to spot any left overs. >> >>>>> >> >>>>> For TomEE it would be best to have some sort of stable version to ship >> >>>>> in a TomEE 11 milestone, but not much to test from a user point of >> >>>>> view in it. The projects above might be better candidates as >> >>>>> demonstrated by syncope ;) >> >>>>> >> >>>>> We are currently in the process of preparing the next one, but it >> >>>>> might take some additional time. >> >>>>> >> >>>>> Gruß >> >>>>> Richard >> >>>>> >> >>>>> >> >>>>> >> >>>>>> Am 26.10.2026 um 14:31 schrieb Francesco Chicchiriccò >> >>>>>> <[email protected]>: >> >>>>>> >> >>>>>> Thank you Maxim, hope at least the first milestone can see the light >> >>>>>> before end of year. >> >>>>>> >> >>>>>> Meanwhile: >> >>>>>> >> >>>>>> https://github.com/apache/syncope/pull/1582 >> >>>>>> >> >>>>>> Regards. >> >>>>>> >> >>>>>> On 26/10/26 11:16, Maxim Solodovnik wrote: >> >>>>>>> Hello Francesco, >> >>>>>>> >> >>>>>>> As I understand Richard going to test Tommee first :) >> >>>>>>> >> >>>>>>> I'll try to run TCK >> >>>>>>> There were ~10 errors/failures if I'm not mistaken >> >>>>>>> >> >>>>>>> And our "Databases" weekly job has failed at Postgress .... >> >>>>>>> >> >>>>>>> from mobile (sorry for typos ;) >> >>>>>>> >> >>>>>>> >> >>>>>>> On Mon, Oct 26, 2026, 17:06 Francesco Chicchiriccò >> >>>>>>> <[email protected]> >> >>>>>>> wrote: >> >>>>>>> >> >>>>>>>> Hi, >> >>>>>>>> I was wondering around when we believe we could release out the >> >>>>>>>> first 4.2 >> >>>>>>>> artifacts (4.2.0, 4.2.0-M0?) >> >>>>>>>> >> >>>>>>>> Regards. >> >>>>>> >> >>>>>> -- >> >>>>>> Francesco Chicchiriccò >> >>>>>> >> >>>>>> Tirasa - Open Source Excellence >> >>>>>> http://www.tirasa.net/ >> >>>>>> >> >>>>>> Member at The Apache Software Foundation >> >>>>>> Syncope, CXF, OpenJPA >> >>>>>> https://about.me/ilgrosso >> >>>>>> >> >>>>> >> >>> >> >>> >> >>> -- >> >>> Best regards, >> >>> Maxim >> >> >> >> >> >> >> >> -- >> >> Best regards, >> >> Maxim >> > >> > >> > >> > -- >> > Best regards, >> > Maxim >> > >> -- Best regards, Maxim
