Re: BUG #1005: JDBC cancelRowUpdates() sets column values to - Mailing list pgsql-bugs

On Thu, 11 Dec 2003, PostgreSQL Bugs List wrote:

> Description:        JDBC cancelRowUpdates() sets column values to null
>
> this sequence sets all but "plz" and "kategorie" to null, "kategorie"
> is changed to 0
>
>   rs.first();
>   rs.updateInt( "plz", 99999 );
>   rs.cancelRowUpdates();
>   rs.updateInt( "plz", 66666 );
>   rs.updateRow();
>   rs.beforeFirst();
>
> Output before update:
>
>   Kunde Lars Tetzlaff
>   PLZ/Ort 51702 Bergneustadt
>   Straße Bahnhofstr. 32 E
>   Kategorie 1
>
>
> Output after Update
>
>  Kunde null
>  PLZ/Ort 66666 null
>  Straße null
>  Kategorie 0
>

Here's a patch to fix this.

Kris Jurka