Re: [GENERAL] Resultset problem or BUG ! - Mailing list pgsql-jdbc

On Wed, 11 Aug 2004, Elie Nacache wrote:

> INFO >> sqlDatas is of type ResultSet
> INFO >> Step first insert new row
>
> this.sqlDatas.moveToInsertRow();
> this.updateColumns();
> this.sqlDatas.insertRow();
> this.sqlLineNumber = this.sqlDatas.getRow(); // INFO >> return 0
>

The problem here is that you are still on the insert row, you are not
positioned anywhere in your ResultSet so getRow returns zero.  You seem to
be expecting getRow to return the newly inserted row's position which I
admit seems handly although it doesn't look to be what the spec wants.

Kris Jurka