Druid【SpringBoot集成】监控数据库报错 Failed to bind properties under ‘‘ to javax

总结

面试前的“练手”还是很重要的，所以开始面试之前一定要准备好啊，不然也是耽搁面试官和自己的时间。

我自己是刷了不少面试题的，所以在面试过程中才能够做到心中有数，基本上会清楚面试过程中会问到哪些知识点，高频题又有哪些，所以刷题是面试前期准备过程中非常重要的一点。

面试题及解析总结

大厂面试场景

知识点总结

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

<version>1.2.17</version>

2. 配置

spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
username: root
password: root
# 数据源选择
type: com.alibaba.druid.pool.DruidDataSource
# Spring Boot 默认是不注入这些属性值的，需要自己绑定
# 数据源专有配置
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，stat:监控统计、log4j：日志记录、wall：防御sql注入
#如果允许时报错 java.lang.ClassNotFoundException: org.apache.log4j.Priority
#则导入 log4j 依赖即可，Maven 地址：https://mvnrepository.com/artifact/log4j/log4j
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

3. 利用druid性能监控

@Configuration
public class DruidConfig {
@Bean
@ConfigurationProperties(prefix = “spring.datasource”)
public DataSource druidDataSource() {
return new DruidDataSource();
}
@Bean
public ServletRegistrationBean druidServlet() { //后台监控
ServletRegistrationBean statViewServletRegistration = new ServletRegistrationBean<>(new StatViewServlet(), “/druid/*”);
HashMap<String, String> initParameters = new HashMap<>(8);
//druid web登录验证
initParameters.put(“loginUsername”, “admin”);
initParameters.put(“loginPassword”, “123”);
//允许访问
initParameters.put(“allow”, “”);
//禁止访问
//initParameters.put(“guest”, “127.0.0.1”);
statViewServletRegistration.setInitParameters(initParameters);
return statViewServletRegistration;
}
@Bean
public FilterRegistrationBean filterRegistrationBean() { //filter拦截
FilterRegistrationBean webStatFilterRegistrationBean = new FilterRegistrationBean<>(new WebStatFilter());
webStatFilterRegistrationBean.addUrlPatterns(“/*”);
webStatFilterRegistrationBean.addInitParameter(“exclusions”, “*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*,*.html”);
return webStatFilterRegistrationBean;
}
}

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

2021-07-09 10:46:47.780 WARN 15072 — [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.boot.context.properties.ConfigurationPropertiesBindException: Error creating bean with name ‘druidDataSource’: Could not bind properties to ‘DataSource’ : prefix=spring.datasource, ignoreInvalidFields=false, ignoreUnknownFields=true; nested exception is org.springframework.boot.context.properties.bind.BindException: Failed to bind properties under ‘spring.datasource’ to javax.sql.DataSource
2021-07-09 10:46:47.781 INFO 15072 — [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]

### 最后

给大家送一个小福利

![](https://img-blog.csdnimg.cn/img_convert/8bc2d6067054cc1e5b7d9b0f65cde2ff.webp?x-oss-process=image/format,png)

附高清脑图，高清知识点讲解教程，以及一些面试真题及答案解析。送给需要的提升技术、准备面试跳槽、自身职业规划迷茫的朋友们。

![](https://img-blog.csdnimg.cn/img_convert/55f1e12d3e88c582d9f9e03ee6a1052b.webp?x-oss-process=image/format,png)



> **本文已被[CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**

**[需要这份系统化的资料的朋友，可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**

ff00ff254613a03fab5e56a57acb)收录**

**[需要这份系统化的资料的朋友，可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**