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 3F1C4DA5.4040402@openratings.com
Whole thread Raw
In response to Re: IN clauses via setObject(Collection) [Was: Re: Prepare  (Darin Ohashi <DOhashi@maplesoft.com>)
List pgsql-jdbc
>
>
>So, yes you should be able to create a set datatype and pass that into the
>PreparedStatment (JDBC allows for this using the SQLData interface, I don't know
>if postgresql supports it),
>
I know, that it doesn't

> but the data that is representing a set datatype
>would not be able to be inserted where SQL set Syntax is expected.
>
Why the hell not???

>  The set
>datatype and the SQL set Syntax are completely distinct objects.
>
>
An int datatype and an int syntax are two distinct objects too :-)
That's precisely the job of the JDBC driver to convert datatypes I pass
in into their representation with the correct syntax that backend would
understand.

I would have no use of the driver doing anything else - what's the point
in passign data in if the syntax it gets converted into isn't understood
by the server?

Dima


pgsql-jdbc by date:

Previous
From: Darin Ohashi
Date:
Subject: Re: IN clauses via setObject(Collection) [Was: Re: Prepare
Next
From: Barry Lind
Date:
Subject: Re: jdbc batch performance problem