URGENT !! java.sql.SQLException: Io exception: Connection reset
Hi,
The database is connecting using sqlplus and is running fine.
It is production server and is 24*7 env.
The application is also connecting to the database but it keeps disconnecting every 1-2 hours.
Following is the log generated.
java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:978)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1695)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1661)
at com.sabre.qik.addon.database.DatabaseConnectionImpl.executeStatement(DatabaseConnectionImpl.java:535)
at com.sabre.qik.verb.database.DatabaseVerbs$SendDBString.invokeSlave(DatabaseVerbs.java:302)
at com.sabre.qik.verb.database.DatabaseVerbs$DBVerb.invoke(DatabaseVerbs.java:788)
at com.sabre.qik.appobject.script.Engine.processToInterruptionPoint(Engine.java:778)
at com.sabre.qik.appobject.script.Engine.mainLoop(Engine.java:677)
at com.sabre.qik.appobject.script.Engine.run(Engine.java:1065)
at com.sabre.qik.util.ErrorHandlerRunnable.run(ErrorHandlerRunnable.java:39)
at java.lang.Thread.run(Thread.java:
Please help!