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