----- 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. "