Postgresql error when trying to insert Long array

Question

ArrayList temp2 = new ArrayList();

Im filling this arraylist with longs.

When i am trying to insert this into the postgresql, i use the following:

UPDATE pb1plnitm SET parents_pb1plnitm_unid = ARRAY[?] WHERE pb1plnitm_unid = ?", temp2, xmlForm.getFieldValueLong("uniqueid"));

Using JDBC template. But when i try to run this code it gives a error on the "ARRAY[?]". But if temp2 is a single number like: 1253214, it works. Does anyone have an idea?

My error is:

PreparedStatementCallback; bad SQL grammar [UPDATE pb1plnitm SET parents_pb1plnitm_unid = ARRAY[?] WHERE pb1plnitm_unid = ?]; nested exception is org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of [Ljava.lang.Long;. Use setObject() with an explicit Types value to specify the type to use.

Dark Knight · Accepted Answer · 2016-11-02 08:09:49Z

2

as mentioned in error description, make use of setObject() method

For Example:

Array sqlArray = conn.createArrayOf("text", anyArray);
    pstmt.setArray(1, sqlArray);
    pstmt.executeUpdate();

answered Nov 2, 2016 at 8:09

Dark Knight

8,3574 gold badges41 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

You also need to remove the array[?] part and only use SET parents_pb1plnitm_unid = ?

Collectives™ on Stack Overflow

Postgresql error when trying to insert Long array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related