Connection reset : socket write error
My applications are Java based Client Server Applications. The clients have been developed using Java Swings API.(JDK 1.5) The Database server is Oracle 9i. The clients are connecting to server through Oracle JDBC thin drivers(classes12.jar -- recently tried upgrading to ojdbc14.jar also). We are NOT using any Connection pooling.
In each of our class the constructor takes a connection: Thereafter in we use this connection for executing queries and on exit we close the connection.
Everything are working fine for last 2 years till recently when our users were provided with the wireless access in place of earlier static ethernet. Hence they now connect to a access point in their rooms through wireless and thereafter the connection is on LAN.
We am now getting this exception at random in my application
java.sql.SQLException: Io exception: Connection reset by peer: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:342)
at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:682)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:24 99)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:742)
at com.tiis.common.database.DB_Connection.selQuery(DB_Connection.java:212)
at
............................................
