Infinite transaction timeout (0) incompatible with set-tx-query-timeout in JBoss EAP 6.4

Solution Verified - Updated -

Issue

  • Using the datasource property set-tx-query-timeout and transaction coordinator default-timeout of 0 (to configure infinite timeout)
  • Encountering No remaining transaction timeout exception

    ... Transaction cannot proceed - No remaining transaction timeout: java.sql.SQLException: Transaction cannot proceed - No remaining transaction timeout
        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getTimeLeftBeforeTransactionTimeout(WrapperDataSource.java:212)
        at org.jboss.jca.adapters.jdbc.WrappedConnection.checkConfiguredQueryTimeout(WrappedConnection.java:1753)
        at org.jboss.jca.adapters.jdbc.WrappedStatement.checkConfiguredQueryTimeout(WrappedStatement.java:1287)
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:456)
        ...
    

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP) 6.4 (cumulative patch 19 and later EAP 6.4)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In