shardingsphere5.0.0 + oracle11g-ee
使用的驱动如下

引入的包

分片配置
spring:
shardingsphere:
props:
sql-show: true
datasource:
names: ds
ds:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@127.0.0.1:1521/orcl
username: test
password: test
rules:
sharding:
key-generators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
sharding-algorithms:
charge-detail:
type: CLASS_BASED
props: {}
tables:
ca_charge_detail:
actual-data-nodes: ds.ca_charge_detail_$->{2021..2022}_$->{1..4}
table-strategy:
standard:
sharding-column: id
sharding-algorithm-name: charge-detail
key-generate-strategy:
column: id
key-generator-name: snowflake
enabled: true
oracle版本:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production