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