MySQL Problem !!!

[Siddharth Bhargava]

I am using jdbcTemplate and while getting the value of the User I am getting an exception .... I am attaching my code snippet.....

 
public User getUser(final Integer id) {
// TODO Auto-generated method stub

String sql = "select id, firstName, lastName, address, age from user " +
  "where id = '?'";
final User user = new User();

final Object[] params = new Object[]{id};

jdbcTemplate.query(sql, params, new RowCallbackHandler(){
 
public void processRow(ResultSet rs) throws SQLException {
// TODO Auto-generated method stub
user.setId(new Integer(rs.getInt("id")));
user.setFirstName(rs.getString("firstName"));
user.setLastName(rs.getString("lastName"));
user.setAddress(rs.getString("address"));
user.setAge(new Integer(rs.getInt("age")));
}
});
return user;
}

The exception which is coming is as follows:

  
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select id, firstName, lastName, address, age from user where id = '?']; SQL state [S1009]; error code [0]; Parameter index out of range (1 > number of parameters, which is 0).; nested exception is java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:582)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
at com.springdatabase.example.UserDaoImpl.getUser(UserDaoImpl.java:31)
at com.springdatabase.example.JDBCTemplateApplication.main(JDBCTemplateApplication.java:76)
Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2796)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2827)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:2778)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3035)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:266)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:88)
at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:51)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:621)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:566)
 

Please tell me the solution to this problem and tell me where i am going wrong.... Thanks in advance ...

[Bob Good]

Perhaps the '?' parameter should be ?

[Siddharth Bhargava]

I checked with ? also instead of '?' but its giving problem with it also ...

[Bob Good]

The same exception or a different one?
Please post it...

You old one was this:
Parameter index out of range (1 > number of parameters, which is 0).
[ February 01, 2008: Message edited by: Bob Good ]