Re: BUG #1005: JDBC cancelRowUpdates() sets column values to

From: Kris Jurka <books(at)ejurka(dot)com>
To: <lars(dot)tetzlaff(at)gmx(dot)net>
Cc: PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: BUG #1005: JDBC cancelRowUpdates() sets column values to
Date: 2003-12-11 22:31:01
Message-ID: Pine.LNX.4.33.0312111727390.1627-200000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

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
> Strae Bahnhofstr. 32 E
> Kategorie 1
>
>
> Output after Update
>
> Kunde null
> PLZ/Ort 66666 null
> Strae null
> Kategorie 0
>

Here's a patch to fix this.

Kris Jurka

Attachment Content-Type Size
cancelrowupdates.patch text/plain 6.5 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ron Popeil 2003-12-11 22:38:24 Ronco's Showtime Rotisserie - Just in time for the Holidays
Previous Message Neil Conway 2003-12-11 22:27:09 Re: libpq3 + ssl memory leak

Browse pgsql-jdbc by date

  From Date Subject
Next Message Patrick Higgins 2003-12-11 22:41:33 Re: Patch for some bugs/annoyances
Previous Message Kris Jurka 2003-12-11 21:32:06 Re: Patch for some bugs/annoyances