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).

More Related Contents:

  1. How to overcome the Permgen Space Exception Without restarting the Server.., Can any one help me
  2. Java – escape string to prevent SQL injection
  3. Hibernate show real SQL [duplicate]
  4. Dates with no time or timezone component in Java/MySQL
  5. Using setDate in PreparedStatement
  6. How to get SQL from Hibernate Criteria API (*not* for logging)
  7. what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?
  8. How can you call custom database functions with Hibernate?
  9. Getting output from dbms_output.get_lines using JDBC
  10. Java – Can’t use ResultSet after connection close
  11. Timezones in SQL DATE vs java.sql.Date
  12. SQL prepared statement how to select via multiple possible menu selections?
  13. Is there any good dynamic SQL builder library in Java? [closed]
  14. MyBatis Batch Insert/Update For Oracle
  15. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  16. Storing UUID as base64 String
  17. How can I detect a SQL table’s existence in Java?
  18. How to prevent SQL Injection with JPA and Hibernate?
  19. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  20. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  21. Having a Column name as Input Parameter of a PreparedStatement
  22. Can I have H2 autocreate a schema in an in-memory database?
  23. JPA Native Query select and cast object
  24. JPA 2 CriteriaQuery, using a limit
  25. Hibernate Criteria API: get n random rows
  26. Is MERGE an atomic statement in SQL2008?
  27. Database independence through JDBC in java
  28. How to escape colon `:` within a native SQL query in Hibernate?
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Does JPA support mapping to sql views?

Leave a Comment