Re: PSQLException: ResultSet not positioned properly - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: PSQLException: ResultSet not positioned properly
Date
Msg-id 47B4F05D.5040805@opencloud.com
Whole thread Raw
In response to PSQLException: ResultSet not positioned properly  (james@dades.ca)
List pgsql-jdbc
james@dades.ca wrote:

>                         System.out.println("Error: ticket number not found
> in bol: so#="+sonumber+" ticket#="+token+";
> navroutno="+pRs.getString(2));

You probably don't meant to use pRs.getString() here. That's the
resultset that you already iterated through completely in the previous
loop (and the connection it was generated from is closed, anyway)

-O

pgsql-jdbc by date:

Previous
From: james@dades.ca
Date:
Subject: PSQLException: ResultSet not positioned properly
Next
From: james@dades.ca
Date:
Subject: Re: PSQLException: ResultSet not positioned properly