| | 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. |