Passing list of IDs to SQL Statement

Question

This code:

ids = "1245, 4526, 7689, 8001";
jdbcTemplate.update("DELETE FROM my_table WHERE id IN (?)", new Object[] { ids });

throws the following exception:

(...) nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

How do I pass the list of IDs to the above sql statement?

Not sure what jdbcTemplate's type is in your case but you may want to check this. http://stackoverflow.com/questions/1305240/how-to-set-list-of-parameters-on-prepared-statement — peter.petrov, Dec 18 '13 at 09:50

Shoaib Chikate · Answer 1 · 2013-12-18T18:15:30.437

1

Your query is wrong.You can't pass list to single arguement.

Try this.

jdbcTemplate.update("DELETE FROM my_table WHERE id IN (?,?,?,?)", new Object[] { 1245, 4526, 7689, 8001});

edited Dec 18 '13 at 18:15

answered Dec 18 '13 at 09:47

Shoaib Chikate

The first one won't work, a placeholder is a single value not a list, unless JDBC template (or the specific driver) does some magic. – Mark Rotteveel Dec 18 '13 at 11:57
Yupe so i change my answer. – Shoaib Chikate Dec 18 '13 at 18:14

1 Answers1