| 18 | It seems likely that the ‘JBoss transaction timeout’ is being reached when a complex set of requirements is passed to hibernate for building the export data set. |
| 19 | |
| 20 | In jboss/server/default/conf/jboss-service.xml, there is a stanza devoted to the transaction manager… |
| 21 | |
| 22 | <mbean code="com.arjuna.ats.jbossatx.jta.TransactionManagerService" |
| 23 | name="jboss:service=TransactionManager"> |
| 24 | <attribute name="TransactionTimeout">300</attribute> |
| 25 | <attribute name="ObjectStoreDir">${jboss.server.data.dir}/tx-object-store</attribute> |
| 26 | </mbean> |
| 27 | |
| 28 | 300 seconds is 5 minutes. I’ve set it on uhlbriccsapp03 to be 1200 seconds, or 20 minutes, and as a result the query I ran today was able to complete successfully. |