No bean named 'sqlSessionFactoryBean' available

末蓝、 2024-04-19 13:25 69阅读 0赞

SpringBoot集成mybatis服务启动异常日志

> 2019-09-18 19:52:17.270  WARN 8320 --- \[  restartedMain\] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'testDtoMapper' defined in file \[D:\\workspace\\xesWorkspace\\xes\\target\\classes\\com\\xes\\www\\core\\mapper\\TestDtoMapper.class\]: Cannot resolve reference to bean 'sqlSessionFactoryBean' while setting bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'sqlSessionFactoryBean' available

检查代码和引入jar包没问题，问题原因是数据库datasource和sqlSessionFactory没有整合到一块

maven配置

>     
>     <dependency>
>        <groupId>org.mybatis.spring.boot</groupId>
>        <artifactId>mybatis-spring-boot-starter</artifactId>
>        <version>2.0.0</version>
>     </dependency>
>     <dependency>
>        <groupId>org.mybatis</groupId>
>        <artifactId>mybatis-spring</artifactId>
>        <version>1.3.2</version>
>     </dependency>
>     
>

Mybatis配置类

@Configuration
    @MapperScan(basePackages = {
            "com.xes.www.core.mapper"
    }, sqlSessionFactoryRef = "sqlSessionFactoryBean")
    public class MybatisConfiguration {
        // 代替了传统的datasource绑定sqlSessionFactoryBean
        @Bean
        public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSource);
            return sqlSessionFactoryBean;
        }
    }

下面是传统的配置也就是通过xml来配置的

>   
>     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
>           
>         <property name="dataSource" ref="dataSource" />  
>           
>         <property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />  
>     </bean>

参考： [https://blog.csdn.net/ljm15832631631/article/details/79346279][https_blog.csdn.net_ljm15832631631_article_details_79346279]

[https_blog.csdn.net_ljm15832631631_article_details_79346279]: https://blog.csdn.net/ljm15832631631/article/details/79346279