Message Title

jpa/core/lock/query/Client.java#getResultListTest1_from_appmanagedNoTx
jpa/core/lock/query/Client.java#getResultListTest1_from_puservlet

A clue is that the failure happens with git commit e96402a0052d320cbd0a82fe788b00b2d3fe81bf or newer (on Hibernate ORM 6.2 branch). The previous commit b754325cab919ccfe480ed126330105429004d58 passes the jpa/core/lock/query tests.

^[[0m^[[33m09:15:47,218 WARN  [org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess] (default task-2) HHH000444: Encountered request for locking however dialect reports that database prefers locking be done in a separate select (follow-on locking); results will be locked after initial query executes
^[[0m^[[33m09:15:47,250 WARN  [org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess] (default task-2) HHH000444: Encountered request for locking however dialect reports that database prefers locking be done in a separate select (follow-on locking); results will be locked after initial query executes
^[[0m[javatest.batch] ^[[0m^[[0m09:15:47,226 INFO  [stdout] (Thread-197) 05-01-2023 09:15:47:  SVR-ERROR: LockMoteType for the Employee[1] was wrong - Expected:PESSIMISTIC_READ, Actual:NONE
[javatest.batch] ^[[0m^[[0m09:15:47,227 INFO  [stdout] (Thread-197) 05-01-2023 09:15:47:  SVR-ERROR: LockMoteType for the Employee[2] was wrong - Expected:PESSIMISTIC_READ, Actual:NONE