liruhui opened a new issue, #25078:
URL: https://github.com/apache/shardingsphere/issues/25078

   ## vertical sharding tables 
   ```
   for example 
   
   one table has three column (id, name age) , ->vertical sharding table->  
table_1 has column(id,name), table_2 has 
   colume(id,age)    columes named  "name" and “age” in different table   maybe 
table name is  different
   ```
   ##  javaCode
   ```java
   public static void main(String[] args) throws Exception{
           Map<String, DataSource> mapDatasource = new HashMap<>();
           HikariDataSource table1Database = new HikariDataSource();
           table1Database.setDriverClassName();
           table1Database.setJdbcUrl();
           table1Database.setUsername();
           table1Database.setPassword();
   
           HikariDataSource table2Database = new HikariDataSource();
           table2Database.setDriverClassName();
           table2Database.setJdbcUrl();
           table2Database.setUsername();
           table2Database.setPassword();
           mapDatasource.put("table1Database",table1Database);
           mapDatasource.put("table2Database",table2Database);
   
           DataSource dataSource = 
ShardingSphereDataSourceFactory.createDataSource(mapDatasource, null, null);
           Connection connection = dataSource.getConnection();
           connection.prepareStatement("insert into table(id,name,age) 
values(1,'aaaa',22)").execute();
           connection.close();
       }
   
   ```
   
   ## myquestion 
   
![image](https://user-images.githubusercontent.com/24687986/230845546-cfff94df-319a-4105-b35d-1da30ad6f323.png)
   
   ## others 
   ```
   I asked the same question one mouth age  in 
[Issues](https://github.com/apache/shardingsphere/issues/24704)  but nobody 
reply  
   
   ```
   


-- 
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]

Reply via email to