Re: updateRow bug fix (possible) and build questions - Mailing list pgsql-jdbc

From Shawn Green
Subject Re: updateRow bug fix (possible) and build questions
Date
Msg-id 15850B2D5ED56040A07CC8D2F2920E3F26BBE9@OTTAS07.ott.signiant.com
Whole thread Raw
In response to updateRow bug fix (possible) and build questions  ("Shawn Green" <shawn.green@signiant.com>)
Responses Re: updateRow bug fix (possible) and build questions
List pgsql-jdbc
Here is the difference:

*** AbstractJdbc2ResultSet.java Mon Mar 24 11:53:51 2003
--- AbstractJdbc2ResultSet.java.orig    Mon Mar 24 12:59:17 2003
***************
*** 1084,1093 ****
                                if ( Driver.logDebug )
                                        Driver.debug("done updates");

-                               // SMG:  Once the update is complete,
clear the update buffer so it isn't
-                               // applied again...
-                               clearRowBuffer ();
-
                                doingUpdates = false;
                        }
                        catch (Exception e)
--- 1084,1089 ----

-----Original Message-----
From: Barry Lind [mailto:blind@xythos.com]
Sent: March 24, 2003 9:08 PM
To: Shawn Green
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] updateRow bug fix (possible) and build questions

Shawn,

Can you send a context diff (diff -c) so that we can see what you have
changed?

thanks,
--Barry


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


pgsql-jdbc by date:

Previous
From: "David Hooker"
Date:
Subject: Re: Problem with updateRow() -- Revisited
Next
From: Dave Cramer
Date:
Subject: Re: DatabaseMetaData.getImportedKeys returning duplicate