----- Original Message ----- > Thanks Daniel. > > -> DB is getting restarted every weekend but tomcat is not getting > restarted at the same time. > just fyi this issue doesnt happen every time. It happens once every > month even if the DB is getting restarted every week. > So not sure wat is the exact root cause
> ->I have attached the server.xml. I dont find the Resource tag here.. Is the <Resource/> tag defined somewhere else? Perhaps in a <Context/> tag? conf/context.xml, conf/Catalina/localhost/<app>.xml or META-INF/context.xml? > From java code, a data source is created using > PoolableConnectionFactory and GenericObjectPool and then a > connection is retrieved from this datasource. What Java code? Your web application? Are you manually creating the DataSource and connection pool? Dan > > --- 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, 9:53 PM > > ----- Original Message ----- > > > Thanks Daniel and Jose. > > > Do you knoe what is the root cause of this issue > > > > It's hard to say since you have not answered the questions > > from my previous email, you have not posted your data source > > configuration and you have only posted a partial stack > > trace. > > > > Nevertheless, I will venture a guess. *If* you are in > > fact restarting your Oracle database then that would > > disconnect any persistent connections maintained by the > > connection pool. > > > > Given that your connection pool would contain a bunch of > > connections which have been disconnected, you would either > > need to restart Tomcat (which will create a fresh connection > > pool) or configure your connection pool to find and replace > > the closed connections (hence the suggestion to use a > > validationQuery). > > > > That's just a guess though, I do not believe that the amount > > of information that you have provided is sufficient to give > > you an exact answer. > > > > Dan > > > > > > > > > > > > --- 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 > > > > > > > > > > --------------------------------------------------------------------- > > 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