Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction timeout in JBOSS-4.2.3.GA

 
ravikanth reddy
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ravikanth reddy wrote: It is a simple POJO. ... Is there any other options to set trancaction time for this particular transaction.



How do you start the transaction for that POJO?
 
ravikanth reddy
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jai,

Thanks a lot for your response.

We are looking up for the Data source, getting connection and executing the statement. While executing the statement sometimes it leads to the transaction timeout. We are connecting to the oracle10.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic