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

Oliver Jowett wrote:
> 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)


Thank you, Oliver.  That was indeed my problem.

James