Recovering from SQLEXceptions after network failure

[ctippin]

Hi,

We are currently using JBoss 3.04, Oracle 8i, jdk 1.3.1 running on win2k

Lately we have experienced a couple of short local network glitches that have momentarily affected connectivity between our JBoss server box and our Oracle box. As one would expect, we immediately see the following exceptions all over the place :

java.sql.SQLException: Io exception: Connection reset by peer: socket write error

Unfortunately when the network is restored, our app continues to throw these exceptions whenever our beans try to access Oracle.

Does anyone know how to recover from this without restarting the app?

TIA

[davidjencks]

in 3.0.7 (cvs ) you can set a CheckValidConnectionSQL string that will be executed each time before a connection is handed out. An error of any kind will cause the connection to be destroyed.

In 3.2 cvs you can use the OracleExceptionSorter which should detect these errors and dispose of the connections. If I get some positive feedback that this feature works properly I will try to get it into the 3.0.7 release. This needs to happen very soon.

[ctippin]

Great! What is the ETA of 3.07 release? Is the current dev build pretty stable?

[kkoster]

Which section of the deployment descriptor is the CheckValidConnectionSQL added?