yes, i believe my oracle db reboot once in a while, but I have no control over rebooting db server since its for weekly maintenance. I will try to use validationQuery as Thomas mentioned. Thanks
On Mon, Jun 9, 2008 at 1:43 PM, Propes, Barry L <[EMAIL PROTECTED]> wrote: > is this possibly Oracle rebooting by its own settings? > > -----Original Message----- > From: Htin Kyaw Nyo [mailto:[EMAIL PROTECTED] > Sent: Monday, June 09, 2008 9:27 AM > To: Tomcat Users List > Subject: tomcat connection pooling problem > > > 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 > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
