问题一
使用flyway中总是提示flyway插件为引入,但pom中已经放入了
最后在网上找了一圈没发现需要放入数据库连接的各种信息
如果在URL后不加入
?serverTimezone=UTC
则会出现错误:
The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone.
完整代码:
<plugin>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-maven-plugin</artifactId>
<configuration>
<user>root</user>
<password>password</password>
<driver>com.mysql.cj.jdbc.Driver</driver>
<url>jdbc:mysql://127.0.0.1:3306/db?serverTimezone=UTC</url>
<baselineOnMigrate>true</baselineOnMigrate>
<!-- //sql脚本位置,flyway会自动去找到这个目录并且执行里面的sql脚本 -->
<locations>classpath:db/migration/</locations>
</configuration>
</plugin>
问题二
flyway成功运行了,数据库也出现了相应的table
但控制台出现这个错误,虽然看着好像不会有什么影响
[INFO] Scanning for projects...
[WARNING]
[WARNING] Some problems were encountered while building the effective model for com.example.SimpleSystem:mall:jar:0.0.1-SNAPSHOT
[WARNING] 'dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: net.sf.json-lib:json-lib:jar:jdk15 -> duplicate declaration of version 2.4 @ line 110, column 15
[WARNING] 'dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: commons-beanutils:commons-beanutils:jar -> duplicate declaration of version 1.7.0 @ line 116, column 15
[WARNING] 'dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: commons-collections:commons-collections:jar -> duplicate declaration of version 3.1 @ line 121, column 15
[WARNING] 'dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: commons-lang:commons-lang:jar -> duplicate declaration of version 2.5 @ line 126, column 15
[WARNING] 'dependencies.dependency.(groupId:artifactId:type:classifier)' must be unique: net.sf.ezmorph:ezmorph:jar -> duplicate declaration of version 1.0.3