Huge +1 from me!

On 14/11/26 03:58, Maxim Solodovnik wrote:
All merged :)
Time to release?

from mobile (sorry for typos ;)


On Tue, Nov 10, 2026, 09:30 Maxim Solodovnik <[email protected]> wrote:

On Tue, 10 Nov 2026 at 00:59, Richard Zowalla via dev
<[email protected]> wrote:
Sounds good to me.
There is one open thing left (AFAIK), but afterwards we might be good to
go.
Do we want to use ATR? ;-)
I haven't tried it (yet)
So don't have opinion :))

Am 09.11.2026 um 13:47 schrieb Maxim Solodovnik <[email protected]
:
All builds are green for major databases and tck
Shall we update

https://github.com/apache/openjpa/blob/master/openjpa-project/RELEASE-NOTES.html
and release? :)

Or any tasks left unaddressed?

from mobile (sorry for typos ;)


On Thu, Nov 5, 2026, 17:51 Maxim Solodovnik <[email protected]>
wrote:
BTW are going to release 4.2.0 or 4.2.0-M1? :)

On Thu, 5 Nov 2026 at 13:30, Maxim Solodovnik <[email protected]>
wrote:
Issues with `testRightLongerThanString` and maybe some others
caused by the fact `SUBSTR()` returns `NULL` in case value longer
than
length was passed

this can be workarounded with `SELECT SUBSTR(t0.name,
LEAST(LENGTH(t0.name), 0, 10)) FROM CMN_COMPUSER t0; `
in OracleDrver
Would it be good solution?

On Wed, 4 Nov 2026 at 16:58, Maxim Solodovnik <[email protected]>
wrote:
Here are results for Oracle (I have manually disabled
TestTimeoutException.java and TestPessimisticLockException.java)

[ERROR] Failures:
[ERROR]
TestCharStorage>PersistenceTestCase.run:198->PersistenceTestCase.runBare:479->PersistenceTestCase.runBare:504->testCharFieldsInGeneratedSchema:56->assertColumnType:242
CHARSTORAGE.CHARDATA expected:<4> but was:<2>
[ERROR]
TestCharStorage>PersistenceTestCase.run:198->PersistenceTestCase.runBare:479->PersistenceTestCase.runBare:504->testExplicitStoreCharsAsNumbers:109->assertColumnType:242
CHARSTORAGE_NUM.CHARDATA expected:<4> but was:<2>
[ERROR]
TestTypesafeCriteria>AbstractCriteriaTestCase.runBare:462->AbstractCriteriaTestCase.runBareReleasingResources:486->testLeftAndRightWithParameters:1849
expected:<John Fitzgerald Doe> but was:<null>
[ERROR]
TestInMemoryJDBCEscapeLiterals>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testCaseAndNullIfInMemory:199
SELECT NULLIF(e.sqlDateField, {d '2021-01-03'}) FROM AllFieldTypes e
expected:<[2022-06-15 00:00:00.0, null]> but was:<[2022-06-15,
null]>
[ERROR]
TestEJBQLFunction>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testLeftAndRightOnStringParameter:462
expected:<1> but was:<0>
[ERROR]
TestEJBQLFunction>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testRightLongerThanString:436
expected:<Seetha> but was:<null>
[ERROR] Errors:
[ERROR]
TestBulkDeleteSharedCollectionTable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:36
» Persistence ORA-00902: invalid datatype
{stmnt 805719607 CREATE TABLE BULK_SHARED_COLL (OWNER_ID BIGINT,
DISC
VARCHAR(1), VAL VARCHAR2(255))} [code=902, state=42000]
[ERROR]
TestBulkDeleteSharedCollectionTable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:36
» Persistence ORA-00902: invalid datatype
{stmnt 916203766 CREATE TABLE BULK_SHARED_COLL (OWNER_ID BIGINT,
DISC
VARCHAR(1), VAL VARCHAR2(255))} [code=902, state=42000]
[INFO]
[ERROR] Tests run: 4035, Failures: 6, Errors: 2, Skipped: 0

On Wed, 4 Nov 2026 at 11:14, Maxim Solodovnik <[email protected]
wrote:
I'm running combined version at OPENJPA-3064 (rebased to last
master
and rebuilt)

