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

Solution Verified - Updated -


  • 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(
        at org.jboss.jca.adapters.jdbc.WrappedConnection.checkConfiguredQueryTimeout(
        at org.jboss.jca.adapters.jdbc.WrappedStatement.checkConfiguredQueryTimeout(
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(


  • 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