chenfeiwu opened a new issue, #19816:
URL: https://github.com/apache/shardingsphere/issues/19816

   This will create a data source 
error:“YamlShardingSphereDataSourceFactory.createDataSource”
   
![image](https://user-images.githubusercontent.com/14910761/182502867-f664b312-8af3-4bc3-84f7-abc909dc8792.png)
   
   dataSources:
     db1:
       dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
       driverClassName: com.mysql.cj.jdbc.Driver
       jdbcUrl: 
jdbc:mysql://ip:port/tenant1?useUnicode=true&characterEncoding=utf-8&relaxAutoCommit=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
       username: root
       password: 123456
       filters: stat,wall,log4j2
       # 初始连接数
       initialSize: 5
       # 最小连接池数量
       minIdle: 10
       # 最大连接池数量
       maxActive: 20
       # 配置获取连接等待超时的时间
       maxWait: 60000
       # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
       timeBetweenEvictionRunsMillis: 60000
       # 配置一个连接在池中最小生存的时间,单位是毫秒
       minEvictableIdleTimeMillis: 300000
       # 配置一个连接在池中最大生存的时间,单位是毫秒
       maxEvictableIdleTimeMillis: 900000
       # 配置检测连接是否有效
       validationQuery: SELECT 1 FROM DUAL
       testWhileIdle: true
       testOnBorrow: false
       testOnReturn: false
       webStatFilter:
         enabled: true
       filter:
         stat:
           enabled: true
           # 慢SQL记录
           log-slow-sql: true
           slow-sql-millis: 1000
           merge-sql: true
         wall:
           config:
             multi-statement-allow: true
   rules:
     # 配置分片规则
     sharding:
       keyGenerators:
         snowflake:
           type: SNOWFLAKE
           props:
             workerId: 123
       tables:
         # 配置表规则
         classes:
           actualDataNodes: db1.classes_$->{0..1}
           # 配置分表策略
           tableStrategy:
             standard:
               shardingColumn: id
               shardingAlgorithmName: classes-inline
           keyGenerateStrategy:
             column: id
             keyGeneratorName: snowflake
       # 配置分片算法
       bindingTables: classes
       shardingAlgorithms:
         auto-mod-1:
           type: mod
           props:
             sharding-count: 1
         classes-inline:
           type: INLINE
           props:
             algorithm-expression: classes_$->{id % 2}
         table-inline:
           type: CLASS_BASED #自定义type
           props:
             strategy: STANDARD #标准分片类型
             algorithmClassName: 
com.evoc.starter.tenant.isolation.table.TableShardingAlgorithm
   


-- 
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: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to