java SQLException:执行查询时列类型无效
Sql查询:
UPDATE_CHILD=UPDATE ANALYSIS_EXEC_CHILD SET STATUS = :tostatus
WHERE PARENT_EXEC_ID = :parentId AND STATUS IN (:currentStatus)
Java代码:
sql = propUtil.getPropertyValue("UPDATE_CHILD");
paramMap = new MapSqlParameterSource();
paramMap.addValue("tostatus", toStatus);
paramMap.addValue("parentId", parentExecId);
paramMap.addValue("currentStatus", Arrays.asList(currentStatuses.toArray()));
updateStatus = this.jdbcTemplate.update(sql,paramMap);
获取错误:
SQL state [99999]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type JDBC
共 (0) 个答案