we are facing problem with transactions in
jboss. The defalut global transaction timeout is set to 300sec in jboss-service.xml.
While executing a query from our application it is taking more than 300sec. Afther that for the same transaction it is opening other session and leading to the problems. Some times it is fetching the results within 5min and sometimes it is exceeding the timeout. As a work around we increased the transaction time out and it is working fine. It is a simple POJO. The query is fine tuned and indexes are created on the tables. Is there any other options to set trancaction time for this particular transaction.
Thanks in advance for your help.
Regards,
Ravi.