Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle datasource connection timeouts?

 
Nathan Russell
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I wonder if anyone can help. I have a web application deployed on JBoss 4.2.2GA which calls an Oracle stored procedure. The datasource is defined as a JNDI datasource, and my *_ds.xml file looks like this:


The call to the s/proc works fine. However, a problem recently came up where the database went down. When this happened, each http session using the web app at the time 'hung' at the point of calling the s/proc. I have reproduced the environment and have determined that 'hung' actually means waiting for a long time before the database connection times out. This seems to take 15 minutes to happen, and I get this in stderr:


I have tried reducing the timeout periods by adding the following to my ds.xml file:


But its made no difference.
Can anyone point be in the right direction? Any help very much appreciated;
Best regards

Nathan

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic