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 String value "00:00:00" for instance.
In version 7 this gets executed as "select localtimestamp - time '00:00:00'",
while version 8 try to execute it as "select localtimestamp - time 00:00:00",
which of cause fails since the quotes are missing.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
