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;