Re: Resultset problem or BUG ! - Mailing list pgsql-general

From Richard Huxton
Subject Re: Resultset problem or BUG !
Date
Msg-id 411A2EAB.2040005@archonet.com
Whole thread Raw
In response to Resultset problem or BUG !  (Elie Nacache <elie_nacache@yahoo.com>)
List pgsql-general
Elie Nacache wrote:
> Hi Richard,
>
> Some informations: ============== OS: RedHat DB: PostgreSQL 7.4.3
> Driver: PostgreSQL 7.4.2 JDBC3 with SSL (build 213)

OK - I'm not a java expert, so if no-one else has anything better to
say, please post this on the jdbc mailing list instead. They'll be able
to help you for sure.

> Here some code: ============ 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
>
> INFO >> At this step there is no commit INFO >> Second step update
> the row after collecting updated info
>
> this.sqlDatas.absolute(this.sqlLineNumber); // INFO >> throw the
> exception this.updateColumns(); this.sqlDatas.updateRow();

What is "sqlLineNumber"? I'm not familiar with that attribute off the
top of my head. The exception was complaining that .absolute() couldn't
move to row 0 which seems correct .absolute(1) is the first row. So -
what is "sqlLineNumber" and why is it zero?

> INFO >> If I fix the sqlLineNumber to 1 and force the absolute(1)
> then no Execption is thrown but the modification is not seen in the
> table.

The easiest way to see why the change isn't seen is to turn statement
logging on in PostgreSQL (and tell it to reload its config file).

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Nick Barr
Date:
Subject: Re: POSIX RE starting with a (
Next
From: Jeff Eckermann
Date:
Subject: Re: Replication options?