Re: Arrays and JDBC :: setObject causes array_in Need to - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Arrays and JDBC :: setObject causes array_in Need to
Date
Msg-id 1086059579.1592.12.camel@localhost.localdomain
Whole thread Raw
In response to Arrays and JDBC :: setObject causes array_in Need to specify dimension  (tyagel@yahoo.com (tyagel))
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Question about connections
Next
From:
Date:
Subject: ...