tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vijay mathew <vijaymathew2...@yahoo.com>
Subject Re: java.sql.SQLException: No more data to read from socket
Date Fri, 20 Jul 2012 00:34:02 GMT
Daniel,
      It is a web application. I was just referring to the java code in the webapplication.
This is how we retrieve the connection 
Class.forName(driver);
ObjectPool connectionPool = new GenericObjectPool(null);
ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectionURI,userName,password);
PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,connectionPool,null,null,defaultReadOnly,defaultAutoCommit);
coDataSource = new PoolingDataSource(connectionPool);
} 

coDataSource  is a static object and a connection is obtained whenever needed ,using coDataSource.getConnection()


--- On Fri, 20/7/12, Daniel Mikusa <dmikusa@vmware.com> wrote:

> From: Daniel Mikusa <dmikusa@vmware.com>
> Subject: Re: java.sql.SQLException: No more data to read from socket
> To: "Tomcat Users List" <users@tomcat.apache.org>
> Date: Friday, 20 July, 2012, 1:59 AM
> ----- 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 <dmikusa@vmware.com>
> wrote:
> > 
> > > From: Daniel Mikusa <dmikusa@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 <dmikusa@vmware.com>
> > > wrote:
> > > > 
> > > > > From: Daniel Mikusa <dmikusa@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
> > > <demablogia@gmail.com>
> > > > > > wrote:
> > > > > > 
> > > > > > > From: Jose María Zaragoza
> <demablogia@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 <vijaymathew2001@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-unsubscribe@tomcat.apache.org
> > > > > > > For additional commands,
> e-mail:
> > > > > > > users-help@tomcat.apache.org
> > > > > > > 
> > > > > > >
> > > > > > 
> > > > > >
> > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > > > > > For additional commands, e-mail: users-help@tomcat.apache.org
> > > > > > 
> > > > > >
> > > > > 
> > > > >
> > >
> ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > > > > For additional commands, e-mail: users-help@tomcat.apache.org
> > > > > 
> > > > >
> > > > 
> > > >
> > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > > > For additional commands, e-mail: users-help@tomcat.apache.org
> > > > 
> > > > 
> > > 
> > >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > > For additional commands, e-mail: users-help@tomcat.apache.org
> > > 
> > >
> > 
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > For additional commands, e-mail: users-help@tomcat.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message