tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felipe Schnack <feli...@ritterdosreis.br>
Subject RE: Strange error
Date Mon, 10 Feb 2003 15:19:28 GMT
  I was wrongly reusing the statement, and in a specific situation I was
closing it too... thank you all for your tips :-)

On Mon, 2003-02-10 at 12:57, Andy Eastham wrote:
> Felipe,
> 
> Just one additional idea:
> 
> Are you executing another command on the same connection?  This destroys the
> result set.
> 
> Eg, if you are trying to loop over the result set, and are using the same
> connection to do an update or delete on this or another table, you will get
> this sort of error.
> 
> Andy
> > -----Original Message-----
> > From: Sean Dockery [mailto:sean@sbdconsultants.com]
> > Sent: 10 February 2003 14:04
> > To: Tomcat Users List
> > Subject: Re: Strange error
> >
> >
> > Either your database connection is timing out or else you are
> > trying to use
> > a ResultSet obtained from a Statement which, in turn, was obtained from a
> > Connection which you have closed yourself.
> >
> > Sean Dockery
> > sean@sbdconsultants.com
> > Certified Java Web Component Developer
> > Certified Delphi Programmer
> > SBD Consultants
> > http://www.sbdconsultants.com
> >
> > ----- Original Message -----
> > From: "Felipe Schnack" <felipes@ritterdosreis.br>
> > To: "pgsql-jdbc" <pgsql-jdbc@postgresql.org>; "Tomcat Users List"
> > <tomcat-user@jakarta.apache.org>
> > Sent: Monday, February 10, 2003 04:45
> > Subject: Strange error
> >
> >
> >   Please, somebody can help me? I'm getting this error message and I
> > don't know why... I'm using PostgreSQL 7.3 and Tomcat 4.1.18 connection
> > pooling mechanism
> >
> > Connection is closed.  Operation is not permitted.
> > at
> > org.postgresql.jdbc1.AbstractJdbc1ResultSet.next(AbstractJdbc1Resu
> > ltSet.java
> > :63)
> > at
> > org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java)
> > at com.w2.infra.db.DbVector.next(DbVector.java:141)
> >
> > --
> >
> > Felipe Schnack
> > Analista de Sistemas
> > felipes@ritterdosreis.br
> > Cel.: (51)91287530
> > Linux Counter #281893
> >
> > Centro Universitário Ritter dos Reis
> > http://www.ritterdosreis.br
> > ritter@ritterdosreis.br
> > Fone/Fax.: (51)32303341
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
-- 

Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone/Fax.: (51)32303341


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


Mime
View raw message