[GitHub] [incubator-shardingsphere] chyangxi opened a new issue #3697: Cannot find table rule and default data source with logic tables

[GitBox <gi...@apache.org>]

chyangxi opened a new issue #3697: Cannot find table rule and default data source with logic tables
URL: https://github.com/apache/incubator-shardingsphere/issues/3697
 
 
   > ## Question
   > （default-data-source-name）table join （broadcast-table） error
   > 
   > ## Content
   > ```
   > <sharding:standard-strategy id="databaseStrategy" sharding-column="buss_num" precise-algorithm-ref="dbShardingRule" />
   > 
   > <sharding:data-source id="shadingDataSource">
   > 	<sharding:props>
   > 		<prop key="sql.show">true</prop>
   > 	</sharding:props>
   > 	<sharding:sharding-rule data-source-names="ds0,ds1" default-data-source-name="ds0">
   > 		<sharding:table-rules>
   > 			<sharding:table-rule logic-table="user" actual-data-nodes="ds$->{0..1}.user"
   > 			 database-strategy-ref="databaseStrategy" />
   > 			<sharding:table-rule logic-table="classes" actual-data-nodes="ds$->{0..1}.classes"
   > 			 database-strategy-ref="databaseStrategy" />
   > 			 <sharding:table-rule logic-table="mark" actual-data-nodes="ds$->{0..1}.mark"
   > 			 database-strategy-ref="databaseStrategy" />
   > 		</sharding:table-rules>
   > 		<sharding:binding-table-rules>
   >             <sharding:binding-table-rule logic-tables="user,classes,mark" />
   >         </sharding:binding-table-rules>
   > 		<sharding:broadcast-table-rules > 
   > 			<sharding:broadcast-table-rule table="school_config"/>
   > 		</sharding:broadcast-table-rules>
   > 	</sharding:sharding-rule>
   > </sharding:data-source>
   > 
   > exception:
   > org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
   > 
   > ### Error updating database. Cause: org.apache.shardingsphere.core.exception.ShardingException: Cannot find table rule and default data source with logic tables: '[inter_user , school_config]'
   > ### The error may involve com.inter_user .deleteImportData-Inline
   > ### The error occurred while setting parameters
   > ### SQL: delete from inter_user where date = ? and school IN (SELECT SLAVE_ID FROM school_config WHERE PARENT_ID = ?)
   > ### Cause: org.apache.shardingsphere.core.exception.ShardingException: Cannot find table rule and default data source with logic tables: '[inter_user , school_config ]'
   > version：
   > 
   > org.apache.shardingsphere
   > sharding-jdbc-core
   > 4.0.0-RC2
   > 
   > how to configure？can you tell me the question?thank you!
   
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services