[GitHub] [shardingsphere] duzhanfei opened a new issue #8377: Cause: java.sql.SQLException: 2Unknown exception: [Can not route tables for `[bcpur_pscst_deptp_stats]`, please make sure the tables are in same schema.]\r\n### The error may exist in file

Fri, 27 Nov 2020 00:36:04 -0800 


duzhanfei opened a new issue #8377:
URL: https://github.com/apache/shardingsphere/issues/8377


   #7816 # Which version of ShardingSphere did you use?
   5.0.0
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   I configured the default routing datesouce   when configuring read/write 
separation
   
   I want to route  table   bcpur_pscst_deptp_stats  to the default database, 
but I am prompted that I do not have a routing policy configured
   
   
   part  config   of config-replica-query.yaml 
   
   
     defaultDatabaseStrategy:
       standard:
         shardingColumn: ECIF_CUST_NO
         shardingAlgorithmName: database_default_inline
     defaultTableStrategy:
       none:
   
     shardingAlgorithms:
       database_default_inline:
         type: INLINE
         props:
           algorithm-expression: ms_ds
       database_inline:
         type: INLINE
         props:
           algorithm-expression: ms_ds
       
     keyGenerators:
       snowflake:
         type: SNOWFLAKE
         props:
           worker-id: 123
           
   - !REPLICA_QUERY
     dataSources:
       ms_ds:
         name: ms_ds
         primaryDataSourceName: primary_ds
         replicaDataSourceNames:
           - replica_ds_0
           - replica_ds_1
   
   


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

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to