Re: throw SQLException on no rs.next()?

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: nickf(at)ontko(dot)com
Cc: AgentM <agentm(at)cmu(dot)edu>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: throw SQLException on no rs.next()?
Date: 2002-04-23 12:23:24
Message-ID: 1019564604.1536.57.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of AgentM
> > Sent: Tuesday, April 23, 2002 12:36 AM
> > To: pgsql-jdbc(at)postgresql(dot)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(at)cmu(dot)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(at)postgresql(dot)org
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nick Fankhauser 2002-04-23 12:29:33 Re: throw SQLException on no rs.next()?
Previous Message Nick Fankhauser 2002-04-23 12:09:24 Re: throw SQLException on no rs.next()?