second try. On 28 October 2016 at 15:24, Anil <[email protected]> wrote:
> Any inputs please ? > > On 28 October 2016 at 09:27, Anil <[email protected]> wrote: > >> Hi Val, >> >> the below one is multiple IN queries with AND but not OR. correct ? >> >> SqlQuery with join table worked for IN Query and the following prepared >> statement is not working. >> >> List<String> inParameter = new ArrayList<>(); >> inParameter.add("8446ddce-5b40-11e6-85f9-005056a90879"); >> inParameter.add("f5822409-5b40-11e6-ae7c-005056a91276"); >> inParameter.add("9f445a19-5b40-11e6-ab1a-005056a95c7a"); >> inParameter.add("fd12c96f-5b40-11e6-83f6-005056a947e8"); >> PreparedStatement statement = conn.prepareStatement("SELECT p.name FROM >> Person p join table(joinId VARCHAR(25) = ?) k on p.id = k.joinId"); >> statement.setObject(1, inParameter.toArray()); >> ResultSet rs = statement.executeQuery(); >> >> Thanks for your help. >> > >
