Look at the SQL given with the error message:
What happens if you run this in a SQL client? Does it work? If not, what changes would you need to make to fix this?
There's a quick fix for the code you've shown, but more generally, it's probably a good idea to use a PreparedStatement for this. Since you're using Spring's jdbcTemplate, this functionality is found in the 3-arg version of update(), not the single-arg version that you used. See example
here - the part about