shardingsphere icon indicating copy to clipboard operation
shardingsphere copied to clipboard

Cause: org.apache.shardingsphere.infra.exception.TableNotExistsException: Table or view `t_user` does not exist.

Open ListenQ opened this issue 1 year ago • 2 comments

Question

使用环境: jdk8 springboot2.7.11 shardingsphere5.4.1

场景、问题: databaseName: ds table: t_user,t_order_0,t_order_1 通过Yaml配置数据源及分表策略,增删查改不参与分库分表的表时,提示表不存在。

sql:select * from ds.t_user

提示 nested exception is org.apache.ibatis.executor.ExecutorException: Error preparing statement. Cause: org.apache.shardingsphere.infra.exception.TableNotExistsException: Table or view t_user does not exist.

ListenQ avatar Feb 02 '24 02:02 ListenQ

Refer to : https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/single/

zhaojinchao95 avatar Feb 02 '24 15:02 zhaojinchao95

Refer to : https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/single/

ok, Thanks~ The problem has been solved.

ListenQ avatar Feb 04 '24 07:02 ListenQ

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

github-actions[bot] avatar Mar 05 '24 20:03 github-actions[bot]

Since this question has been answered, I will close this issue.

strongduanmu avatar Mar 12 '24 08:03 strongduanmu