网站描述更改,百度网址大全网站,为什么网站建设要值班,空间设计师是干什么的网上查了下#xff0c;没有找打相关的报错解决办法#xff0c;所以在解决问题后#xff0c;整理到网上#xff0c;帮助有需要的朋友。
springboot整合druid时#xff0c;引入了druid的数据源#xff0c;在配置文件application.yml中配置了相关配置 initialSize: 5minIdl…网上查了下没有找打相关的报错解决办法所以在解决问题后整理到网上帮助有需要的朋友。
springboot整合druid时引入了druid的数据源在配置文件application.yml中配置了相关配置 initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1 FROM DUALtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true
# 配置监控统计拦截的filters去掉后监控界面sql无法统计wall用于防火墙filters: stat,wall,log4jmaxPoolPreparedStatementPerConnectionSize: 20useGlobalDataSourceStat: trueconnectionProperties: druid.stat.mergeSqltrue;druid.stat.slowSqlMillis500也作了相关配置 DruidConfig.class
Configuration
public class DruidConfig {ConfigurationProperties(prefix spring.datasource)Beanpublic DataSource druid() {return new DruidDataSource();}// 配置Druid的监控// 1、配置一个管理后台的ServletBeanpublic ServletRegistrationBean statViewServlet() {ServletRegistrationBean bean new ServletRegistrationBean(new StatViewServlet(), /druid/*);MapString, String initParams new HashMap();initParams.put(loginUsername, admin);initParams.put(loginPassword, 123456);initParams.put(allow, );// 默认就是允许所有访问initParams.put(deny, 10.18.172.124);bean.setInitParameters(initParams);return bean;}// 2、配置一个web监控的filterBeanpublic FilterRegistrationBean webStatFilter() {FilterRegistrationBean bean new FilterRegistrationBean();bean.setFilter(new WebStatFilter());MapString, String initParams new HashMap();initParams.put(exclusions, *.js,*.css,/druid/*);bean.setInitParameters(initParams);bean.setUrlPatterns(Arrays.asList(/*));return bean;}
}但是在启动时报错 APPLICATION FAILED TO START Description:
控制台出现Failed to bind properties under ‘spring.datasource’ to javax.sql.DataSource:
Property: spring.datasource.filters
Value: stat,wall,log4j
Origin: class path resource [application.yml]:24:14
Reason: org.apache.log4j.LoggerAction:
Update your application’s configuration
根据报错提示在配置文件的24行查看配置文件该行代码是 filters: stat,wall,log4j
看报错原因Reason: org.apache.log4j.Logger于是猜想少了log4j的相关依赖在pom中引入相关依赖
!-- https://mvnrepository.com/artifact/log4j/log4j --dependencygroupIdlog4j/groupIdartifactIdlog4j/artifactIdversion1.2.17/version/dependency再次启动成功
