PreparedStatement setObject - Mailing list pgsql-patches

From Kobus Walters
Subject PreparedStatement setObject
Date
Msg-id 4D5BA04438D6FE4A9437F57B6AB87B47501E8D@hermes.iveri.com
Whole thread Raw
List pgsql-patches
Setting java.lang.String values with the setObject method in version 8 of the pgsql-jdbc driver
(postgresql-8.0-310.jdbc3.jar)does not work as with version 7 (pg74.215.jdbc3.jar) of the driver. Example: 

Create a prepared statement with sql "select localtimestamp - time ?". Call setObject(1, java.lang.String) with the
Stringvalue "00:00:00" for instance. In version 7 this gets executed as "select localtimestamp - time '00:00:00'",
whileversion 8 try to execute it as "select localtimestamp - time 00:00:00", which of cause fails since the quotes are
missing.



pgsql-patches by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Re: WIP: bufmgr rewrite per recent discussions
Next
From: Tom Lane
Date:
Subject: WIP: buffer manager rewrite (take 2)