How to configure data source configuration

[WXingSong]

I use sharding-jdbc 5.5.1.
I have configured the following data source configurations in YAML

dataSources:
  ds0:
    dataSourceClassName: com.mysql.cj.jdbc.Driver
    driverClassName: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/demo?serverTimezone=UTC&useSSL=false
    username: root
    password: 123456
    initialSize: 5
    maxActive: 20
    minIdle: 5
    maxWait: 60000
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1
 ds1:
    dataSourceClassName: com.mysql.cj.jdbc.Driver
    driverClassName: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3307/demo?serverTimezone=UTC&useSSL=false
    username: root
    password: 123456
    initialSize: 5
    maxActive: 20
    minIdle: 5
    maxWait: 60000
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1

the log output：testWhileIdle is true, validationQuery not set.
This means that the configuration is unavailable.

my druid version is 1.2.27

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.2.27</version>
 </dependency>

[linghengqian]

• My view is that you should provide a Git repository that includes unit tests. From my perspective, the way you configured validationQuery is fine.

• Since the ShardingSphere master branch doesn't test Alibaba Druid at all, I documented similar testing scenarios in a Chinese article on an external website, namely https://www.yuque.com/linghengqian/meve2v/zoy35sivtf6nzp90 . Both the filters and useGlobalDataSourceStat attributes are correctly recognized by ShardingSphere.

mode:
  type: Standalone
  repository:
    type: JDBC
dataSources:
  ds_0:
    dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
    driverClassName: org.h2.Driver
    url: jdbc:h2:mem:demo_ds_0;MODE=MYSQL;IGNORECASE=TRUE;CASE_INSENSITIVE_IDENTIFIERS=TRUE
    username: sa
    password:
    useGlobalDataSourceStat: true
    filters: wall,mergeStat
  ds_1:
    dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
    driverClassName: org.h2.Driver
    url: jdbc:h2:mem:demo_ds_1;MODE=MYSQL;IGNORECASE=TRUE;CASE_INSENSITIVE_IDENTIFIERS=TRUE
    username: sa
    password:
    useGlobalDataSourceStat: true
    filters: wall,io.github.linghengqian.filter.testd.CustomStatFilter
  ds_2:
    dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
    driverClassName: org.h2.Driver
    url: jdbc:h2:mem:demo_ds_2;MODE=MYSQL;IGNORECASE=TRUE;CASE_INSENSITIVE_IDENTIFIERS=TRUE
    username: sa
    password:
    useGlobalDataSourceStat: true
    filters: >-
      wall,
      io.github.linghengqian.filter.testd.CustomStatFilter

• Incidentally, Set the default value of testWhileIdle to false to prevent Error Log alibaba/druid#6128 has never been merged.

[terrymanu]

ShardingSphere cannot support Druid's customized properties.
You can extend the shardingsphere-infra-data-source-pool-type module on your own to implement customized support for Druid.

Additionally, the enterprise-level product SphereEx DBPlusEngine, developed based on ShardingSphere, provides adaptation and support for database connection pools beyond HikariCP.

Company website: https://www.sphere-ex.com/
For a comparison between the open-source and enterprise editions: https://www.sphere-ex.cn/comparison/

If you are interested, you can find their contact information on the company website to communicate with them.

[WXingSong]

ShardingSphere 不支持 Druid 的自定义属性。 您可以shardingsphere-infra-data-source-pool-type自行扩展该模块以实现对 Druid 的自定义支持。

此外，基于 ShardingSphere 开发的企业级产品 SphereEx DBPlusEngine 提供了对 HikariCP 之外的数据库连接池的适配和支持。

公司网站：https://www.sphere-ex.com/ 开源版与企业版对比：https://www.sphere-ex.cn/comparison/

如果您有兴趣，可以在公司网站上找到他们的联系方式并与他们沟通。

So does ShardingSphere support all the configuration properties of HikariCP ？ For example, connectionTestQuery, connectionTimeout, and so on.Are they all configured like this below?

dataSources:
  ds0:
    dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    jdbcUrl: jdbc:mysql://127.0.0.1:3306/demo?characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
    username: root
    password: 123456
    maximumPoolSize: 20
    minimumIdle: 5
    idleTimeout: 60000
    maxLifetime: 1800000
    connectionTimeout: 30000
    validationTimeout: 5000
    leakDetectionThreshold: 2000
    connectionTestQuery: SELECT 1

[terrymanu]

Not support on ShardingSphere-Proxy, can support for ShardingSphere-JDBC