How to do in-query in jDBI?

by

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 (beacause it is a special symbol used by StringTemplate).

Leave a Comment

techhipbettruvabetnorabahisbahis forumu