Passing value to sql IN using JdbcTemplate

Question

I am trying to pass List in sql IN but I am getting invalid column type error. Here my SQL looks like:

String partyIdSql = "select party_id from myPartySearch where partyId = :id"
List<Long> partyIdList = new JdbcTemplate(dataSource)
  .queryForList(partyIdSql, new Object[] { id }, Long.class);


String currentRecordSql = "select * from myTable where someCol IN (:colVal)";
Map<String,Object>  params = new HashMap<String, Object>();
params.put("partyIdList", partyIdList);

memberInfo =  new JdbcTemplate(dataSource)
    .query(currentRecordSql , 
           new Object[] { params }, 
           new BeanPropertyRowMapper<MyDto>(MyDto.class));

Use a [MapSqlParameterSource with a NamedParameterJdbcTemplate](http://stackoverflow.com/a/14698678/1813382), like suggested earlier. — e-go, Dec 12 '14 at 22:23
use NamedParameterJdbcTemplate, see http://stackoverflow.com/a/16362128/217324 — Nathan Hughes, Dec 12 '14 at 22:25

score 1 · Accepted Answer · answered Dec 12 '14 at 22:44

Try this:

   Map<String,Object> params = Collections.singletonMap("fields", partyIdList );    
    namedParameterJdbcTemplate.query("select * from myTable where someCol IN (:fields)", new Object[] { params }, new BeanPropertyRowMapper<MyDto>(MyDto.class));

Passing value to sql IN using JdbcTemplate

1 Answers1