Re: [BUGS] PreparedStatement setObject

2005-02-13 Thread Oliver Jowett
Kobus Walters wrote: 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 l

[BUGS] PreparedStatement setObject

2005-02-13 Thread Kobus Walters
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, ja