SQLParameterSource « Database « Spring Q&A

  1. Spring Q&A
  2. Database
  3. SQLParameterSource




1. SQLParameterSource causes "nvalid column type"...why?    forum.springsource.org

JdbcTemplate jt = new JdbcTemplate(dataSource); String sqlStr = "DELETE FROM mytab WHERE someval = :someval"; MapSQLParameterSource p = new MapSQLParameterSource().addValue("someval", 1234); jt.update(sqlStr, p);

2. invalid column type error for char type using SqlParameterSource    forum.springsource.org

invalid column type error for char type using SqlParameterSource Hello, I'm doing batch insert as given below. I have a char field in the object. I think because of that field, ...

3. Can we use SqlParameterSource for executing procedure.    forum.springsource.org

Can we use SqlParameterSource for executing procedure. Hi All, Defined procedure & execution as follows: Code: private class EmployeeProcedure extends StoredProcedure{ public EmployeeProcedure(){ super(); setDataSource(jdbcTemplate.getDataSource()); setSql(CREATE_EMPLOYEE_PROC); declareParameter(new SqlOutParameter("return_employee_id", Types.VARCHAR)); declareParameter(new SqlParameter("emp_name", ...