Infinite transaction timeout (0) incompatible with set-tx-query-timeout in JBoss EAP 6.4
Issue
- Using the datasource property
set-tx-query-timeout
and transaction coordinatordefault-timeout
of0
(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, tools, and much more.