KomachiSion commented on issue #2344: why checking connection so frequently with druid? URL: https://github.com/apache/incubator-shardingsphere/issues/2344#issuecomment-490315127 Hi @e7, it looks like you use sharding-jdbc-spring-boot-starter 3.1.0, you can remove `druid` prefix and retry. such as ``` datasource: names: master,slave0 master: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168.1.229:3306/xxxx?useSSL=false&useUnicode=true&serverTimezone=UTC&characterEncoding=UTF-8&autoReconnect=true username: xxxx password: 123456 test-on-borrow: false test-while-idle: true validation-query: SELECT 1 time-between-eviction-runs-millis: 30000 min-evictable-idle-time-millis: 30000 connection-init-sqls: set names utf8mb4; slave0: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168.1.229:3306/xxxx?useSSL=false&useUnicode=true&serverTimezone=UTC&characterEncoding=UTF-8&autoReconnect=true username: xxxx password: 123456 test-on-borrow: false test-while-idle: true validation-query: SELECT 1 time-between-eviction-runs-millis: 30000 min-evictable-idle-time-millis: 30000 connection-init-sqls: set names utf8mb4; ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
