Error in executing Spring Query

[Mary Cole]

HI,
I have a method which returns the a single row from a particular table. When I run the method, I get this wierd exception. Any idea where I am wrong?

MapSqlParameterSource sqlParams = new MapSqlParameterSource();
		sqlParams.addValue("param1", param);
		return this.namedParameterJdbcTemplate.queryForObject(
				"Select * from tableA where column2=:param1", sqlParams,ResultClassVO.class);

org.springframework.jdbc.IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 8
	at org.springframework.jdbc.core.SingleColumnRowMapper.mapRow(SingleColumnRowMapper.java:87)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:701)
	at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:177)
	at org.springframework.jdbc.core.namedparam.NamedPar

[Christophe Verré]

queryForObject(String, SqlParameterSource, Class<T>) is expecting a single row and a single column, but you are retreiving several columns. Look in the API for other query methods which would suit your needs.

(I would not encourage you to use "Select *" in any query as it can be a source of bugs)

[Mary Cole]

Can you please let me know which one should I use? Is it possible not to use RowMapper and populate the result in a VO object?

[Christophe Verré]

Mary Cole wrote:Is it possible not to use RowMapper and populate the result in a VO object?

No, that's what a RowMapper is used for. You can use a BeanPropertyRowMapper if your properties match the column names.