注册

springboot项目dm8与flyway适配问题?启动报错Unable to create schema "xxx",无效的用户名“xxx”

JoseShiang 2025/04/29 168 3 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:win10
【CPU】: Intel(R)Core(TM)i7-9700KF CPU @ 3.60GHZ

配置flyway后项目启动报错

版本信息

  • Springboot 2.7.7
  • DM8
  • Flyway 5.2.4

配置信息

image.png

image.png

报错信息

2025-04-29 13:48:27.370  INFO 7432 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 1.0 by Boxfuse
2025-04-29 13:48:27.711  INFO 7432 --- [           main] o.f.c.internal.database.DatabaseFactory  : Database: jdbc:dm://localhost:5236 (DM DBMS 8.1)
2025-04-29 13:48:27.749  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:28.762  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:29.774  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:30.786  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:31.797  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:32.803  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:33.810  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:34.821  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:35.831  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:36.838  INFO 7432 --- [           main] o.f.core.internal.command.DbSchemas      : Creating schema "TEST" ...
2025-04-29 13:48:36.845  WARN 7432 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayConfig': Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException: 
Unable to create schema "TEST"
------------------------------
SQL State  : 22000
Error Code : -2101
Message    : 第1 行附近出现错误:
无效的用户名[TEST]

2025-04-29 13:48:36.847  INFO 7432 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2025-04-29 13:48:36.856  INFO 7432 --- [           main] ConditionEvaluationReportLoggingListener : 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2025-04-29 13:48:36.875 ERROR 7432 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayConfig': Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException: 
Unable to create schema "TEST"
------------------------------
SQL State  : 22000
Error Code : -2101
Message    : 第1 行附近出现错误:
无效的用户名[TEST]

	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.24.jar:5.3.24]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.24.jar:5.3.24]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) ~[spring-boot-2.7.7.jar:2.7.7]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731) [spring-boot-2.7.7.jar:2.7.7]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408) [spring-boot-2.7.7.jar:2.7.7]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) [spring-boot-2.7.7.jar:2.7.7]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) [spring-boot-2.7.7.jar:2.7.7]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) [spring-boot-2.7.7.jar:2.7.7]
	at com.demo.Application.main(Application.java:11) [classes/:na]
Caused by: org.flywaydb.core.internal.exception.FlywaySqlException: 
Unable to create schema "TEST"
------------------------------
SQL State  : 22000
Error Code : -2101
Message    : 第1 行附近出现错误:
无效的用户名[TEST]

	at org.flywaydb.core.internal.database.base.Schema.create(Schema.java:115) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.internal.command.DbSchemas$1.call(DbSchemas.java:81) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.internal.command.DbSchemas$1.call(DbSchemas.java:69) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.internal.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.internal.command.DbSchemas.create(DbSchemas.java:69) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:1369) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:1356) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.Flyway.execute(Flyway.java:1711) ~[flyway-core-1.0.jar:na]
	at org.flywaydb.core.Flyway.migrate(Flyway.java:1356) ~[flyway-core-1.0.jar:na]
	at com.demo.config.FlywayConfig.migration(FlywayConfig.java:53) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_333]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_333]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_333]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_333]
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) ~[spring-beans-5.3.24.jar:5.3.24]
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) ~[spring-beans-5.3.24.jar:5.3.24]
	... 18 common frames omitted
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
无效的用户名[TEST]
	at dm.jdbc.driver.DBError.throwException(SourceFile:738) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.a.a.y.r(SourceFile:623) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.a.a.f.r(SourceFile:138) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.a.a.y.z(SourceFile:555) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.a.a.y.L(SourceFile:536) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.a.a.a(SourceFile:269) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.a.a.a(SourceFile:792) ~[DmJdbcDriver18-8.1.3.140.jar:- 8.1.3.140 - Production]
	at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(SourceFile:321) ~[DmJdbcDriver18-8.1.3.140.jar:- 
回答 0
暂无回答
扫一扫
联系客服