Re: BLOB performance test FYI - Mailing list pgsql-jdbc

From Marin Dimitrov
Subject Re: BLOB performance test FYI
Date
Msg-id 000701c1e6cb$b4a81b30$9b0e32d4@sirma.bg
Whole thread Raw
In response to Re: BLOB performance test FYI  ("Joe Shevland" <jshevland@j-elite.com>)
Responses Re: BLOB performance test FYI  (Anders Bengtsson <ndrsbngtssn@yahoo.se>)
List pgsql-jdbc
----- Original Message -----
From: "Anders Bengtsson"

>
> It would imply a change in semantics of a PreparedStatement, that it
> could only be executed one time once the parameters are set. But I
> wouldn't be surprised if that is what the JDBC spec. says anyway.
>

doesn't seem so ,  it says:

"The values set for the parameter markers of a PreparedStatement object are
not
reset when it is executed. The method clearParameters can be called to
explictly
clear the values that have been set. Setting a parameter with a different
value will
replace the previous value with the new one."

...which IMHO implies multiple executions with the same parameters should be
possible


    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "




pgsql-jdbc by date:

Previous
From: Anders Bengtsson
Date:
Subject: Re: BLOB performance test FYI
Next
From: cc.ais40@wanadoo.fr
Date:
Subject: ResulSet for short