绑定异常:Invalid bound statement (not found)
记录一下遇到的问题
java.util.concurrent.ExecutionException: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.gooluke.biz.integration.dao.PlayerDAO.selectPlayerList
这里出现的问题是创建sqlSessionFactory的时候没有指定mapper.xml的路径,导致找不到
@Bean("sqlSessionFactory")
public SqlSessionFactory sqlSessionFactory(DataSource dataSource) {
try {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource);
//没有配置mapper.xml所在路径
return sqlSessionFactoryBean.getObject();
} catch (Exception e) {
logger.error("create sqlSessionFactoryBean error", e);
throw new RuntimeException("create sqlSessionFactoryBean error");
}
}
@Bean("dataSource")
public DataSource dataSource(@Value("${jdbc.datasource.driverClassName}") String driverClassName,
@Value("${jdbc.datasource.url}") String url,
@Value("${jdbc.datasource.username}") String username,
@Value("${jdbc.datasource.password}") String password
) {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(driverClassName);
druidDataSource.setUrl(url);
druidDataSource.setUsername(username);
druidDataSource.setPassword(password);
return druidDataSource;
}
只需要配置mapper.xml所在路径即可
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
Resource[] resources = resolver.getResources("classpath:/mapper/*.xml");
sqlSessionFactoryBean.setMapperLocations(resources);
另外再记录几点导致绑定异常的常见原因:
1.未配置扫包路径:@MapperScan(basePackages = “com.gooluke.biz.integration.dao”)
2.mapper.xml中的namespace和实际的mapper文件不一致
3.mapper接口中的方法名和mapper.xml中的id标签不一致
4.创建sqlSessionFactory的时候没有指定mapper.xml的路径