----- Original Message ----- > Jose, > Tomcat is using JDK 1.5 and its JDBC driver.So I am not sure if I > need to upgrade the JDBC driver.
>I suspect that whene DB is getting restarted, Are you restarting the Oracle database without restarting your Tomcat instance? Depending on how your application gets a database connection this could be an issue. > the idle connections are being removed. Are you using Tomcat DataSource to manage your connections? If so, please include your <Resource/> tag. > Not sure how we can avoid this situation If you are using a DataSource, you could try adding validation. With DBCP this is done by adding a "validationQuery" option. For more details, see the following link. https://commons.apache.org/dbcp/configuration.html Dan > > Thanks and Regards, > Vijay Mathew > > --- On Thu, 19/7/12, Jose María Zaragoza <demablo...@gmail.com> > wrote: > > > From: Jose María Zaragoza <demablo...@gmail.com> > > Subject: Re: java.sql.SQLException: No more data to read from > > socket > > To: "Tomcat Users List" <users@tomcat.apache.org> > > Date: Thursday, 19 July, 2012, 1:28 PM > > 2012/7/19 vijay mathew <vijaymathew2...@yahoo.com>: > > > My application is using Tomcat 5.5 It works fine all > > the time however at times when I try to login to the > > application I get the below exception > > > java.sql.SQLException: No more data to read from > > socket > > > at > > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) > > > at > > oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) > > > at > > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) > > > Once restart , the application works fine. > > > > > > How to fix this issue > > > > > > > Looks like a JDBC driver issue . Are you try to upgrade it > > ? > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org