• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Transaction timeout in JBOSS-4.2.3.GA

 
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 10445
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic