[GitHub] [shardingsphere] zjcnb commented on issue #18495: Unable to configure `dataSource` property for HikariCP 4.0.3

[GitBox <gi...@apache.org>]

zjcnb commented on issue #18495:
URL: https://github.com/apache/shardingsphere/issues/18495#issuecomment-1161842901

   @linghengqian Hou about this way?
   
   ```
   localhost: localhost
   
   
   spring:
     shardingsphere:
       dataSource:
         names: ds0, ds1
         ds0:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.cj.jdbc.Driver
           jdbcUrl: jdbc:mysql://${localhost}:3306/ds0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
           username: root
           password: 123456
           poolName: datasource-one
           data-source-properties:
             cachePrepStmts: true
             prepStmtCacheSize: 250
             prepStmtCacheSqlLimit: 2048
             useServerPrepStmts: true
             useLocalSessionState: true
             rewriteBatchedStatements: true
             cacheResultSetMetadata: true
             cacheServerConfiguration: true
             elideSetAutoCommits: true
             maintainTimeStats: false
   ```


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org