Java异常解决总结

未解决问题springmvcajax-json

未解决问题已配置了注解扫描却仍然无法注入mapper

ssm整合解决碰到的异常

IncorrectResultSizeDataAccessException

spring异常

org.springframework.dao.IncorrectResultSizeDataAccessException:Incorrect result size: expected 1, actual 5

解决：

spring jdbcquery 有的RowMapper不能出现空数据或多条数据，查询要与方法对应

IncorrectResultSetColumnCountException

spring异常

org.springframework.jdbc.IncorrectResultSetColumnCountException:Incorrect column count: expected 1, actual 3

解决

大概意思是：查出的数据有4列，它把jdbc.queryForObject("SELECT* FROM USER WHERE ID = 1", User.class);中的第一列转换成User.class，所以 expected1, actual 6，预期1列，但查出来的数据有4列  修改:  RowMapper<User> rm =ParameterizedBeanPropertyRowMapper.newInstance(User.class);        User user = (User)this.jdbcTemplate.queryForObject(                "SELECT* FROM USER WHERE ID = 1", rm);

RowMapper实现类选错

springmvc页面servlet.init()异常，除了检查包冲突外 检查配置文件是否正确

BindingException

mybatis异常

org.apache.ibatis.binding.BindingException:Invalid bound statement (not found):resultmap.one2one.mapper.OrderMapper.selectOAUByResultmap

解决

mapper.xml找不到，记住mappers标签要用<mapperresource =”xml路径”></mapper>

原因是在idea中，使用<mapperclass=""></mapper>和 <packagename=""></package>标签将UserMapper.xml与UserMapper.class接口放一个包下，当运行时idea并不会将.xml拷至WEB-INF/classes中

TypeException

springmvc异常

nested exception isorg.apache.ibatis.builder.BuilderException: Error parsing SQL MapperConfiguration. Cause: org.apache.ibatis.type.TypeException: The alias 'Debug'is already mapped to the value 'com.mchange.v2.codegen.intfc.Debug'.

解决：

         在此标签中，包路径要尽可能具体，否则可能会抛出此异常

<typeAliases>

        <package name="com.ssm.po"></package>

</typeAliases>

NoSuchBeanDefinitionException

springmvc异常

UnsatisfiedDependencyException:Error creating bean with name 'fastJsonpResponseBodyAdvice' defined in URLnested exception isorg.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifyingbean of type 'java.lang.String[]' available: expected at least 1 bean whichqualifies as autowire candidate. Dependency annotations: {}

解决

         在此标签中，包路径要尽可能具体，否则可能会抛出此异常

<context:component-scan base-package="com.ssm.action"></context:component-scan>