Binding parameter as PostgreSQL array

Question

I'm trying to bind a prepared statement parameter which is a "multidimensional" PostgreSQL array. Here's an array example (column type is numeric[]):

{{1,10},{2,20}}

How do I bind a value like that using a prepared statement? I tried:

stmt.setObject(1, "{{1,10},{2,20}}", Types.ARRAY);

It didn't work:

Cannot cast an instance of java.lang.String to type Types.ARRAY

Any ideas?

something like this: `stmt.setObject(1, new Integer[][] {{1,10},{2,20}}, Types.ARRAY)`? — Roman Pekar, Sep 06 '13 at 12:55

score 16 · Accepted Answer · answered Sep 06 '13 at 13:20

Try something like this (untested):

                ------------------ your connection
                V
Array inArray = conn.createArrayOf("integer", new Integer[][] {{1,10},{2,20}});
stmt.setArray(1, inArray);

Links:

Binding parameter as PostgreSQL array

1 Answers1

Linked

Related