How to do in-query in jDBI?

This should work: @SqlQuery(“select id from foo where name in (<nameList>)”) List<Integer> getIds(@BindIn(“nameList”) List<String> nameList); Don’t forget to annotate class containing this method with: @UseStringTemplate3StatementLocator annotation (beacuse under the hood JDBI uses Apache StringTemplate to do such substitutions). Also note that with this annotation, you cannot use ‘<‘ character in your SQL queries without escaping … Read more