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

From Oliver Jowett
Subject IN clauses via setObject(Collection) [Was: Re: Prepared Statements]
Date
Msg-id 20030721154748.GN2506@opencloud.com
Whole thread Raw
In response to Re: Prepared Statements  (Fernando Nasser <fnasser@redhat.com>)
Responses Re: IN clauses via setObject(Collection) [Was: Re: Prepared Statements]  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
On Mon, Jul 21, 2003 at 11:26:11AM -0400, Fernando Nasser wrote:

> I think Dima is arguing that Collection could be treated as an special case
> where it indicates a list of something instead of a single something.
>
> So, we would iterate through this Collection using its iterator and, for
> each Object obtained, act like a setObject has been used with that Object
> and the JAVA TYPE as an argument.
>
> The Types.OTHER is used for database specific SQL types or for Dynamic Data
> Access support.  As the Collection class is not a data type there is no
> chance of confusion.

Ya, I understand. My main objection is that setObject(n, object,
Types.INTEGER), in all other cases, means "interpret object as an integer,
or fail if it can't be cast in that way".

-O

pgsql-jdbc by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: patch: clean up ant test infrastructure
Next
From: Fernando Nasser
Date:
Subject: RFC: Removal of support for JDBC1 drivers.