When running Agroal with the Narayana integration and Narayana rolls back a transaction due to a timeout, the currently running statement is not cancelled, which might lead to problems if the transaction is often retried, as the statement on the database side keeps running, which can lead to resource exhaustion.

I suggest that Agroal's JTA integration is enhanced to do this cancelling.

Also see:

• https://developer.jboss.org/thread/249197
• https://narayana.zulipchat.com/#narrow/stream/323715-developers/topic/Transaction.20timeout.20and.20Hibernate.20interaction