Binding parameters as array postgres java

Question

I'm trying to bind a prepared statement parameter which is a array PostgreSQL. Here's an example Query:

prepareStatement("UPDATE " + emailsFromDb.get(i) +  " SET columne =testvalue '," + id + "' WHERE id IN (?)" );

I read from txt file value as array this is code read from txt

Scanner inFile1 = new Scanner(new File("file.txt"));
while(inFile1.hasNext()) {
    sb.append(inFile1.nextLine());
}
String[] testArray = sb.toString().split(", ");

and prepare the array in sql

Array bulkarr=  connector.createArrayOf("INT", testArray);
pr.setArray(1, bulkarr);

pr.executeUpdate();

and the result I have this error

2017-11-02 17:12:58 --ERROR-ApplicationErrorMessage : 
org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = integer[]
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 106

I need to update with where in array postgres

user330315 · Accepted Answer · 2017-11-02 17:30:32Z

1

The IN operator does not support arrays, you need to use ANY

WHERE id = ANY (?)

then you can pass an array, through setArray()

Unrelated, but: If you are using a PreparedStament you should pass all values through that. Concatenating input into a SQL string is a really, really bad idea.

answered Nov 2, 2017 at 17:30

user330315

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

1 Comment

apps eng Over a year ago

what can I do I need to update bukl from txt whta tis the best way ??

Collectives™ on Stack Overflow

Binding parameters as array postgres java

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