Reactive panache nested transaction error

[jtama]

Describe the bug

As of today, reactive panache nested transactions always trigger exception.

Expected behavior

When in a nested transaction panache should :

• Minimal : Give an understandable error
• Better : Have a default behaviour like "start or join existing"
• Best : Offer control to the developper to choose between "required-existing" and "sub-transaction"

  Actual behavior

  Triggers a java.lang.IllegalStateException because io.vertx.sqlclient.impl.SqlConnectionImpl (line 109)

To Reproduce

Reproducer can be found on https://github.com/jtama/quarkus-rent/tree/nested-transaction.

1. Run postgresql containeur (docker compose file available
2. Run application
3. curl -v -X POST "http://localhost:8080/api/hostels" -H "X-user-name: Joe" -H "X-user-roles: USER,ADMIN" -H "Content-Type: application/json" -d "{ \"id\": 0, \"name\": \"Ritz\"}"

Environment (please complete the following information):

Darwin Kernel Version 20.3.0

OpenJDK Runtime Environment AdoptOpenJDK (build 14+36)

1.12.2.Final

Apache Maven 3.6.3

[quarkus-bot[bot]]

/cc @FroMage, @loicmathieu

[jtama]

Happy to help on this.

[geoand]

Is this still an issue?

[jtama]

I have to say I have absolutly no idea.

[geoand]

Let's close for now and if we find it's still an issue, we can reopen

[jtama]

Absolutely, If I was the only one to report in 4 years...

[geoand]

👌