NamedParameterORJdbcTemplate attempting to pass list as a parameter with hextoraw val

[ncsekhar25]

Hi,

I would like to execute below SQL query using JDBCTemplate OR NamedParameterJdbcTemplate.

DELETE FROM bar WHERE foo IN (hextoraw('X'),hextoraw('X'),hextoraw('X'));

Map<String, Object> namedParameters = new HashMap<String, Object>();
namedParameters.put("testList", testList);

int rowsDeleted = getNamedParameterJdbcTemplate().update(deleteQuery , namedParameters);

How to pass hextoraw() function to each parameter value? Is there way we can mention to wrap value with hextoraw()?

Thanks