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