Is the SQL used in jdbcTemplate native SQL? If yes, query will be different depending on underlaying Database. For example, MySQL vs Oracle.
return jdbcTemplate.queryForList("select * from PERSON where last_name = ?",
new Object[] {name}
);
Updated:
I found the answer here. Yes it depends on underlying DB.
How to ignore database tablename case-sensitivity using Spring's JdbcTemplate?