Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle datasource connection timeouts?  RSS feed

Nathan Russell
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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


  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!