Springboot启动报错：Failed to bind properties under spring.datasource to javax.sql.DataSource

左手的ㄟ右手 2022-05-11 04:46 391阅读 0赞

**项目结构：**

![70][]

**`DruidConfig：`**

package com.lucifer.springboot.config;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import com.alibaba.druid.support.http.StatViewServlet;
    import com.alibaba.druid.support.http.WebStatFilter;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.boot.web.servlet.FilterRegistrationBean;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    import javax.sql.DataSource;
    import java.util.Arrays;
    import java.util.HashMap;
    import java.util.Map;
    
    @Configuration
    public class DruidConfig {
    
        @ConfigurationProperties(prefix = "spring.datasource")
        @Bean
        public DataSource druid(){
            return  new DruidDataSource();
        }
    
        //配置Druid的监控
        //1、配置一个管理后台的Servlet
        @Bean
        public ServletRegistrationBean statViewServlet(){
            ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
            Map<String,String> initParams = new HashMap<>();
    
            initParams.put("loginUsername","admin");
            initParams.put("loginPassword","123456");
            initParams.put("allow","");//默认就是允许所有访问
            //initParams.put("deny","192.168.15.21");
    
            bean.setInitParameters(initParams);
            return bean;
        }
    
    
        //2、配置一个web监控的filter
        @Bean
        public FilterRegistrationBean webStatFilter(){
            FilterRegistrationBean bean = new FilterRegistrationBean();
            bean.setFilter(new WebStatFilter());
    
            Map<String,String> initParams = new HashMap<>();
            initParams.put("exclusions","*.js,*.css,/druid/*");
    
            bean.setInitParameters(initParams);
    
            bean.setUrlPatterns(Arrays.asList("/*"));
    
            return  bean;
        }
    }

**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.lucifer</groupId>
        <artifactId>spring-boot-data-jdbc</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <packaging>jar</packaging>
    
        <name>spring-boot-data-jdbc</name>
        <description>Demo project for Spring Boot</description>
    
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.5.RELEASE</version>
            <relativePath/> 
        </parent>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
    
            
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.8</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    
    </project>

**`SpringbootMybatisApplication:启动类`**

package com.lucifer.springboot;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class SpringbootMybatisApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(SpringbootMybatisApplication.class, args);
        }
    }

**（ps:如果pom.xml中加了这个<scope>runtime</scope>，application.yml中配置的driver-class-name可能会报红。）**

![70 1][]

![70 2][]

**application.yml:**

spring:
      datasource:
        username: root
        password: 123456
        url: jdbc:mysql://localhost:3306/jdbc
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
    
        initialSize: 5
        minIdle: 5
        maxActive: 20
        maxWait: 60000
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: SELECT 1 FROM DUAL
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
        #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
        filters: stat,wall,log4j
        maxPoolPreparedStatementPerConnectionSize: 20
        useGlobalDataSourceStat: true
        connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
    #    schema:
    #      - classpath:department.sql

**启动项目，控制台报错：**

![70 3][]

**查看报错信息： Reason: org/apache/log4j/Logger，提示原因在于log4j。**

** 注：  在springboot1.5的版本中，使用的是spring4.x，而springboot2.x使用的是spring5.x，在spring5.x后，官方弃用了log4j，而建议并使用log4j2，因此要么降低版本使用spring4.x的spring boot版本，要么额外去引入log4j的jar包。**

![20200626152759491.png][]

![20200626153106378.png][]

**解决办法:**

**(1)办法一：增加log4j的包**

**（2）办法二：将spring-boot-starter-parent版本2.0.5改成1.5.15，改低一些。**

![70 4][]

**更改后，再次启动，控制台无报错信息。 **

![70 5][]** **

[70]: /images/20220511/95a462dbd99f47fd91c07681ed6aedaf.png
[70 1]: /images/20220511/e50b6daa324846e88689cd77556fde8e.png
[70 2]: /images/20220511/f48b30063a494a8abd55c4a20fd89856.png
[70 3]: /images/20220511/2bf0809d5fbd4a5da8fa001f5b193b6f.png
[20200626152759491.png]: /images/20220511/efd2112f5c1a436796ed6d32175dc04b.png
[20200626153106378.png]: /images/20220511/be44941505644615b2610ab4fee80187.png
[70 4]: /images/20220511/429bc20828b540b99063dc47a3536f59.png
[70 5]: /images/20220511/ee11715eb3304746b6dfa8c0ce36f7df.png

Springboot启动报错：Failed to bind properties under spring.datasource to javax.sql.DataSource

发表评论取消回复

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

相关阅读

相关 Spring Boot报错Failed to bind properties under ‘‘ to com.zaxxer.hikari.Hikari DataSource

相关 SpringBoot项目启动报错Failed to bind properties under ‘spring.servlet.multipart.max-request-size‘ to org

相关 Failed to bind properties under ‘spring.datasource.primary‘ to javax.sql.DataSource:报错

相关 Failed to bind properties under ‘spring.datasource.primary‘ to javax.sql.DataSource:报错

相关 Springboot项目启动报错 Failed to bind properties under 'spring.datasource.type' to java.lang.Class

相关 springboot使用jpa，启动时报Failed to bind properties under ‘‘ to com.zaxxer.hikari.HikariDataSource

相关 Failed to bind properties under ‘‘ to com.zaxxer.hikari.HikariDataSource

相关 Failed to bind properties under ‘spring.datasource‘ to javax.sql.DataSource

相关 Springboot启动报错：Failed to bind properties under spring.datasource to javax.sql.DataSource

相关 SpringBoot项目启动报错：Failed to bind properties under 'spring.servlet.multipart.max-request-size' to org.