Re: IN clauses via setObject(Collection) [Was: Re: Prepare - Mailing list pgsql-jdbc

From Dmitry Tkach
Subject Re: IN clauses via setObject(Collection) [Was: Re: Prepare
Date
Msg-id 3F1C49A9.3010101@openratings.com
Whole thread Raw
In response to Re: IN clauses via setObject(Collection) [Was: Re: Prepare  (Fernando Nasser <fnasser@redhat.com>)
List pgsql-jdbc
>
> You are suggesting that when the driver detects that one of the
> parameters is the value for an IN clause (i.e., an <in values list>)
> it should abstain to use the server prepared statements and falls back
> to use the client emulation instead?   Isn't that a little unsettling
> for the user, who is expecting that the prepared statements are being
> handled by the server?


Yep. It is indeed a little unsetting... Much *less* unsetting though
then just not being able to do that at all...

>
>
> You understand, also, that we would have to keep the client emulation
> code around with all complications and limitations that it has (for
> not being in the server)even when all supported backend versions have
> PREPARED implemented.
>
>
Well... yes. Unless all supported backend versions will also have
PREPARE implemented to understand sets...

The only alternative is to have this code "with all complications and
limitantions" be kept and maintain by every user on their own...

Dima


pgsql-jdbc by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: IN clauses via setObject(Collection) [Was: Re: Prepare
Next
From: Darin Ohashi
Date:
Subject: Re: IN clauses via setObject(Collection) [Was: Re: Prepare