Spring Boot报错 java.lang.IllegalArgumentException:Property ‘sqlSessionFactory‘ or ‘sqlSessionTemp报错处理

谁践踏了优雅 2023-10-09 15:41 53阅读 0赞

## 问题描述 ##

启动SpringBoot主启动类后，出现如下错误

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'TBlogServiceImpl': Injection of resource dependencies failed
    	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:303)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1397)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521)
    	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
    	}
    	..............
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'TBlogDao' defined in file [D:\luopwork\ProgramCode\Idea_project_Code\LpBlog\lpblog\lpblog-system\target\classes\com\lp\system\dao\TBlogDao.class]: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1751)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521)
    		... 22 common frames omitted
    		......................
    Caused by: java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required
    	at org.springframework.util.Assert.notNull(Assert.java:204)
    	at org.mybatis.spring.support.SqlSessionDaoSupport.checkDaoConfig(SqlSessionDaoSupport.java:125)
    	at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:73)
    	at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1797)
    	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1747)
    	... 37 common frames omitted

![在这里插入图片描述][103f7b409b41488fad10946c6b8c0f4e.png]

--------------------

## 原因分析： ##

在网上查找资料发现是因为`exclude={DataSourceAutoConfiguration.calss}`导致

@SpringBootApplication(exclude={
        DataSourceAutoConfiguration.calss})

该注解的作用是，排除自动注入数据源的配置（取消数据库配置），在springBoot中使用多数据源时，加上@SpringBootApplication(exclude=\{DataSourceAutoConfiguration.calss\})  
![在这里插入图片描述][82bc5d55a6c7422988d6bfbcd48c8fd7.png]  
DataSourceAutoConfiguration.class会自动查找application.yml或者properties文件里的spring.datasource.\*相关属性并自动配置单数据源  
因为项目使用的是单数据源。所以，当添加exclude=\{DataSourceAutoConfiguration.calss后，这出现了上面的报错

--------------------

## 解决方案： ##

删掉`exclude={DataSourceAutoConfiguration.calss}`  
![在这里插入图片描述][573c87fd219c4f1190d677519ba6b9c6.png]

[103f7b409b41488fad10946c6b8c0f4e.png]: https://img-blog.csdnimg.cn/103f7b409b41488fad10946c6b8c0f4e.png
[82bc5d55a6c7422988d6bfbcd48c8fd7.png]: https://img-blog.csdnimg.cn/82bc5d55a6c7422988d6bfbcd48c8fd7.png
[573c87fd219c4f1190d677519ba6b9c6.png]: https://img-blog.csdnimg.cn/573c87fd219c4f1190d677519ba6b9c6.png