-
Notifications
You must be signed in to change notification settings - Fork 6.6k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Cause: org.apache.shardingsphere.infra.exception.TableNotExistsException: Table or view ***
does not exist.
#29569
Comments
@prefect1005 So did you configured database |
@RaigorJiang Of course . |
Create two logic databases, named db1 and db2. |
@RaigorJiang im sorry that i used "ShardingSphere-JDBC", and i dont know how to create logic databases, can you give me one demo or config file ? thank you. |
@prefect1005
|
well, i got it. |
+1 ,this scenario is very common.
|
@prefect1005 @6z7 |
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale. |
I think you can try hybrid-architecture - https://shardingsphere.apache.org/document/current/en/overview/#hybrid-architecture. You can use Proxy to manage, create multiple logical databases, and then JDBC to access these logical databases. |
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale. |
use 5.4.1
config
` mode:
type: Standalone
databaseName: db1`
sql1: "select * from db1.table"
sql2:"select * form db2.table2"
sql1 no problem
but db2.table2 will TableNotExistsException
Caused by: org.apache.shardingsphere.infra.exception.TableNotExistsException: Table or view
table2
does not exist.The text was updated successfully, but these errors were encountered: