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:[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] > -- 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]
