Thanks Daniel and Jose. Do you knoe what is the root cause of this issue --- On Thu, 19/7/12, Daniel Mikusa <dmik...@vmware.com> wrote:
> From: Daniel Mikusa <dmik...@vmware.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, 5:39 PM > ----- 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org