Re: throw SQLException on no rs.next()? - Mailing list pgsql-jdbc

From Nick Fankhauser
Subject Re: throw SQLException on no rs.next()?
Date
Msg-id NEBBLAAHGLEEPCGOBHDGMEFEENAA.nickf@ontko.com
Whole thread Raw
In response to Re: throw SQLException on no rs.next()?  (Dave Cramer <Dave@micro-automation.net>)
Responses Re: throw SQLException on no rs.next()?  (Dave Cramer <Dave@micro-automation.net>)
List pgsql-jdbc
Dave-

My response was based on my experience when I started (about a year ago) so
this may be changed.

However, at the time it looked to me like it *should* throw an NPE in this
situation, so I'm suprised that it would be a candidate for change.

-Nick

> -----Original Message-----
> From: Dave Cramer [mailto:Dave@micro-automation.net]
> Sent: Tuesday, April 23, 2002 7:23 AM
> To: nickf@ontko.com
> Cc: AgentM; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] throw SQLException on no rs.next()?
>
>
> I thought I fixed it so that it doesn't throw an NPE, but I could be
> mistaken?
>
> Dave
> On Tue, 2002-04-23 at 08:09, Nick Fankhauser wrote:
> > Yes, it sure does. The way I usually handle stepping through a
> ResultSet is
> > with a structure like this:
> >
> > /* create REsultSet results */
> > while (results.next())
> > {
> >   /*do something with results*/
> > }
> >
> > You're right about this being a common newbie gotcha. I'll add it to the
> > newbie FAQ.
> >
> > -NF
> >
> >
> > > -----Original Message-----
> > > From: pgsql-jdbc-owner@postgresql.org
> > > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of AgentM
> > > Sent: Tuesday, April 23, 2002 12:36 AM
> > > To: pgsql-jdbc@postgresql.org
> > > Subject: [JDBC] throw SQLException on no rs.next()?
> > >
> > >
> > > Hi- it's me the JDBC newbie again and I have a simple request. Could
> > > a call to resultset.getX() throw some exception if rs.next() has not
> > > yet been called? I just got horribly burned by missing this simple
> > > thing and I think it may be helpful to other newbies to have this
> > > extra bit of information. Thanks.
> > > --
> > > ><><><><><><><><><><><><
> > > AgentM
> > > agentm@cmu.edu
> > >
> > > ---------------------------(end of
> broadcast)---------------------------
> > > TIP 6: Have you searched our list archives?
> > >
> > > http://archives.postgresql.org
> > >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> >
>
>
>


pgsql-jdbc by date:

Previous
From: "Marin Dimitrov"
Date:
Subject: Re: throw SQLException on no rs.next()?
Next
From: Dave Cramer
Date:
Subject: Re: throw SQLException on no rs.next()?