How to use SELECT IN clause in JDBCTemplates?

by

There is a workaround using NamedParameterJdbcTemplate instead of SimpleJdbcDaoSupport, where you can do something like this:

List integerList = Arrays.asList(new Integer[] {1, 2, 3});
Map<String,Object> params = Collections.singletonMap("fields", integerList);    
Long id = namedParameterJdbcTemplate.queryForLong("SELECT * FROM table WHERE field IN (:fields)", params);

This, however, has a potentially catastrophic limitation regarding the number of parameters you can pass in the list which depends on the DB you are using.

More Related Contents:

  1. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  2. Spring JDBC Template for calling Stored Procedures
  3. Spring JPA @Query with LIKE
  4. Jdbctemplate query for string: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
  5. NamedParameterJdbcTemplate vs JdbcTemplate
  6. Iterating through a List Object in JSP
  7. Understanding Spring @Autowired usage
  8. Spring JSON request getting 406 (not Acceptable)
  9. How can I detect a SQL table’s existence in Java?
  10. Spring MVC + JSON = 406 Not Acceptable
  11. spring Exception when running application on WebSphere with java 8
  12. Missing CrudRepository#findOne method
  13. Injecting EntityManager Vs. EntityManagerFactory
  14. How to reload authorities on user update with Spring Security
  15. Where to put @Transactional? In interface specification or implementation? [duplicate]
  16. Creating a post commit when using transaction in Spring
  17. How To Configure MongoDb Collection Name For a Class in Spring Data
  18. Unable to get a generic ResponseEntity where T is a generic class “SomeClass”
  19. java.lang.IllegalStateException: No transactional EntityManager available
  20. Hibernate Criteria API: get n random rows
  21. How is Spring actually bootstrap?
  22. AspectJ pointcut expression match parameter annotations at any position
  23. Spring application context : access web.xml context-params?
  24. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  25. org.openqa.selenium.WebDriverException: Timed out waiting for driver server to start. Build info: version: ‘unknown’, revision: ‘unknown’
  26. Spring – Modifying headers for every request after processing (in postHandle)
  27. RestTemplate with pem certificate
  28. java.lang.ClassNotFoundException: org.springframework.web.servlet.DispatcherServlet error
  29. Can we declare spring bean conditionally?
  30. Spring MVC: How to modify json response sent from controller

Leave a Comment