package com.ruoyi.member.config;
|
|
|
import com.zaxxer.hikari.HikariDataSource;
|
import org.springframework.beans.factory.ObjectProvider;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.boot.actuate.autoconfigure.jdbc.DataSourceHealthContributorAutoConfiguration;
|
import org.springframework.boot.actuate.health.AbstractHealthIndicator;
|
import org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator;
|
import org.springframework.boot.jdbc.metadata.DataSourcePoolMetadata;
|
import org.springframework.boot.jdbc.metadata.DataSourcePoolMetadataProvider;
|
import org.springframework.boot.jdbc.metadata.HikariDataSourcePoolMetadata;
|
import org.springframework.context.annotation.Bean;
|
import org.springframework.context.annotation.Configuration;
|
import org.springframework.util.StringUtils;
|
|
import javax.sql.DataSource;
|
import java.util.Map;
|
|
@Configuration
|
public class DataSourceHealthConfig {
|
/**
|
* 解决新版Spring中,健康健康检查用到 sharding jdbc 时,该组件没有完全实现MySQL驱动导致的问题.
|
*/
|
@Bean
|
DataSourcePoolMetadataProvider dataSourcePoolMetadataProvider() {
|
return dataSource -> new NotAvailableDataSourcePoolMetadata();
|
}
|
|
/**
|
* 不可用的数据源池元数据.
|
*/
|
private static class NotAvailableDataSourcePoolMetadata implements DataSourcePoolMetadata {
|
@Override
|
public Float getUsage() {
|
return null;
|
}
|
|
@Override
|
public Integer getActive() {
|
return null;
|
}
|
|
@Override
|
public Integer getMax() {
|
return null;
|
}
|
|
@Override
|
public Integer getMin() {
|
return null;
|
}
|
|
@Override
|
public String getValidationQuery() {
|
// 该字符串是适用于MySQL的简单查询语句,用于检查检查,其他数据库可能需要更换
|
return "select 1";
|
}
|
|
@Override
|
public Boolean getDefaultAutoCommit() {
|
return null;
|
}
|
}
|
}
|
