Re: IN clauses via setObject(Collection) [Was: Re: Prepare

Fernando Nasser wrote:

> Darin Ohashi wrote:
>
>>> There is no technical reason why sql prepare cannot support "IN ?"
>>> If it is not supported by the backend at the moment should not
>>> affect the general decision of whether or not having such a feature
>>> is useful to have in the jdbc driver or not.
>>>
>
> Unfortunately it does.  How can we justify a feature that only works
> when we are simulating prepared statements and fails when we are using
> the real PREPARED statements as provided by the server?

It should not *fail* of course.
The driver should take care of it. If the backend does not support
PREPARE/EXECUTE with sets as parameters, the driver should  know about
that, and handle it as a special case

Dima