为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】*:SQL State : 22000
Error Code : -2106
Message : -2106 第1 行附近出现错误:
无效的表或视图名[GLOBAL_NAME]
at org.flywaydb.core.internal.database.base.Database.getCatalog(Database.java:168)
at org.flywaydb.core.internal.parser.ParsingContext.populate(ParsingContext.java:66)
at org.flywaydb.core.Flyway.execute(Flyway.java:559)
at org.flywaydb.core.Flyway.migrate(Flyway.java:165)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
... 51 common frames omitted
Caused by: dm.jdbc.driver.DMException: -2106 第1 行附近出现错误:
无效的表或视图名[GLOBAL_NAME]
at dm.jdbc.driver.DBError.throwException(SourceFile:711)
at dm.jdbc.a.a.x.i(SourceFile:615)
at dm.jdbc.a.a.f.i(SourceFile:137)
at dm.jdbc.a.a.x.q(SourceFile:550)
at dm.jdbc.a.a.x.x(SourceFile:531)
at dm.jdbc.a.a.a(SourceFile:271)
at dm.jdbc.a.a.a(SourceFile:751)
at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(SourceFile:303)
at dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(SourceFile:229)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(SourceFile:131)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(SourceFile:181)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(SourceFile:714)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(SourceFile:700)
at dm.jdbc.driver.DmdbConnection.prepareStatement(SourceFile:1330)
at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344)
at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForString(JdbcTemplate.java:196)
at org.flywaydb.core.internal.database.oracle.OracleDatabase.doGetCatalog(OracleDatabase.java:121)
at org.flywaydb.core.internal.database.base.Database.getCatalog(Database.java:166)
... 57 common frames omitted
Disconnected from the target VM, address: '127.0.0.1:50683', transport: 'socket'
Process finished with exit code 1
查看sql日志是因为执行下面这个sql报错了,达梦和oracle架构有差异,并没有 GLOBAL_NAME这个配置项
select GLOBAL_NAME from GLOBAL_NAME;
您好可以检查一下表名是否正确,应用连接用户名是否正确,跨用户查询需要带模式名。