OK, after a lot of searching, I see two ways dealing with this: The first option is to retrieve an object for each column and merge it in the Java code at the resource (i.e. do the join in the code instead of having it done by the database). This would result in something like … Read more
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
(I am the primary author of jDBI) jDBI is a convenience library built on top of JDBC. JDBC works very well but generally seems to optimize for the database vendors (driver writers) over the users. jDBI attempts to expose the same functionality, but in an API optimized for users. It is much lower level than … Read more