Re: next() error - Mailing list pgsql-jdbc

From Nahum Castro
Subject Re: next() error
Date
Msg-id 714bb51a0502031635613f6fdb@mail.gmail.com
Whole thread Raw
In response to Re: next() error  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
On Fri, 04 Feb 2005 12:05:12 +1300, Oliver Jowett <oliver@opencloud.com> wrote:
> Nahum Castro wrote:
>
> > javax.servlet.ServletException: ResultSet not positioned properly,
> > perhaps you need to call next.
>
> > Has changed something on the server or on the driver?
>
> Newer drivers follow the JDBC specification more strictly.
>
> > ResultSet RecordsetPubs1 = StatementRecordsetPubs1.executeQuery();
> > boolean RecordsetPubs1_isEmpty = ! RecordsetPubs1.next();
> > boolean RecordsetPubs1_hasData = ! RecordsetPubs1_isEmpty;
>
> [...]
>
> >     <td align="left" width="50%"><%=(((RecordsetPubs1_data =
> > RecordsetPubs1.getObject("au_id"))==null ||
> > RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%></td>
>
> You appear to be calling ResultSet.getObject() even if ResultSet.next()
> returned false. You're not allowed to do this -- see the JDBC javadoc.
>
> -O
>
Thank you.
I solved the problem now.

--
Nahum Castro González
León, Guanajuato, México

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: next() error
Next
From: Stéphane RIFF
Date:
Subject: Re: [SPAM] - Re: [SPAM] - Re: JDBC HighLoad - Found word(s)