（亲测解决）Unsatisfied dependency expressed through bean property 'sqlSessionFactory'

一时失言乱红尘 2022-05-14 15:24 459阅读 0赞

**目录**

一、问题描述

二、问题原因

三、问题解决

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

# 一、问题描述 #

1.使用Maven+SpringBoot+MyBatis测试，启动项目报错：Unsatisfied dependency expressed through bean property 'sqlSessionFactory'，也就是无法实例化，所有代码都没有问题

# 二、问题分析 #

1.检查mapper的namespace和查询返回值对应的类都存在

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70][]

2.确保在SpringBoot配置文件中加载了mapper.xml文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 1][]

3.确保Maven的依赖关系-加载了mybatis-spring-boot

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 2][]

4.确保在启动类上加载了mapper.xml接口所在包@MapperScan(basePackages = \{"mapper.xml接口所在包"\})

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 3][]

5.上述检查都没有问题，最后才知道原来mapper.xml被Maven给拦截了，导致加载不上，从而无法实例化sqlSessionFactory

# 三、问题解决 #

1.在maven的pom.xml中放行mapper.xml，在Maven的build中加入以下配置，完整代码在最后![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 4][]

`  2.完整参考pom.xml`

<?xml version="1.0" encoding="UTF-8"?>
    
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.codecoord</groupId>
        <artifactId>JavaEEFrameReview</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>JavaEEFrameReview Maven Webapp</name>
        
        <url>http://www.example.com</url>
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter</artifactId>
                <version>2.0.5.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
                <version>2.0.5.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.42</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.oracle</groupId>
                <artifactId>ojdbc6</artifactId>
                <version>11.2.0.3</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
        </dependencies>
        <build>
            
            <resources>
                <resource>
                    <directory>src/main/resources</directory>
                    
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.yml</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70]: /images/20220503/f61d77d76c94406095fe84491ad4d116.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 1]: /images/20220503/2c663dd0f5ba4b88a977d47ce5adb804.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 2]: /images/20220503/4af6ceb366a544758a562623a02aedf0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 3]: /images/20220503/03c414e6c3ef4988b0b927b148dac54d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM0MTA0NDQ2_size_27_color_FFFFFF_t_70 4]: /images/20220503/74c6952259e5484083919d4d00eaf8ed.png

（亲测解决）Unsatisfied dependency expressed through bean property 'sqlSessionFactory'

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关解决异常Error creating bean with name ‘xxxxxController‘: Unsatisfied dependency expressed through field

相关 Error creating bean with name ‘eduChapterController‘: Unsatisfied dependency expressed through field

相关 creating bean with name ‘serverConfig‘: Unsatisfied dependency expressed through field ‘tokenStore‘

相关 Error creating bean with name ‘teacherController‘: Unsatisfied dependency expressed through field ‘

相关 Error creating bean with name ‘dataSource‘: Unsatisfied dependency expressed through field

相关 UnsatisfiedDependencyException: Unsatisfied dependency expressed through field ‘person‘

相关 Error creating bean with name 'convCommentServiceImpl': Unsatisfied dependency expressed through f

相关（亲测解决）Unsatisfied dependency expressed through bean property 'sqlSessionFactory'

相关 Unsatisfied dependency expressed through field 'baseMapper'

相关 Unsatisfied dependency expressed through field 'baseMapper'