Comments (4)
It doesn't look like the new releases are published to Maven (or any other popular repos) yet. In the interim, you'll have to publish your own or mix versions.
flyway-core
7.5.2 seems perfectly happy with flyway-sbt
6.5.0 in my testing, but YMMV: mixing linked major versions like that sketches me out even if there are no compatibility-breaking major changes.
from flyway-sbt.
Current flyway-sbt release does not work with latest flyway 9.20.1:
[info] Flyway Community Edition 7.4.0 by Redgate
[info] Database: jdbc:h2:./test (H2 2.2)
[error] org.flywaydb.core.internal.exception.FlywaySqlException:
[error] Unable to determine H2 compatibility mode
[error] -----------------------------------------
[error] SQL State : 42001
[error] Error Code : 42001
[error] Message : Syntax error in SQL statement "SELECT [*]VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE'"; expected "TOP, DISTINCT, ALL, *, INTERSECTS (, NOT, EXISTS, UNIQUE, INTERSECTS"; SQL statement:
[error] SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE' [42001-220]
[error]
[error] at org.flywaydb.core.internal.database.h2.H2Database.determineCompatibilityMode(H2Database.java:103)
[error] at org.flywaydb.core.internal.database.h2.H2Database.<init>(H2Database.java:76)
[error] at org.flywaydb.core.internal.database.h2.H2DatabaseType.createDatabase(H2DatabaseType.java:61)
[error] at org.flywaydb.core.internal.database.base.DatabaseType.createDatabase(DatabaseType.java:149)
[error] at org.flywaydb.core.Flyway.execute(Flyway.java:543)
[error] at org.flywaydb.core.Flyway.migrate(Flyway.java:165)
[error] at io.github.davidmweber.FlywayPlugin$.$anonfun$flywayBaseSettings$47(FlywayPlugin.scala:190)
[error] at io.github.davidmweber.FlywayPlugin$.$anonfun$flywayBaseSettings$47$adapted(FlywayPlugin.scala:190)
[error] at scala.Function1.$anonfun$compose$1(Function1.scala:49)
[error] at sbt.internal.util.$tilde$greater.$anonfun$$u2219$1(TypeFunctions.scala:63)
[error] at sbt.std.Transform$$anon$4.work(Transform.scala:69)
[error] at sbt.Execute.$anonfun$submit$2(Execute.scala:283)
[error] at sbt.internal.util.ErrorHandling$.wideConvert(ErrorHandling.scala:24)
[error] at sbt.Execute.work(Execute.scala:292)
[error] at sbt.Execute.$anonfun$submit$1(Execute.scala:283)
[error] at sbt.ConcurrentRestrictions$$anon$4.$anonfun$submitValid$1(ConcurrentRestrictions.scala:265)
[error] at sbt.CompletionService$$anon$2.call(CompletionService.scala:65)
[error] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[error] at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
[error] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[error] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[error] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[error] at java.base/java.lang.Thread.run(Thread.java:829)
[error] Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT [*]VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE'"; expected "TOP, DISTINCT, ALL, *, INTERSECTS (, NOT, EXISTS, UNIQUE, INTERSECTS"; SQL statement:
[error] SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE' [42001-220]
[error] at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
[error] at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
[error] at org.h2.message.DbException.getSyntaxError(DbException.java:261)
[error] at org.h2.command.Parser.getSyntaxError(Parser.java:910)
[error] at org.h2.command.Parser.readTermWithoutIdentifier(Parser.java:5283)
[error] at org.h2.command.Parser.readTerm(Parser.java:4983)
[error] at org.h2.command.Parser.readFactor(Parser.java:3463)
[error] at org.h2.command.Parser.readSum(Parser.java:3450)
[error] at org.h2.command.Parser.readConcat(Parser.java:3415)
[error] at org.h2.command.Parser.readCondition(Parser.java:3205)
[error] at org.h2.command.Parser.readExpression(Parser.java:3125)
[error] at org.h2.command.Parser.parseSelectExpressions(Parser.java:2925)
[error] at org.h2.command.Parser.parseSelect(Parser.java:2943)
[error] at org.h2.command.Parser.parseQueryPrimary(Parser.java:2834)
[error] at org.h2.command.Parser.parseQueryTerm(Parser.java:2690)
[error] at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2669)
[error] at org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2662)
[error] at org.h2.command.Parser.parseQueryExpression(Parser.java:2655)
[error] at org.h2.command.Parser.parseQuery(Parser.java:2624)
[error] at org.h2.command.Parser.parsePrepared(Parser.java:732)
[error] at org.h2.command.Parser.parse(Parser.java:697)
[error] at org.h2.command.Parser.parse(Parser.java:674)
[error] at org.h2.command.Parser.prepareCommand(Parser.java:577)
[error] at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:634)
[error] at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:557)
[error] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
[error] at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
[error] at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
[error] at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344)
[error] at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForString(JdbcTemplate.java:196)
[error] at org.flywaydb.core.internal.database.h2.H2Database.determineCompatibilityMode(H2Database.java:97)
[error] at org.flywaydb.core.internal.database.h2.H2Database.<init>(H2Database.java:76)
[error] at org.flywaydb.core.internal.database.h2.H2DatabaseType.createDatabase(H2DatabaseType.java:61)
[error] at org.flywaydb.core.internal.database.base.DatabaseType.createDatabase(DatabaseType.java:149)
[error] at org.flywaydb.core.Flyway.execute(Flyway.java:543)
[error] at org.flywaydb.core.Flyway.migrate(Flyway.java:165)
[error] at io.github.davidmweber.FlywayPlugin$.$anonfun$flywayBaseSettings$47(FlywayPlugin.scala:190)
[error] at io.github.davidmweber.FlywayPlugin$.$anonfun$flywayBaseSettings$47$adapted(FlywayPlugin.scala:190)
[error] at scala.Function1.$anonfun$compose$1(Function1.scala:49)
[error] at sbt.internal.util.$tilde$greater.$anonfun$$u2219$1(TypeFunctions.scala:63)
[error] at sbt.std.Transform$$anon$4.work(Transform.scala:69)
[error] at sbt.Execute.$anonfun$submit$2(Execute.scala:283)
[error] at sbt.internal.util.ErrorHandling$.wideConvert(ErrorHandling.scala:24)
[error] at sbt.Execute.work(Execute.scala:292)
[error] at sbt.Execute.$anonfun$submit$1(Execute.scala:283)
[error] at sbt.ConcurrentRestrictions$$anon$4.$anonfun$submitValid$1(ConcurrentRestrictions.scala:265)
[error] at sbt.CompletionService$$anon$2.call(CompletionService.scala:65)
[error] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[error] at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
[error] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
[error] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[error] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[error] at java.base/java.lang.Thread.run(Thread.java:829)
[error] (flyway / flywayMigrate) org.flywaydb.core.internal.exception.FlywaySqlException:
[error] Unable to determine H2 compatibility mode
[error] -----------------------------------------
[error] SQL State : 42001
[error] Error Code : 42001
[error] Message : Syntax error in SQL statement "SELECT [*]VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE'"; expected "TOP, DISTINCT, ALL, *, INTERSECTS (, NOT, EXISTS, UNIQUE, INTERSECTS"; SQL statement:
[error] SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE' [42001-220]
[error] Total time: 0 s, completed Jul 15, 2023, 12:17:42 PM
Would be nice if you could upgrade to latest flyway 9.x
from flyway-sbt.
Related Issues (20)
- Multiple configuration values HOT 1
- missing tags on GitHub HOT 1
- add support for sbt cross versions HOT 1
- Move documentation to the docs sub directory of this repo and publish from there. HOT 1
- How to make migration task fail for missing migrations? HOT 4
- flywayInfo doesn't log anything? HOT 3
- Update flyway to 5.2.4 HOT 1
- Unable to resolve location classpath:db/migration HOT 5
- Bump flyway to 6.0.7 HOT 1
- H2 support removed by mistake? #2467 HOT 1
- Use scala-steward? HOT 1
- Not able to run command line options in sbt shell
- flyway-sbt version 6.1.4 not found
- Fly way sbt not working when sbt.version in project/build.properties is 1.2.8 HOT 1
- How to use environment variables on sbt flyway plugin? HOT 1
- Missing Tasks
- Version 6.4.3 is not available on maven central HOT 1
- Update to Flyway 6.5.7 HOT 2
- Add support for FLYWAY_CONFIG_FILES option in build.sbt HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from flyway-sbt.