Re: throw SQLException on no rs.next()? - Mailing list pgsql-jdbc
From | Dave Cramer |
---|---|
Subject | Re: throw SQLException on no rs.next()? |
Date | |
Msg-id | 1019565640.4158.60.camel@inspiron.cramers Whole thread Raw |
In response to | Re: throw SQLException on no rs.next()? ("Nick Fankhauser" <nickf@ontko.com>) |
Responses |
Re: throw SQLException on no rs.next()?
("Nick Fankhauser" <nickf@ontko.com>)
|
List | pgsql-jdbc |
Nick, I think it should throw a SQLException, since that is what most ppl are catching, I don't really think any driver should ever NPE as a result of misuse. Dave On Tue, 2002-04-23 at 08:29, Nick Fankhauser wrote: > 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 > > > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
pgsql-jdbc by date: