zjcnb commented on issue #12510:
URL:
https://github.com/apache/shardingsphere/issues/12510#issuecomment-921650538
@jmbkeyes Hi, I used your config are work well, such as:
```
server:
port: 9090
spring:
shardingsphere:
datasource:
names: bocaicheckin${2018..2020}
bocaicheckin2018:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: com.mysql.jdbc.Driver
jdbc-url: jdbc:mysql://127.0.0.1:3306/bocai_checkin2018
username: root
password: 123456
bocaicheckin2019:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: com.mysql.jdbc.Driver
jdbc-url: jdbc:mysql://127.0.0.1:3306/bocai_checkin2019
username: root
password: 123456
bocaicheckin2020:
type: com.zaxxer.hikari.HikariDataSource
driver-class-name: com.mysql.jdbc.Driver
jdbc-url: jdbc:mysql://127.0.0.1:3306/bocai_checkin2020
username: root
password: 123456
rules:
sharding:
sharding-algorithms:
database-inline:
type: INLINE
props:
algorithm-expression: bocaicheckin$->{(month / 100) as int}
centerid-standard:
type: CLASS_BASED
props:
strategy: standard
algorithmClassName:
com.example.demo.config.CenterIdPrecisionShardingAlgorithm
tables:
trainee_center_info:
actual-data-nodes:
bocaicheckin$->{2018..2020}.trainee_center_info
database-strategy:
standard:
sharding-column: centerId
sharding-algorithm-name: centerid-standard
table-strategy:
none:
props:
sql-show: true
enabled: true
```
logs:
```
2021-09-17 17:26:19.275 INFO 47565 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2021-09-17 17:26:19.282 WARN 47565 --- [ main]
com.zaxxer.hikari.util.DriverDataSource : Registered driver with
driverClassName=com.mysql.jdbc.Driver was not found, trying direct
instantiation.
2021-09-17 17:26:19.835 INFO 47565 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2021-09-17 17:26:19.854 INFO 47565 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Starting...
2021-09-17 17:26:19.855 WARN 47565 --- [ main]
com.zaxxer.hikari.util.DriverDataSource : Registered driver with
driverClassName=com.mysql.jdbc.Driver was not found, trying direct
instantiation.
2021-09-17 17:26:19.867 INFO 47565 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Start completed.
2021-09-17 17:26:19.868 INFO 47565 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Starting...
2021-09-17 17:26:19.868 WARN 47565 --- [ main]
com.zaxxer.hikari.util.DriverDataSource : Registered driver with
driverClassName=com.mysql.jdbc.Driver was not found, trying direct
instantiation.
2021-09-17 17:26:19.880 INFO 47565 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Start completed.
2021-09-17 17:26:22.626 INFO 47565 --- [ main]
t.m.m.autoconfigure.MapperCacheDisabler : Clear tk.mybatis.mapper.util.MsUtil
CLASS_CACHE cache.
2021-09-17 17:26:22.627 INFO 47565 --- [ main]
t.m.m.autoconfigure.MapperCacheDisabler : Clear
tk.mybatis.mapper.genid.GenIdUtil CACHE cache.
2021-09-17 17:26:22.628 INFO 47565 --- [ main]
t.m.m.autoconfigure.MapperCacheDisabler : Clear
tk.mybatis.mapper.version.VersionUtil CACHE cache.
2021-09-17 17:26:22.631 INFO 47565 --- [ main]
t.m.m.autoconfigure.MapperCacheDisabler : Clear EntityHelper entityTableMap
cache.
2021-09-17 17:26:22.897 INFO 47565 --- [ main]
com.example.demo.DemoApplicationTests : Started DemoApplicationTests in
39.974 seconds (JVM running for 43.181)
2021-09-17 17:26:39.164 INFO 47565 --- [ main] ShardingSphere-SQL
: Logic SQL: INSERT INTO trainee_center_info (id, name,
centerId) values (?, ?, ?)
2021-09-17 17:26:39.164 INFO 47565 --- [ main] ShardingSphere-SQL
: SQLStatement:
MySQLInsertStatement(setAssignment=Optional.empty,
onDuplicateKeyColumns=Optional.empty)
2021-09-17 17:26:39.164 INFO 47565 --- [ main] ShardingSphere-SQL
: Actual SQL: bocaicheckin2019 ::: INSERT INTO
trainee_center_info (id, name, centerId) values (?, ?, ?) ::: [1, abc1, 2]
2021-09-17 17:26:39.251 INFO 47565 --- [extShutdownHook]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2021-09-17 17:26:39.258 INFO 47565 --- [extShutdownHook]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
2021-09-17 17:26:39.258 INFO 47565 --- [extShutdownHook]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Shutdown initiated...
2021-09-17 17:26:39.263 INFO 47565 --- [extShutdownHook]
com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Shutdown completed.
2021-09-17 17:26:39.263 INFO 47565 --- [extShutdownHook]
com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Shutdown initiated...
2021-09-17 17:26:39.264 INFO 47565 --- [extShutdownHook]
com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Shutdown completed.
Disconnected from the target VM, address: '127.0.0.1:61862', transport:
'socket'
```
--
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]
