org.springframework.beans.TypeMismatchException: Failed to convert property valu

org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'null' to required type 'int' for property 'order'; nested exception is java.lang.IllegalArgumentException: Cannot convert value of type [null] to required type [int] for property 'order': PropertyEditor [org.springframework.beans.propertyeditors.CustomNumberEditor] returned inappropriate value

spring jdbc 执行

resultList = this.namedJdbcTemplate.query(sqlbf.toString(), paramSource, mappingResult(CommonConfigVO.class));

private RowMapper mappingResult(Class<?> resultBean) {
		return new BeanPropertyRowMapper(resultBean);
	}

 报错，数据库中 order 有 0 和null

 

从数据库中取出来的order值必须是int 如何Null 就会报错，所以数据库最好有个默认值为0.

 

 

评论

2 楼 woshixushigang 2013-06-13  

good

1 楼 nathanleewei 2013-06-04  

org.springframework.jdbc.core.BeanPropertyRowMapper.setPrimitivesDefaultedForNullValue(true);
or
org.springframework.jdbc.core.ParameterizedBeanPropertyRowMapper.setPrimitivesDefaultedForNullValue(true);