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

Just for reference, neither DB2 nor Oracle support passing the full list of
values as a single '?' parameter. In both cases you have to specify several ?
parameters (or :host variables) for each of the expected values.

Although I find this an annoying limitation, the fact remains that no
significant DBMS does what is being asked here.

PostgreSQL currently does not even accept '?' in the list. I have asked about
the possibility to support something in there. But even if the backend decides
to accept the full list it would be a PostgreSQL-only feature/enhancement and
not portable.

I feel very comfortable implementing standards but not at extending them. If
one day the standard body decides to implement it in a way different from the
way you did you end up with backward compatibility problems. Not to mention
that you end up tricking people into using some non-standard exception and
preventing them to use another DBMS. Although I see no reason to use anything
but PostgreSQL, this looks somewhat like M$ tactics ;-)

--
Fernando Nasser
Red Hat - Toronto E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9