ShardingJdbc SQLFeatureNotSupportedException: isValid

偏执的太偏执、 2022-10-19 04:17 452阅读 0赞

## springboot集成 shardingjdbc 启动报错 ##

SQLFeatureNotSupportedException: isValid

研究半天,看了shardingjdbc官网GitHub,也发现了这个问题:  
https://github.com/apache/shardingsphere/pull/6002/files/c191c9571ab5a2e9e6d3f0c0f84c8bb6cd36d851

然后特别记录一下: 解决方案:

package com.spark.fqdemoshardingsphere.config;
    
    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.DataSourcePoolMetadataProvider;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.util.StringUtils;
    
    import javax.sql.DataSource;
    import java.util.Map;
    
    /** * @author fuqiang * @Description 数据源健康检查 * @Date 2021/7/9 */
    @Configuration
    public class DataSourceHealthConfig extends DataSourceHealthContributorAutoConfiguration { 
    
        @Value("${spring.datasource.dbcp2.validation-query:select 1}")
        private String defaultQuery;
    
    
        public DataSourceHealthConfig(Map<String, DataSource> dataSources, ObjectProvider<DataSourcePoolMetadataProvider> metadataProviders) { 
            super(dataSources, metadataProviders);
        }
    
        @Override
        protected AbstractHealthIndicator createIndicator(DataSource source) { 
            DataSourceHealthIndicator indicator = (DataSourceHealthIndicator) super.createIndicator(source);
            if (!StringUtils.hasText(indicator.getQuery())) { 
                indicator.setQuery(defaultQuery);
            }
            return indicator;
        }
    
    }

### 参考文章: ###

https://blog.csdn.net/taopenglove/article/details/115008531?utm\_medium=distribute.pc\_relevant\_download.none-task-blog-2defaultBlogCommendFromBaidudefault-10.test\_version\_3&depth\_1-utm\_source=distribute.pc\_relevant\_download.none-task-blog-2defaultBlogCommendFromBaidudefault-10.test\_version\_