Spring JDBC error: Can't pass value to NamedParameter

[Philip Freeman]

@Component("worldDAO")
public class WorldDAO 
{
	private NamedParameterJdbcTemplate jdbc;
	
	@Autowired
	public void setDataSource(DataSource jdbc) {
		this.jdbc = new NamedParameterJdbcTemplate(jdbc);
	}

	public List<Country> getCountries()
	{
		MapSqlParameterSource whichCountry = new MapSqlParameterSource();
		whichCountry.addValue("value", "Sweden");
		
		return jdbc.query("SELECT * FROM world.country WHERE name = :value", new RowMapper<Country>(){

			public Country mapRow(ResultSet rs, int rowNum) throws SQLException 
			{
				Country country = new Country();
				country.setCode(rs.getString("Code"));
				country.setName(rs.getString("Name"));
				country.setContinent(rs.getString("Continent"));
				country.setRegion(rs.getString("Region"));
				country.setSurfaceArea(rs.getDouble("SurfaceArea"));
				country.setIndepYear(rs.getInt("IndepYear"));
				country.setPopulation(rs.getInt("Population"));
				country.setLifeExpentancy(rs.getInt("LifeExpectancy"));
				country.setGnp(rs.getDouble("GNP"));
				country.setGnpOld(rs.getDouble("GNPOld"));
				country.setLocalName(rs.getString("LocalName"));
				country.setGovernmentForm(rs.getString("GovernmentForm"));
				country.setHeadOfState(rs.getString("HeadOfState"));
				country.setCapital(rs.getString("Capital"));
				country.setCode2(rs.getString("Code2"));
				return country;
			}
			
			
		});
	}
 

}

If I replace the

return jdbc.query("SELECT * FROM world.country WHERE name = :value", new RowMapper<Country>(){

with:

"SELECT * FROM world.country WHERE name = 'Germany'"

, no error is thrown and there is no issue.
While if I use the named parameter an error pops up: org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'value': This SqlParameterSource is empty


What did I miss?

[Philip Freeman]

Found my mistake.

 return jdbc.query("SELECT * FROM world.country WHERE name = :value", new RowMapper<Country>()

Should be:

 return jdbc.query("SELECT * FROM world.country WHERE name = :value",[b] whichCountry, [/b]new RowMapper<Country>()

[Jeanne Boyarsky]

Thanks for posting the solution which you found quickly. Sometimes the act of explaining a problem helps one answer it!