Reactive Panache LockModeType.PESSIMISTIC_WRITE not supported

[alexjaravete]

Describe the bug

When using findById(id, LockModeType.PESSIMISTIC_WRITE) Quarkus throws the following error: JPA error: java.lang.UnsupportedOperationException

Are Locks not supported with Reactive Panache?

Expected behavior

for update should be added to the SQL Query.

Actual behavior

Throws JPA error: java.lang.UnsupportedOperationException

How to Reproduce?

No response

Output of uname -a or ver

No response

Output of java -version

openjdk version "17.0.11" 2024-04-16 LTS OpenJDK Runtime Environment Corretto-17.0.11.9.1 (build 17.0.11+9-LTS) OpenJDK 64-Bit Server VM Corretto-17.0.11.9.1 (build 17.0.11+9-LTS, mixed mode, sharing)

Quarkus version or git rev

3.8.3

Build tool (ie. output of mvnw --version or gradlew --version)

Apache Maven 3.9.6 (bc0240f3c744dd6b6ec2920b3cd08dcc295161ae)

Additional information

No response

[quarkus-bot[bot]]

/cc @FroMage (panache), @loicmathieu (panache)

[loicmathieu]

Can you provide the full stack trace and a reproducer?

[alexjaravete]

After posting the same issue to the hibernate-reactive repository, it seems to be a bug with hibernate-reactive directly. This is the issue: https://github.com/hibernate/hibernate-reactive/issues/1905