Re: setArray

Hi,

I recently had to solve this too. What I did is:

1) I created class that implements java.sql.Array (it is sufficient to
implement getArray(), getBaseType(), getBaseTypeName() and toString(),
for details see Java API docs) + I added one extra method,
setArray(Class componentType, Object[] array), where componentType is
component type of the array, which I use for setting the array value
into the array

2) Then I use this code to set the array:

                    final MyArray array = new MyArray();
                    array.setArray(componentType, arrayValue);
                    pstm.setArray(index, array);

HTH

--
Miroslav Šulc



Alex Stienstra napsal(a):
> Hi,
>
> Iam trying to set an array in a prepared statement like this:
>
> PreparedStatement stmnt = ds.prepareStatement(
>  "INSERT INTO trainingen (\"Atleet\", \"Datum\", \"Tijdstip\",
> \"Afstand\", \"Tijd (Zone)\") VALUES (?,?,?,?,?)"
> );
>    stmnt.setString(5, "{1,2,3,4,5,6}");
>
> Assuming that the 5th parameter is an array of integer i get the
> follow error message:
>
> ERROR: column "Tijd (Zone)" is of type integer[] but expression is of
> type character varying
>
> I understood from previous discussions that the driver underwater will
> convert the parameter of setArray
> into a string representation like i do in the example above. I there
> any other way of setting an array
> field in a prepared statement?
>
> Alex.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly