aspose file tools*
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
Author

Oracle datasource connection timeouts?

Nathan Russell
Ranch Hand

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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle datasource connection timeouts?