liruhui opened a new issue, #27893:
URL: https://github.com/apache/shardingsphere/issues/27893
# javaCode （error）
```java
public static void main(String[] args) throws Exception{
HikariDataSource dataSource1 = new HikariDataSource();
dataSource1.setDriverClassName(Driver.class.getName());
dataSource1.setJdbcUrl("jdbc:mysql://localhost:3306/sharding?serverTimezone=UTC");
dataSource1.setUsername("root");
dataSource1.setPassword("rootroot");
HikariDataSource dataSource2 = new HikariDataSource();
dataSource2.setDriverClassName(Driver.class.getName());
dataSource2.setJdbcUrl("jdbc:mysql://localhost:3306/sharding1?serverTimezone=UTC");
dataSource2.setUsername("root");
dataSource2.setPassword("rootroot");
HikariDataSource dataSource3 = new HikariDataSource();
dataSource3.setDriverClassName(Driver.class.getName());
dataSource3.setJdbcUrl("jdbc:mysql://localhost:3306/sharding2?serverTimezone=UTC");
dataSource3.setUsername("root");
dataSource3.setPassword("rootroot");
Map<String, DataSource> map = new HashMap<>();
map.put("aaaa",dataSource1);
map.put("bbbb",dataSource2);
map.put("cccc",dataSource3);
ShardingRuleConfiguration ruleConfiguration = new
ShardingRuleConfiguration();
ShardingTableRuleConfiguration tableRule = new
ShardingTableRuleConfiguration("t_user","aaaa.t_user,bbbb.t_user,cccc.t_user");
ruleConfiguration.getTables().add(tableRule);
ruleConfiguration.setDefaultDatabaseShardingStrategy(new
StandardShardingStrategyConfiguration("id","mabaoguo"));
Properties properties = new Properties();
properties.put("sharding-count",3);
ruleConfiguration.getShardingAlgorithms().put("mabaoguo",new
AlgorithmConfiguration("MOD",properties));
DataSource dataSource =
ShardingSphereDataSourceFactory.createDataSource(map,
Collections.singleton(ruleConfiguration), null);
Connection connection = dataSource.getConnection();
connection.prepareStatement("insert into t_user(id,age,name)
values(4,10,'pppppp')").execute();
connection.prepareStatement("insert into t_user(id,age,name)
values(5,20,'pppppp')").execute();
connection.prepareStatement("insert into t_user(id,age,name)
values(6,30,'pppppp')").execute();
}
```
# javaCode (Right)
```java
public static void main(String[] args) throws Exception{
HikariDataSource dataSource1 = new HikariDataSource();
dataSource1.setDriverClassName(Driver.class.getName());
dataSource1.setJdbcUrl("jdbc:mysql://localhost:3306/sharding?serverTimezone=UTC");
dataSource1.setUsername("root");
dataSource1.setPassword("rootroot");
HikariDataSource dataSource2 = new HikariDataSource();
dataSource2.setDriverClassName(Driver.class.getName());
dataSource2.setJdbcUrl("jdbc:mysql://localhost:3306/sharding1?serverTimezone=UTC");
dataSource2.setUsername("root");
dataSource2.setPassword("rootroot");
HikariDataSource dataSource3 = new HikariDataSource();
dataSource3.setDriverClassName(Driver.class.getName());
dataSource3.setJdbcUrl("jdbc:mysql://localhost:3306/sharding2?serverTimezone=UTC");
dataSource3.setUsername("root");
dataSource3.setPassword("rootroot");
Map<String, DataSource> map = new HashMap<>();
map.put("ds_0",dataSource1);
map.put("ds_1",dataSource2);
map.put("ds_2",dataSource3);
ShardingRuleConfiguration ruleConfiguration = new
ShardingRuleConfiguration();
ShardingTableRuleConfiguration tableRule = new
ShardingTableRuleConfiguration("t_user","ds_${0..2}.t_user");
ruleConfiguration.getTables().add(tableRule);
ruleConfiguration.setDefaultDatabaseShardingStrategy(new
StandardShardingStrategyConfiguration("id","mabaoguo"));
Properties properties = new Properties();
properties.put("sharding-count",3);
ruleConfiguration.getShardingAlgorithms().put("mabaoguo",new
AlgorithmConfiguration("MOD",properties));
DataSource dataSource =
ShardingSphereDataSourceFactory.createDataSource(map,
Collections.singleton(ruleConfiguration), null);
Connection connection = dataSource.getConnection();
connection.prepareStatement("insert into t_user(id,age,name)
values(4,10,'pppppp')").execute();
connection.prepareStatement("insert into t_user(id,age,name)
values(5,20,'pppppp')").execute();
connection.prepareStatement("insert into t_user(id,age,name)
values(6,30,'pppppp')").execute();
}
```
# 2者区别（different）
```
The difference between them is that the definition of key name in map set is
different.
```
`
# why
```
why?
```
--
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]
