SpringBoot报错:Failed to bind properties under 'spring.datasource' to javax.sql.DataSource

springboot整合druid时,引入了druid的数据源,在配置文件application.yml中配置了相关配置

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

也作了相关配置 DruidConfig.class

@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", "10.18.172.124");

	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;
}

}
但是在启动时报错:


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.Logger

Action:

Update your application’s configuration

根据报错提示在配置文件的24行,查看配置文件,该行代码是 filters: stat,wall,log4j

看报错原因Reason: org.apache.log4j.Logger,于是猜想少了log4j的相关依赖,在pom中引入相关依赖

	<dependency>
	    <groupId>log4j</groupId>
	    <artifactId>log4j</artifactId>
	    <version>1.2.17</version>
	</dependency>

再次启动,成功!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值