This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database timeout settings

 
Kris Philippaerts
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Probarbly an easy question:

we have a query that performs some joins on big tables. When we execute it on our Informix database, it takes quite a while to execute. We had the query analyzed by our Informix specialists, but they say there are no big optimizations left.

When we use the query in our J2EE application (on Bea Weblogic 8.1), the application fails with a TimeOutException, and rolls back the transaction. The same application deployed at an other site with a smaller database does everything perfect.

The header of the exception is:



So my question is: how can I increase the timeout of.. I don't know, my beans? My connection? My...? Is this ejb-jar.xml configuration? Or application server configuration?

Any pointers are welcome!

Thanks a lot for your time!

Kris

----------------------

I just found out that bea weblogic default timout is 300 seconds. How come I get a timeout after 29 seconds? Can this also be a database setting?
[ April 21, 2005: Message edited by: Kris Philippaerts ]
 
Valentin Tanase
Ranch Hand
Posts: 704
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Kris,

You have two options here:
  • Check the <trans-timeout-seconds> element in weblogic-ejb-jar.xml.
  • Set the Timeout Seconds parameter for the JTA service using weblogic console (using wl console click on Services/JTA and see the JTA tab).


  • The first option will affect only the trans timeout for the bean(s) that give you trouble, while the second one will affect all transactions in your system. I would recommend the first choice, but you could test both of them and make sure that 1 overrides 2.

    I just found out that bea weblogic default timout is 300 seconds. How come I get a timeout after 29 seconds? Can this also be a database setting?

    It�s actually 30 seconds.
    Regards.
     
    Kris Philippaerts
    Greenhorn
    Posts: 25
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Great! Thanks a lot. I'll have to think which option to choose, since the application runs at two sites. So I might want to leave the configuration as much applicationserver-sided as possible. But at least I can do some testing now.

    Really appreciate your help!

    Kris
     
    Valentin Tanase
    Ranch Hand
    Posts: 704
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    You're very welcome Kris
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic