tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Eastham" <andy.east...@gliant.com>
Subject RE: Strange error
Date Mon, 10 Feb 2003 14:57:00 GMT
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


Mime
View raw message