effizient query with jdbc

 Hi,
 I have a java.util.List of values (10000) which i wanted to use for a
 query in the where clause of an simple select statement. iterating
 over the list and and use an prepared Statement is quite slow. Is
 there a more efficient way to execute such a query.  Thanks for any
 help.  Johannes
 .....
 List ids = new ArrayList();

 .... List is filled with 10000 values ...

 List uuids = new ArrayList();
 PreparedStatement pstat = db.prepareStatement("SELECT UUID FROM
 MDM.KEYWORDS_INFO WHERE KEYWORDS_ID = ?");  for (Iterator iter =
 ids.iterator(); iter.hasNext();) { String id = (String) iter.next();
 pstat.setString(1, id);
 rs = pstat.executeQuery();
 if (rs.next()) {
 uuids.add(rs.getString(1));
 }
 rs.close();
 }
 ...