pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joseph Shraibman <jks@selectacast.net>
To: Phil Davis <pmd@azad.demon.co.uk>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: JDBC getRow returns 0 after first instead of 1
Date: Mon, 31 Jul 2000 11:26:50 -0400
Message-ID: <39859ABA.759221B4@selectacast.net> (raw)
References: <20000731131805.E1007@gemini.pmdnet>

What version of the driver are you using?  I fixed some off by one
errors and my fixes made it into the cvs after 7.0

Phil Davis wrote:
> 
> I think the JDBC driver has several bugs around ResultSet row
> numbering. According to the JDBC API docs[1] the getRow() method on
> ResultSet should return 1 for the first row. Currently it returns zero.
> 
> i.e.
>       if (rs.first())
>          int n = rs.getRow();  // n is now 0 instead of 1
> 
> The same problem exists with the absolute and related methods which
> need to be passed 0 to go to the first row but the API docs say it should
> be 1.
> 
> If I'm wrong could someone please explain what I got wrong.
> 
> PS,
> Where is the CVS archive for the sources and is there anon access? I could
> not find it on the postgresql.org site.
> 
> [1] http://java.sun.com/j2se/1.3/docs/api/java/sql/ResultSet.html#getRow()
> 
> --
> Phil Davis - pmd@azad.demon.co.uk



view thread (5+ messages)  latest in thread

Message-ID: <39859ABA.759221B4@selectacast.net>
Permalink:  ../39859ABA.759221B4@selectacast.net/
Also on:    postgresql.org/message-id/39859ABA.759221B4@selectacast.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: jks@selectacast.net, pmd@azad.demon.co.uk
  Subject: Re: JDBC getRow returns 0 after first instead of 1
  In-Reply-To: <39859ABA.759221B4@selectacast.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox