Yes, because it thinks "1,2,3" is a string
you would have to do
IN(?,?,?)
then
setObject(1, 1);
setObject(2, 2);
setObject(3, 3);
Dave
On 13-Jun-05, at 9:08 AM, Sergey Pariev wrote:
> Hi all.
> It may be stupid question, but is there way to use
> PreparedStatement with queries like
> SELECT * FROM mytable WHERE t_id IN (1,2,3) ?
> I've googled but haven't found nothing explicitly said on this
> topic.
> I've tried the following
> PreparedStatement st = conn.prepareStatement("SELECT * FROM
> mytable WHERE t_id IN ( ? )");
> st.setObject(1,"1,2,3");
>
> and get error complaining on type mismatch.
>
> Thanks in advance, Sergey.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
>