agoodcoolman commented on issue #12869:
URL:
https://github.com/apache/shardingsphere/issues/12869#issuecomment-973738012
the same question,
use sharding-jdbc-5.0.0
this is my ymal config
`schemaName: sharding_db
mode:
type: memory
dataSources:
ds0:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name:
jdbc-url:
username:
password:
ds1:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc-url:
username:
password:
rules:
tables:
data_door_info_all:
actual-data-nodes: ds${[0,1]}.data_door_info_all_$->{[0,1,2,3]}
databaseStrategy:
standard:
sharding-column: id
shardingAlgorithmName: hash_mode
table-strategy:
standard:
sharding-column: idcard
sharding-algorithm-name: hash_mode
defaultTableStrategy:
none:
sharding-algorithms:
hash_mod:
type: MOD
props:
sharding-count: 3
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123`
--
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]
