Re: PreparedStatement clearParameters and setTimestamp - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: PreparedStatement clearParameters and setTimestamp
Date
Msg-id Pine.BSO.4.63.0608061304350.31226@leary2.csoft.net
Whole thread Raw
In response to Re: PreparedStatement clearParameters and setTimestamp  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

On Tue, 25 Jul 2006, Kris Jurka wrote:

> On Tue, 25 Jul 2006, Akira Sato wrote:
>
>> With case of setTimestamp(), it seem to always do "Parse".
>> (setDate() and setTime() too)
>>
>
> When determining if a statement must be reparsed the driver checks that the
> parameters it currently has match with the previous execution.  This
> comparison is being done with the values returned from the server for the
> previous execution, not the values sent to the server.  So you parse once
> with oid 0 and it comes back with the oid of the resolved type, say 1184 for
> timestamptz.  The next time through you again have oid 0 from setTimestamp,
> and it compares 0 == 1184? and it determines they don't match and it must be
> reparsed.
>
> The attached patch fixes your test case for me, but I haven't applied it yet
> as I'd like to do some more testing.  It doesn't allows oid 0 to match any
> type the server resolves.
>

Applied to 8.0, 8.1, and 8.2dev.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] [PATCHES] log_statement output for protocol
Next
From: Kris Jurka
Date:
Subject: Re: Callablestatement's resulting resultset not scrollable