[
https://issues.apache.org/jira/browse/OPENJPA-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18134663#comment-18134663
]
Maxim Solodovnik commented on OPENJPA-3028:
-------------------------------------------
h1. Recent results:
h2. Postgres:
PASSED
h2. Derby:
{code}
[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] Client9.testExtractWeekFromDate:1138 » Persistence The database
dictionary in use ("class org.apache.openjpa.jdbc.sql.DerbyDictionary") does
not support "EXTRACT(WEEK)" function.
[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.cascadeAllMX1Test2:200 cascadeAllMX1Test2 failed
[ERROR] Client.persistMX1Test2:205 persistMX1Test2 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: 53, Skipped: 4
{code}
h2. MSSQL:
{code}
[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] 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.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: 38, Skipped: 4
{code}
h2. MySql:
{code}
[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] 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: 38, Skipped: 4
{code}
h2. Oracle:
{code}
[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-r4f2c174
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-r4f2c174
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-r4f2c174 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 1631408038 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-r4f2c174 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-r4f2c174 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 314569117 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-r4f2c174
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 1220144707 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-r4f2c174
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 1849637057 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-r4f2c174
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 11618860 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] Client9.testExtractHourFromTime:813 » Persistence ORA-30076: invalid
extract field for extract source
https://docs.oracle.com/error-help/db/ora-30076/ {prepstmnt 1589721877 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 1810429736 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 988756116 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: 168, Skipped: 4
{code}
> Jakarta Persistence 3.2 TCK failures on Derby, MySQL and SQL Server
> -------------------------------------------------------------------
>
> Key: OPENJPA-3028
> URL: https://issues.apache.org/jira/browse/OPENJPA-3028
> Project: OpenJPA
> Issue Type: Epic
> Reporter: Richard Zowalla
> Assignee: Richard Zowalla
> Priority: Major
> Attachments: run_de.tar.xz, run_ms.tar.xz, run_my.tar.xz,
> run_or.tar.xz
>
>
> Results of the Jakarta Persistence 3.2 TCK with
> {{openjpa-integration/tck/run-tck32.sh}} (reported by Maxim Solodovnik on
> dev@):
> * PostgreSQL 16: passed
> * MySQL 8.4.8: 2134 tests, 43 errors
> * SQL Server 2017-CU12: 2134 tests, 45 errors
> * Derby: 2134 tests, 184 errors
> The sub-tasks group the errors by cause. Several groups show up on more than
> one database. Where the TCK output only says "<test> failed", the cause still
> has to be found from the TCK logs.
> Note: the TCK build does not work with Maven 3.10.0; 3.9.x works.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
