You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/06/05 15:31:02 UTC

[GitHub] [shardingsphere] imjcoder commented on issue #18177: #C1997Runtime exception...

imjcoder commented on issue #18177:
URL: https://github.com/apache/shardingsphere/issues/18177#issuecomment-1146834641

   @zjcnb 
   hello,this is config 
   and Are there any cases that can run?
   too many bugs.....
   
   `# 使用navicate for mysql的时候显示的数据库的名称
   schemaName: sharding_db
   
   dataSources:
     db0:
       url: jdbc:mysql://127.0.0.1:3306/db0?serverTimezone=UTC&useSSL=false
       username: root
       password: root
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
     db1:
       url: jdbc:mysql://127.0.0.1:3306/db1?serverTimezone=UTC&useSSL=false
       username: root
       password: root
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
   
   rules:
   - !SHARDING
     tables:
       t_order:
         actualDataNodes: db${0..1}.t_order${0..3}
         tableStrategy:
           standard:
             shardingColumn: order_id
             shardingAlgorithmName: userTableInline
         databaseStrategy:
           standard:
             shardingColumn: order_id
             shardingAlgorithmName: userDbInline
     shardingAlgorithms:
       userTableInline:
         type: INLINE
         props:
           algorithm-expression: t_order${order_id % 4}
       userDbInline:
         type: INLINE
         props:
           algorithm-expression: db${order_id % 2}
   `


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