set-tx-query-timeout does not work when the remaining time of transaction timeout is shorter than one second in JBoss EAP

Environment

• Red Hat JBoss Enterprise Application Platform (EAP)
  • 7.x
  • 6.x

Issue

• set-tx-query-timeout does not work when the remaining time of transaction timeout is shorter than one second in JBoss EAP
• set-tx-query-timeout is configured in datasource setting but it looks the query timeout is not set when the query is executed at almost end of the remaining time of transaction timeout.

Resolution

This issue is a bug reported in the following JIRA and Bugzilla:

• set-tx-query-timeout does not work when the remaining time of transaction timeout is shorter than one second
  EAP 6.4.z: <This content is not included.https://bugzilla.redhat.com/show_bug.cgi?id=1497591>
  EAP 7.0.x: <Content from issues.jboss.org is not included.https://issues.jboss.org/browse/JBEAP-13299>
  EAP 7.1.0: <Content from issues.jboss.org is not included.https://issues.jboss.org/browse/JBEAP-13300>
  Upstream (IronJacamar): <Content from issues.jboss.org is not included.https://issues.jboss.org/browse/JBJCA-1355>

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.