Thread: Arrays and JDBC :: setObject causes array_in Need to specify dimension

Im repositing this question from Friday as it ended up on the end of a
year old thread that did not answer my question ...

I have created a database table with and int[] column and I would like
to insert records into this table using JDBC.

The JDBC documentation that I have read seems to indicate that I
should use setObject when inserting the int[] into my
PreparedStatement.

When I attempt to insert the record with the int[] that was set via
setObject I get an error reading "array_in: Need to specify
dimension".

Any help with this would be greatly appreciated.

Thanks,
Thomas

I'm not too familiar with arrays, but I think you need to use the
setArray method in the preparedStatement interface.

Dave
On Mon, 2004-05-24 at 09:23, tyagel wrote:
> Im repositing this question from Friday as it ended up on the end of a
> year old thread that did not answer my question ...
>
> I have created a database table with and int[] column and I would like
> to insert records into this table using JDBC.
>
> The JDBC documentation that I have read seems to indicate that I
> should use setObject when inserting the int[] into my
> PreparedStatement.
>
> When I attempt to insert the record with the int[] that was set via
> setObject I get an error reading "array_in: Need to specify
> dimension".
>
> Any help with this would be greatly appreciated.
>
> Thanks,
> Thomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Dave Cramer
519 939 0336
ICQ # 14675561