You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/09/08 06:50:23 UTC

[GitHub] [shardingsphere] kar1rose commented on issue #12286: java.sql.Timestamp cannot be cast to java.lang.Number

kar1rose commented on issue #12286:
URL: https://github.com/apache/shardingsphere/issues/12286#issuecomment-914967862


   version was 5.0.0-beta 
   `ShardingTableRuleConfiguration orderTableRuleConfig = new ShardingTableRuleConfiguration("t_user", "db${1}.user");
   ShardingTableRuleConfiguration userTableRuleConfig = new ShardingTableRuleConfiguration("p_order", "db${2}.purchase_order");
   ShardingRuleConfiguration shardingRuleConfig = new ShardingRuleConfiguration();
           shardingRuleConfig.getTables().add(orderTableRuleConfig);
           shardingRuleConfig.getTables().add(userTableRuleConfig);
   Properties properties = new Properties();
           properties.setProperty("sql-show", "true");
   try {
               dataSource = ShardingSphereDataSourceFactory.createDataSource(dataSourceMap, Collections.singleton(shardingRuleConfig), properties);
           } catch (SQLException throwables) {
               throwables.printStackTrace();
           }
   `
   that's my configuration,I just want to test a Cross-database query 
   
   > @kar1rose
   > What's your version of ShardingSphere?
   > And please provide your configuration and the `Logic SQL` and `Actual SQL`, by set `props.sql-show` to `true`.
   
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org