yyTraveler
commented
3 hours ago by the way , this project also integrated the hibernate3.
the query i use to test is like
select * from lcz_speech limit 10;i also tried the yaml config style and it's exactly the same problem.
databaseName:
basicDataSource
mode:
type: Standalone
repository:
type: JDBC
rules:
- !SHARDING
shardingAlgorithms:
my_test_interval:
type: INTERVAL
props:
datetime-pattern: yyyy-MM-dd HH:mm:ss
datetime-lower: '2022-01-01 00:00:00'
sharding-suffix-pattern: yyyyMM
datetime-interval-unit: MONTHS
tables:
lcz_speech:
actualDataNodes: basicDataSource.lcz_speech_${202201..202512}
tableStrategy:
standard:
shardingColumn: create_time
shardingAlgorithmName: my_test_interval
bindingTables:
- lcz_speech
- !SINGLE
tables:
- "basicDataSource.*"@Configuration
public class YamlShardingConfiguration {
@Resource(name = "basicDataSource")
private DataSource dataSource;
@Bean("shardingDataSource")
public DataSource getDataSource() throws Exception {
Map<String, DataSource> dataSourceMap = new HashMap<>();
dataSourceMap.put("basicDataSource", dataSource);
File yamlFile = new File("sharding.yaml");
DataSource dataSource = YamlShardingSphereDataSourceFactory.createDataSource(dataSourceMap, yamlFile);
return dataSource;
}
}
Question
i try to use the java api to config the sharding-jdbc 5.5.0
even if i have already config the SingleRuleConfiguration class, when doing the select query, the target table still turns out to be Table or view 'lcz_speech' does not exist.
here are some tips:
the stacktrace
the config class i use
the basicDataSource calss