jbossjtajboss-eap-7xa

Why JBOSS ORACLE datasource doesn't fail fast when query times out?

Why JBOSS ORACLE datasource doesn't fail fast when query times out?

Environment: jboss-eap-7.0

I was waiting a fast fail with the exception:

java.sql.SQLTimeoutException: ORA-01013 user requested cancel of current operation

But I get the following after the end of transaction.

Caused by: java.lang.Throwable: setRollbackOnly called from:
    at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.setRollbackOnly(TransactionImple.java:339)

How do I force it to fail fast?

Solution

  • This is related to the JDBC driver version and firewall stuff.

    This is not related to JBOSS, XA, JTA, DATASOURCE or something else.

    See: https://www.ibm.com/mysupport/s/question/0D50z000062kF2p/why-is-the-webspheredefaultquerytimeout-property-for-timing-out-sql-queries-not-working