Re: java.sql.SQLException: No more data to read from socket

2012-07-24 Thread Daniel Mikusa
we will attempt to borrow another.** NOTE - for a true value to have any effect, the validationQuery parameter must be set to a non-null string." https://commons.apache.org/dbcp/configuration.html Dan > > > > > --- On Sat, 21/7/12, Felix Schumacher > wrote: >

Re: java.sql.SQLException: No more data to read from socket

2012-07-24 Thread vijay mathew
ent gets a new connection from the pool. --- On Sat, 21/7/12, Felix Schumacher wrote: > From: Felix Schumacher > Subject: Re: java.sql.SQLException: No more data to read from socket > To: users@tomcat.apache.org > Date: Saturday, 21 July, 2012, 6:41 PM > Am Samstag, den 21.07.

Re: java.sql.SQLException: No more data to read from socket

2012-07-22 Thread vijay mathew
: > From: Daniel Mikusa > Subject: Re: java.sql.SQLException: No more data to read from socket > To: "Tomcat Users List" > Date: Friday, 20 July, 2012, 9:34 PM > - Original Message - > > Daniel Mikusa wrote: > > ... > > > > > > &g

Re: java.sql.SQLException: No more data to read from socket

2012-07-22 Thread vijay mathew
Thanks Felix for your great explaination. --- On Sat, 21/7/12, Felix Schumacher wrote: > From: Felix Schumacher > Subject: Re: java.sql.SQLException: No more data to read from socket > To: users@tomcat.apache.org > Date: Saturday, 21 July, 2012, 6:41 PM > Am Samstag, den 21

Re: java.sql.SQLException: No more data to read from socket

2012-07-22 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Felix, On 7/21/12 9:11 AM, Felix Schumacher wrote: > To mitigate the problem of handing out broken connections the pool > often has functionality to check a connection, before it hands it > to the client. When using the tomcat database connection pool

Re: java.sql.SQLException: No more data to read from socket

2012-07-21 Thread Felix Schumacher
pher Schultz wrote: > > > From: Christopher Schultz > > Subject: Re: java.sql.SQLException: No more data to read from socket > > To: "Tomcat Users List" > > Date: Friday, 20 July, 2012, 10:21 PM > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 &g

Re: java.sql.SQLException: No more data to read from socket

2012-07-20 Thread vijay mathew
this issue when I compare the last 3 failures. --- On Fri, 20/7/12, Christopher Schultz wrote: > From: Christopher Schultz > Subject: Re: java.sql.SQLException: No more data to read from socket > To: "Tomcat Users List" > Date: Friday, 20 July, 2012, 10:21 PM >

Re: java.sql.SQLException: No more data to read from socket

2012-07-20 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Vijay, On 7/19/12 8:25 PM, vijay mathew wrote: > java.sql.SQLException: No more data to read from socket at > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) >

Re: java.sql.SQLException: No more data to read from socket

2012-07-20 Thread Daniel Mikusa
- Original Message - > Daniel Mikusa wrote: > ... > > > > > This doesn't look like a Tomcat issue. Your app is maintaining its > > own connection pool, it is not using one provided by Tomcat. I > > would suggest that you talk with your developers and see if they > > can help you. > > >

Re: java.sql.SQLException: No more data to read from socket

2012-07-20 Thread André Warnier
Daniel Mikusa wrote: ... This doesn't look like a Tomcat issue. Your app is maintaining its own connection pool, it is not using one provided by Tomcat. I would suggest that you talk with your developers and see if they can help you. Which, after a very long detour, seems to bring us back

Re: java.sql.SQLException: No more data to read from socket

2012-07-20 Thread Daniel Mikusa
Tomcat. I would suggest that you talk with your developers and see if they can help you. Dan > --- On Fri, 20/7/12, Daniel Mikusa wrote: > > > From: Daniel Mikusa > > Subject: Re: java.sql.SQLException: No more data to read from > > socket > > To: "To

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread vijay mathew
connection is obtained whenever needed ,using coDataSource.getConnection() --- On Fri, 20/7/12, Daniel Mikusa wrote: > From: Daniel Mikusa > Subject: Re: java.sql.SQLException: No more data to read from socket > To: "Tomcat Users List" > Date: Friday, 20 July, 2012, 1:59 AM &g

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread vijay mathew
The entire stacktrace is as below 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

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Daniel Mikusa
: > > > From: Daniel Mikusa > > Subject: Re: java.sql.SQLException: No more data to read from > > socket > > To: "Tomcat Users List" > > Date: Thursday, 19 July, 2012, 9:53 PM > > - Original Message - > > > Thanks Daniel and Jose. > >

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jose, On 7/19/12 8:36 AM, Jose María Zaragoza wrote: > 2012/7/19 vijay mathew : >> 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, the idle co

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Christopher Schultz
fine all the time. Hrmph. > 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.Data

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread vijay mathew
t; From: Daniel Mikusa > Subject: Re: java.sql.SQLException: No more data to read from socket > To: "Tomcat Users List" > Date: Thursday, 19 July, 2012, 9:53 PM > - Original Message - > > Thanks Daniel and Jose. > > Do you knoe what is the root cause of th

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Daniel Mikusa
have provided is sufficient to give you an exact answer. Dan > > --- On Thu, 19/7/12, Daniel Mikusa wrote: > > > From: Daniel Mikusa > > Subject: Re: java.sql.SQLException: No more data to read from > > socket > > To: "Tomcat Users List" > >

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread vijay mathew
Thanks Daniel and Jose. Do you knoe what is the root cause of this issue --- On Thu, 19/7/12, Daniel Mikusa wrote: > From: Daniel Mikusa > Subject: Re: java.sql.SQLException: No more data to read from socket > To: "Tomcat Users List" > Date: Thursday, 19 July, 2012, 5:

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Jose María Zaragoza
2012/7/19 vijay mathew : > 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, the idle connections are being > removed. Not sure how we can avoid this >situation OK, so you are restarting th

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Daniel Mikusa
Zaragoza > wrote: > > > From: Jose María Zaragoza > > Subject: Re: java.sql.SQLException: No more data to read from > > socket > > To: "Tomcat Users List" > > Date: Thursday, 19 July, 2012, 1:28 PM > > 2012/7/19 vijay mathew : > > > My ap

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread vijay mathew
María Zaragoza wrote: > From: Jose María Zaragoza > Subject: Re: java.sql.SQLException: No more data to read from socket > To: "Tomcat Users List" > Date: Thursday, 19 July, 2012, 1:28 PM > 2012/7/19 vijay mathew : > > My application is using Tomcat 5.5 It works

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread Jose María Zaragoza
2012/7/19 vijay mathew : > 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.

Re: java.sql.SQLException: No more data to read from socket

2012-07-19 Thread André Warnier
vijay mathew wrote: 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

java.sql.SQLException: No more data to read from socket

2012-07-18 Thread vijay mathew
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