Hi
I am using tomcat55 and ojdbc14_g and tomcat connection pooling. I am
getting this error when i leave tomcat run for a couple of days. I searched
around the internet and people blaming firewall and connection issues by db
server. here is a brief error:
java.sql.SQLException: Io exception: Connection reset by peer: socket write
error
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:382)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:521)
at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:979)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:552)...
.......................................
I am pretty sure it is the connection issue from db server, since it can be
resolved by restarting tomcat. but this solution is not acceptable for our
production system. Is there anyway that I can systematically resolve the
issue (from my source code using try catch) OR tomcat connection pooling
configuration? I need to resolve without restarting tomcat. Thanks in
advance.
Nick
