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:[EMAIL PROTECTED]]
> 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
> [EMAIL PROTECTED]
> Certified Java Web Component Developer
> Certified Delphi Programmer
> SBD Consultants
> http://www.sbdconsultants.com
>
> ----- Original Message -----
> From: "Felipe Schnack" <[EMAIL PROTECTED]>
> To: "pgsql-jdbc" <[EMAIL PROTECTED]>; "Tomcat Users List"
> <[EMAIL PROTECTED]>
> 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
> [EMAIL PROTECTED]
> Cel.: (51)91287530
> Linux Counter #281893
>
> Centro Universitário Ritter dos Reis
> http://www.ritterdosreis.br
> [EMAIL PROTECTED]
> Fone/Fax.: (51)32303341
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to