How to set list of parameters on prepared statement?

Question

i have a list of names e.g.:

List<String> names = ...
names.add('charles');
...

and a statement:

PreparedStatement stmt = 
  conn.prepareStatement('select * from person where name in ( ? )');

how to do the following:

stmt.setParameterList(1,names);

Is there a workaround? can someone explain why this method is missing?

using: java, postgresql, jdbc3

Answer 1

This question is very old, but nobody has suggested using setArray

This answer might help https://stackoverflow.com/a/10240302/573057