Skip to content

Project stop reporting error :org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: #35478

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

Open
MyHeart0 opened this issue May 21, 2025 · 2 comments

Comments

@MyHeart0
Copy link

javaproject
The introduced dependencies are:

org.apache.shardingsphere
shardingsphere-jdbc
5.5.1

The default metadata storage has been configured as mysql :
Properties props2 = new Properties();
props2.setProperty("jdbcUrl", "jdbc:mysql://xx.xx.xx.xx:xx/user");
props2.setProperty("username", "root");
props2.setProperty("password", "root.");
ModeConfiguration modeConfiguration =
new ModeConfiguration("Standalone", new StandalonePersistRepositoryConfiguration("JDBC", props2));

Error reported when the project is stopped:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement:
DELETE FROM repository WHERE key LIKE ? [42102-200]

May I ask why there is an error message regarding the H2 database

@MyHeart0 MyHeart0 changed the title Project stop reporting error Project stop reporting error :org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: May 21, 2025
@linghengqian
Copy link
Member

  • I guess there are some edge cases involved here, because the unit tests of the relevant classes cannot use testcontainers-java and just mock some results normally.
  • Could you provide a git containing the unit tests for testcontainers-java ? I'd like to know the specific mysql version.

@linghengqian
Copy link
Member

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants