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

问题描述

启动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

---

原因分析：

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

@SpringBootApplication(exclude={DataSourceAutoConfiguration.calss})

该注解的作用是，排除自动注入数据源的配置（取消数据库配置），在springBoot中使用多数据源时，加上@SpringBootApplication(exclude={DataSourceAutoConfiguration.calss})

DataSourceAutoConfiguration.class会自动查找application.yml或者properties文件里的spring.datasource.*相关属性并自动配置单数据源
因为项目使用的是单数据源。所以，当添加exclude={DataSourceAutoConfiguration.calss后，这出现了上面的报错

---

解决方案：

删掉exclude={DataSourceAutoConfiguration.calss}