JDBC getRow returns 0 after first instead of 1
От
Phil Davis
Тема
JDBC getRow returns 0 after first instead of 1
Дата
Msg-id
20000731131805.E1007@gemini.pmdnet
Список
Дерево обсуждения
Re: JDBC getRow returns 0 after first instead of 1 Joseph Shraibman <jks@selectacast.net>
Re: JDBC getRow returns 0 after first instead of 1 Phil Davis <pmd@azad.demon.co.uk>
Re: JDBC getRow returns 0 after first instead of 1 Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-interfaces по дате отправления