File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes Oracle datasource connection timeouts? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Oracle datasource connection timeouts?" Watch "Oracle datasource connection timeouts?" New topic

Oracle datasource connection timeouts?

Nathan Russell
Ranch Hand

Joined: Aug 18, 2004
Posts: 75
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


I agree. Here's the link:
subject: Oracle datasource connection timeouts?
jQuery in Action, 3rd edition