Weird enough the only failing HSQLDB test right now is:

[ERROR] Failures:
[ERROR]
TestJava8TimeTypes>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testGetCurrentLocalTime:297
04:57:15 <= 10:43:36
[INFO]
[ERROR] Tests run: 4035, Failures: 1, Errors: 0, Skipped: 0

I'll add MS results to https://github.com/apache/openjpa/pull/265

Post Oracle results a bit later to this thread :)

On Tue, 3 Nov 2026 at 12:05, Maxim Solodovnik <
[email protected]>
wrote:
Hello All,

In addition to the failed "Databases" run
I've just run fresh SNAPSHOT against databases missing in this job
and
here are the results:

**HSQLDB**:

[ERROR] Failures:
[ERROR]
TestLobConverted>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testElementConvertedToBytesIsBlob:65
expected:<2004> but was:<-3>
[ERROR]
TestLobConverted>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testItemConvertedToStringIsClob:61
expected:<2005> but was:<12>
[ERROR]
TestLobConverted>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testListConvertedToStringIsClob:57
expected:<2005> but was:<12>
[ERROR]
TestLobConverted>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testLobsWithoutConverterAreUnchanged:82
expected:<2005> but was:<12>
[ERROR]
TestLobConverted>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testStringConvertedToBytesIsBlob:69
expected:<2004> but was:<-3>
[ERROR]
TestLobConvertedXml>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testItemConvertedToStringIsClob:61
expected:<2005> but was:<12>
[ERROR]
TestLobConvertedXml>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testListConvertedToStringIsClob:57
expected:<2005> but was:<12>
[ERROR]
TestLobConvertedXml>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testStringConvertedToBytesIsBlob:65
expected:<2004> but was:<-3>
[ERROR]
TestArithmeticResultType>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testJPQLProjection:129
value 5.00000000000000000000000000000000 expected:<0> but was:<1>
[ERROR]
TestArithmeticResultType>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testMixedOperands:97->assertDecimal:177
value 9.00000000000000000000000000000000 expected:<0> but was:<1>
[ERROR]
TestSelectionParameters>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testParameterInCaseOfSelect:177
expected:<[young, old]> but was:<[young, old  ]>
[ERROR]
TestDecimalScale>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testFractionIsComparedInQuery:91->assertDecimal:149
2.625 <> 2.50 expected:<0> but was:<1>
[ERROR]
TestDecimalScale>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testFractionIsKeptOnFind:63->assertDecimal:149
1234.5678 <> 1235 expected:<0> but was:<-1>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryMinusInMemory:173->assertDecimal:235
-25.5 <> -25 expected:<0> but was:<-1>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryMinusOnParameterInWhere:128
expected:<[2]> but was:<[]>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryMinusOnPath:54->assertDecimal:235
-25.5 <> -25.00000000000000000000000000000000 expected:<0> but
was:<-1>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryPlusOnPath:62->assertDecimal:235
25.5 <> 25 expected:<0> but was:<1>
[ERROR] Errors:
[ERROR]
TestEJBQLFunction>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testExtractSecondKeepsFractionFromTime:984
» Persistence data type cast needed for parameter or null literal
in
statement [SELECT EXTRACT(SECOND FROM ?) FROM CMN_COMPUSER t0
WHERE
(t0.age = ?)] {SELECT EXTRACT(SECOND FROM ?) FROM CMN_COMPUSER t0
WHERE (t0.age = ?)} [code=-5567, state=42567]
[ERROR]
TestEJBQLFunction>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testExtractSecondKeepsFractionFromTimestamp:964
» Persistence data type cast needed for parameter or null literal
in
statement [SELECT EXTRACT(SECOND FROM  TIMESTAMP '2006-03-21
18:19:23.5' ), EXTRACT(SECOND FROM ?) FROM CMN_COMPUSER t0 WHERE
(t0.age = ?)] {SELECT EXTRACT(SECOND FROM {ts '2006-03-21
18:19:23.5'}), EXTRACT(SECOND FROM ?) FROM CMN_COMPUSER t0 WHERE
(t0.age = ?)} [code=-5567, state=42567]
[ERROR]
TestExtractDateTimeField>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testCriteriaExtractFromLiteral:213
» Persistence data type cast needed for parameter or null literal
in
statement [SELECT t0.id FROM Java8TimeTypes t0 WHERE
(EXTRACT(YEAR
FROM t0.localDateField) = EXTRACT(YEAR FROM ?))] {SELECT t0.id
FROM
Java8TimeTypes t0 WHERE (EXTRACT(YEAR FROM t0.localDateField) =
EXTRACT(YEAR FROM ?))} [code=-5567, state=42567]
[ERROR]
TestExtractDateTimeField>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testExtractFromParameter:191
» Persistence data type cast needed for parameter or null literal
in
statement [SELECT t0.id FROM Java8TimeTypes t0 WHERE
(EXTRACT(YEAR
FROM t0.localDateField) = EXTRACT(YEAR FROM ?) AND EXTRACT(HOUR
FROM
t0.localDateTimeField) = EXTRACT(HOUR FROM ?))] {SELECT t0.id
FROM
Java8TimeTypes t0 WHERE (EXTRACT(YEAR FROM t0.localDateField) =
EXTRACT(YEAR FROM ?) AND EXTRACT(HOUR FROM t0.localDateTimeField)
=
EXTRACT(HOUR FROM ?))} [code=-5567, state=42567]
[INFO]
[ERROR] Tests run: 4022, Failures: 17, Errors: 4, Skipped: 0


**MSSQL**

ERROR] Failures:
[ERROR]
TestArithmeticResultType>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testJPQLProjection:129
value 6 expected:<0> but was:<-1>
[ERROR]
TestArithmeticResultType>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testMixedOperands:97->assertDecimal:177
value 10 expected:<0> but was:<-1>
[ERROR]
TestDecimalScale>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testFractionIsComparedInQuery:87
expected:<[1]> but was:<[]>
[ERROR]
TestDecimalScale>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testFractionIsKeptOnFind:62->assertDecimal:149
2.5 <> 3 expected:<0> but was:<-1>
[ERROR]
TestDecimalScale>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testFractionIsKeptOnUpdate:77->assertDecimal:149
0.75 <> 1 expected:<0> but was:<-1>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryMinusInMemory:173->assertDecimal:235
-25.5 <> -26 expected:<0> but was:<1>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryMinusOnParameterInWhere:128
expected:<[2]> but was:<[]>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryMinusOnPath:54->assertDecimal:235
-25.5 <> -26 expected:<0> but was:<1>
[ERROR]
TestUnarySign>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testUnaryPlusOnPath:62->assertDecimal:235
25.5 <> 26 expected:<0> but was:<-1>
[ERROR]
TestEJBQLFunction>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testExtractSecondKeepsFractionFromTime:987
expected:<42.75> but was:<42.0>
[ERROR]
TestEJBQLFunction>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testExtractSecondKeepsFractionFromTimestamp:968
expected:<23.5> but was:<23.0>
[ERROR]
TestExtractDateTimeField>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testExtractWeek:150
expected:<[1, 52]> but was:<[1, 53]>
[ERROR]
TestJava8TimeTypes>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->AbstractPersistenceTestCase.runTest:590->testGetCurrentLocalTime:287
[ERROR] Errors:
[ERROR]
TestFlushModeAutoNavigation>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:50
» Persistence The object 'PK__FLUSH_OR__3214EC27D85411E5' is
dependent
on column 'ID'. {stmnt 697551855 ALTER TABLE FLUSH_ORDER DROP
COLUMN
ID} [code=5074, state=S0001]
[ERROR]
TestFlushModeAutoNavigation>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:69
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTckFixes>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:100
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTckFixes>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:100
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTckFixes>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:50
» Persistence The object 'PK__TPRODUCT__3213E83FFD1B83BC' is
dependent
on column 'id'. {stmnt 262294106 ALTER TABLE TPRODUCT DROP COLUMN
id}
[code=5074, state=S0001]
[ERROR]
TestTckFixes>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:100
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:123
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:50
» Persistence The object 'PK__TPRODUCT__3213E83FFD1B83BC' is
dependent
on column 'id'. {stmnt 515972967 ALTER TABLE TPRODUCT DROP COLUMN
id}
[code=5074, state=S0001]
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:123
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:123
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:123
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:123
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[ERROR]
TestTreatJoinOnEmbeddable>AbstractPersistenceTestCase.run:213->AbstractPersistenceTestCase.runBare:553->AbstractPersistenceTestCase.runBare:577->setUp:46->createTestData:123
» Rollback The transaction has been rolled back.  See the nested
exceptions for details on the errors that occurred.
[INFO]
[ERROR] Tests run: 4022, Failures: 13, Errors: 13, Skipped: 0

**Oracle**

[ERROR]
org.apache.openjpa.persistence.criteria.TestTypesafeCriteria.testLeftAndRightWithParameters
-- Time elapsed: 4.376 s <<< FAILURE!
junit.framework.AssertionFailedError: expected:<John Fitzgerald
Doe>
but was:<null>
at junit.framework.Assert.fail(Assert.java:57)
at junit.framework.Assert.failNotEquals(Assert.java:329)
at junit.framework.Assert.assertEquals(Assert.java:78)
at junit.framework.Assert.assertEquals(Assert.java:86)
at junit.framework.TestCase.assertEquals(TestCase.java:246)
at
org.apache.openjpa.persistence.criteria.TestTypesafeCriteria.testLeftAndRightWithParameters(TestTypesafeCriteria.java:1849)
ERROR]
org.apache.openjpa.jdbc.sql.TestCharStorage.testCharFieldsInGeneratedSchema
-- Time elapsed: 0.252 s <<< FAILURE!
junit.framework.AssertionFailedError: CHARSTORAGE.CHARDATA
expected:<4> but was:<2>
at junit.framework.Assert.fail(Assert.java:57)
at junit.framework.Assert.failNotEquals(Assert.java:329)
at junit.framework.Assert.assertEquals(Assert.java:78)
at junit.framework.Assert.assertEquals(Assert.java:234)
at junit.framework.TestCase.assertEquals(TestCase.java:377)
at
org.apache.openjpa.jdbc.sql.TestCharStorage.assertColumnType(TestCharStorage.java:241)
at
org.apache.openjpa.jdbc.sql.TestCharStorage.testCharFieldsInGeneratedSchema(TestCharStorage.java:56)
[ERROR]
org.apache.openjpa.jdbc.sql.TestCharStorage.testExplicitStoreCharsAsNumbers
-- Time elapsed: 0.245 s <<< FAILURE!
junit.framework.AssertionFailedError: CHARSTORAGE_NUM.CHARDATA
expected:<4> but was:<2>
at junit.framework.Assert.fail(Assert.java:57)
at junit.framework.Assert.failNotEquals(Assert.java:329)
at junit.framework.Assert.assertEquals(Assert.java:78)
at junit.framework.Assert.assertEquals(Assert.java:234)
at junit.framework.TestCase.assertEquals(TestCase.java:377)
at
org.apache.openjpa.jdbc.sql.TestCharStorage.assertColumnType(TestCharStorage.java:241)
at
org.apache.openjpa.jdbc.sql.TestCharStorage.testExplicitStoreCharsAsNumbers(TestCharStorage.java:109)
org.apache.openjpa.persistence.query.TestTimeoutException seems to
stuck


On Mon, 2 Nov 2026 at 13:26, Maxim Solodovnik <
[email protected]> wrote:
Hello All,

Regular "Databases" run is RED (MySQL and MariaDB)

And I have updated
https://issues.apache.org/jira/browse/OPENJPA-3028
with full logs of TCK runs for multiple Databases :)

Which of above we would like to fix before release? :)

On Thu, 29 Oct 2026 at 10:28, Maxim Solodovnik <
[email protected]> wrote:
Hello All,

while I'm waiting for some recent PRs to be merged I was
working on
our site update
Here are some very basic results:
https://nightlies.apache.org/openjpa/downloads.html

I would be happy to get some feedback :)

A bit later I'll create branch with these changes

On Wed, 28 Oct 2026 at 12:41, Maxim Solodovnik <
[email protected]> wrote:
Hello All,

I would like to merge all approved PR today, so I can re-run
TCK for
different DBs
Please check them ASAP :))

On Wed, 28 Oct 2026 at 08:19, Maxim Solodovnik <
[email protected]> wrote:
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

Reply via email to