How to set list of parameters on prepared statement?
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


How to set list of parameters on prepared statement?
===

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

