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/10/08 05:08:37 UTC

[GitHub] [shardingsphere] huangconghe opened a new issue, #21373: Invalid binding table configuration in ShardingRuleConfiguration

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

   ## Question
   start spring boot fail exception Invalid binding table configuration in ShardingRuleConfiguration
   when i remove binding-tables,start spring boot success,
   when i add binding-tables,start spring boot failed
   my yml follow:
   `
   shardingsphere:
       datasource:
         names: ds0
         ds0:
           type: com.zaxxer.hikari.HikariDataSource
           driver-class-name: com.mysql.cj.jdbc.Driver
           url: jdbc:mysql://10.119.156.2:3306/appdb?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true
           username: ENC(edpsIGBaMrI7PRqnGTPzFA==)
           password: ENC(uoiWRL8NWcyW9/r2NoH1hQ==)
   
       props:
         # 日志显示具体的SQL
         sql-show: true
       rules:
         # 读写分离
         readwrite-splitting:
           data-sources:
             com0:
               type: Static
               load-balancer-name: my-load-balancer
               props:
                 write-data-source-name: ds0
                 read-data-source-names: ds0
           load-balancers:
             my-load-balancer:
               type: RANDOM
         sharding:
           tables:
             bank_statement:
               actual-data-nodes: $->{['com0']}.bank_statement_$->{['HK','PRC']}_$->{0..9}
               database-strategy:
                 standard:
                   sharding-column: engagement_sharding
                   sharding-algorithm-name: database-inline
               table-strategy:
                 complex:
                   sharding-columns: engagement_sharding
                   sharding-algorithm-name: table-complex-inline
             bank_statement_temp:
               actual-data-nodes: $->{['com0']}.bank_statement_temp_$->{['HK','PRC']}_$->{0..9}
               database-strategy:
                 standard:
                   sharding-column: engagement_sharding
                   sharding-algorithm-name: database-inline
               table-strategy:
                 complex:
                   sharding-columns: engagement_sharding
                   sharding-algorithm-name: table-complex-inline
         
   
           sharding-algorithms:
             table-inline:
               type: CLASS_BASED
               props:
                 strategy: STANDARD #标准分片类型
                 algorithmClassName: com.kpmg.smart.ematching.sharding.StandardCustomTableAlgorithm
             database-inline:
               type: CLASS_BASED #自定义type
               props:
                 strategy: STANDARD #标准分片类型
                 algorithmClassName: com.kpmg.smart.ematching.sharding.StandardReadWriteDbAlgorithm
             table-complex-inline:
               type: CLASS_BASED
               props:
                 strategy: COMPLEX #标准分片类型
                 algorithmClassName: com.kpmg.smart.ematching.sharding.ComplexCustomTableAlgorithm
           binding-tables:
             - bank_statement,bank_statement_temp`


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

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


[GitHub] [shardingsphere] huangconghe commented on issue #21373: Invalid binding table configuration in ShardingRuleConfiguration

Posted by GitBox <gi...@apache.org>.
huangconghe commented on issue #21373:
URL: https://github.com/apache/shardingsphere/issues/21373#issuecomment-1272229583

   sharding-jdbc version 5.1.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


[GitHub] [shardingsphere] huangconghe closed issue #21373: Invalid binding table configuration in ShardingRuleConfiguration

Posted by GitBox <gi...@apache.org>.
huangconghe closed issue #21373: Invalid binding table configuration in ShardingRuleConfiguration
URL: https://github.com/apache/shardingsphere/issues/21373


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