Re: updateRow bug fix (possible) and build questions

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Shawn Green <shawn(dot)green(at)signiant(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: updateRow bug fix (possible) and build questions
Date: 2003-03-25 02:26:49
Message-ID: 1048559209.1168.11.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Shawn,

Your solution was a tad aggressive, I modified it to just clear the
updates, not the buffer. The patch has been applied to HEAD, and 7.2.3

Thanks,

Dave
On Mon, 2003-03-24 at 11:57, Shawn Green wrote:
> I have a potential fix to a bug we've found in the jdbc drivers that
> occurs when you are updating in place:
>
> 1. If you open a cursor on a table using update in place
> and update two or more rows, values from previous updated entries will
> be inserted into the following updates - the only workaround is to
> update every possible row value for each row (not something I really
> want to suggest).
>
> I think I have found the problem and corrected it in the attached java
> class (line 1089). I'm pretty sure that I've got it fixed, but I've
> been trying to build it and run it and am running into problems. I want
> to build the jdbc2 version of the driver, but I'm not sure how to do
> this. It isn't really documented, although I'll be the first to admit I
> haven't read everythin - I'm basically looking for a shortcut. The
> jdbc3 version doesn't work with JNI - it crashes for some reason.
>
> Thanks,
> Shawn Green
>
>
>
> ______________________________________________________________________
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Dave Cramer <Dave(at)micro-automation(dot)net>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-03-25 02:27:43 Re: DatabaseMetaData.getImportedKeys returning duplicate
Previous Message Barry Lind 2003-03-25 02:07:52 Re: updateRow bug fix (possible) and build questions