记一次粗心导致的错误：new PathMatchingResourcePatternResolver().getResource（“classpath:mapper/db2/*.xml“）

忘是亡心i 2023-09-27 10:23 63阅读 0赞

#### 错误日志如下： ####

> Caused by: java.io.FileNotFoundException: class path resource \[mapper/db2/\*.xml\] **cannot be opened because it does not exist**  
> at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:180) ~\[spring-core-5.2.12.RELEASE.jar:5.2.12.RELEASE\]  
> at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:591) ~\[mybatis-spring-2.0.3.jar:2.0.3\]  
> ... 74 common frames omitted

#### Java错误段的代码： ####

@Bean(name = "db2SqlSessionFactory")
    public SqlSessionFactory sqlSessionFactory(@Qualifier("db2DataSource") DataSource dataSource) throws Exception {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            bean.setDataSource(dataSource);
            bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResource("classpath:mapper/db2/*.xml"));
            return bean.getObject();
    }

#### 错误原因： ####

我粗心使用了：

> **PathMatchingResourcePatternResolver.getResource（）方法，该方法只能精准的获取到指定的文件，不能匹配通配符\*，因此导致文件找不到异常！**
> 
> **解决：**
> 
> **PathMatchingResourcePatternResolver.getResource（）方法**
> 
> **替换为：**
> 
> **PathMatchingResourcePatternResolver.getResources（）方法即可！**

#### **getResource与getResources的区别：** ####

> **Resource resource = PathMatchingResourcePatternResolver.getResource(String path);**
> 
> **1、path：不支持通配符\***
> 
> **2、返回的是单个Resource 对象**
> 
> **Resource\[\] resource = PathMatchingResourcePatternResolver.getResources(String path);**
> 
> **1、path：支持通配符\***
> 
> **2、返回的是一个Resource 对象的数组**

**SqlSessionFactoryBean.setMapperLocations（）方法，参数为Resource类型的不定数组，因此，getResource与getResources都支持**