Don't think you can do this in Derby. However, you can do: SELECT * FROM Names WHERE ID IN (?, ?, ?)
and bind individual elements of the array to each of the parameters. This, of course, forces you to know the number of elements of the array.. Satheesh Tony Seebregts wrote: > Hi, > > Does anybody know of a way to use a PreparedStatement with a WHERE IN > (?) clause > > e.g. SELECT * FROM Names WHERE ID IN (?) > > where the parameter is replaced by an array of e.g. int's ? > > regards > > Tony Seebregts > > > >
