sharding-jdbc 雪花算法配置不生效问题

凭借多年经验的直觉,解决了,直接说原因。

无效的配置:


spring.shardingsphere.sharding.tables.simads_tbl.actual-data-nodes=sharding-mcc.simads_tbl_$->{2023..2025}0$->{1..9},sharding-mcc.simads_tbl_$->{2021..2025}$->{10..11}
spring.shardingsphere.sharding.tables.simads_tbl.table-strategy.standard.sharding-column=id
spring.shardingsphere.sharding.tables.simads_tbl.table-strategy.standard.precise-algorithm-class-name=com.ankeyproject.config.sharding.TimeShardingAlgorithm
spring.shardingsphere.sharding.tables.simads_tbl.table-strategy.standard.range-algorithm-class-name=com.ankeyproject.config.sharding.TimeShardingAlgorithm

spring.shardingsphere.sharding.tables.simads_tbl.key-generator.column=id
spring.shardingsphere.sharding.tables.simads_tbl.key-generator.type=snowflake

有效的配置

#雪花算法配置放在其他配置前面,否则不生效
spring.shardingsphere.sharding.tables.simads_tbl.key-generator.column=id
spring.shardingsphere.sharding.tables.simads_tbl.key-generator.type=snowflake

spring.shardingsphere.sharding.tables.simads_tbl.actual-data-nodes=sharding-mcc.simads_tbl_$->{2023..2025}0$->{1..9},sharding-mcc.simads_tbl_$->{2021..2025}$->{10..11}
spring.shardingsphere.sharding.tables.simads_tbl.table-strategy.standard.sharding-column=id
spring.shardingsphere.sharding.tables.simads_tbl.table-strategy.standard.precise-algorithm-class-name=com.ankeyproject.config.sharding.TimeShardingAlgorithm
spring.shardingsphere.sharding.tables.simads_tbl.table-strategy.standard.range-algorithm-class-name=com.ankeyproject.config.sharding.TimeShardingAlgorithm

还有一点需要注意的就是如果涉及到vo bo等,都需要加上主键id

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容