Re: NullPointerExceptions in empty ResultSets

Try downloading the dev jar

I just tried

  public void testEmptyResult()
  {
    try
    {
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT * FROM testrs where
id=100");
      rs.beforeFirst();
      rs.afterLast();
      assertTrue(!rs.first());
      assertTrue(!rs.last());
      assertTrue(!rs.next());


    }
    catch ( Exception ex )
    {
      fail( ex.getMessage() );
    }

and it passed with no problem

DAve
On Thu, 2002-06-13 at 14:00, Floyd Shackelford wrote:
>
> i just upgraded to the latest jdbc driver and am now getting errors in empty
> ResultSets (i.e. the sql select returned 0 rows) where i used to not get an
> error. here are some examples:
>
> java.lang.NullPointerException at
> org.postgresql.jdbc2.ResultSet.beforeFirst(ResultSet.java:876)
>
> java.lang.NullPointerException at
> org.postgresql.jdbc2.ResultSet.last(ResultSet.java:1133)
>
> please let me know if this is an error and if so:
>
> 1. how do i work around it for now
> 2. when can i have a new version of the jdbc jar file?
>
> Regards,
>
> Floyd Shackelford
> 4 Peaks Technology Group, Inc.
> VOICE: 334.735.9428
> FAX:   916.404.7125
> EMAIL: FloydS@4PeaksTech.com
> ICQ #: 161371538
> acta non verba
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.370 / Virus Database: 205 - Release Date: 6/5/2002
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.370 / Virus Database: 205 - Release Date: 6/5/2002
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.370 / Virus Database: 205 - Release Date: 6/5/2002