Why I get IncorrectResultSetColumnCountException?

[hubaghdadi]

Hi.
I have this class:

class F1 {
  Long id;
  String name;
  
  //empty const and setter and getters
}

Inside the DAO:

String sql = "select id, name from f1;
return namedParameterJdbcTemplate.queryForList(sql, new HashMap(), F1.class);

But I got this exception:
org.springframework.jdbc.IncorrectResultSetColumnC ountException
I tried:
return namedParameterJdbcTemplate.queryForList(sql, new HashMap());
It works.
Why?
Thank you all.

[Marten Deinum]

I suggest you read the javadocs of the class and read the reference guide on how to use Spring JDBC.

You can only use it for resultsets with 1 column, not multiple. It only works for simple arguments i.e. String, Integer etc. not for custom classes. If you want to map custom classes you need to implement a RowMapper and use that instead.