org.flywaydb:flyway-parent

Bug fixes

• Issue 1882 Add Maven artifact install and deploy scripts

• Issue 1884 Undo command does not respect the expected order when used with target

• Issue 1885 Location that only contains repeatable Migrations leads to ArrayIndexOutOfBounds

• Issue 1886 Incorrect WARNING: Ignoring unsupported SQL*Plus statement when "column" text appears on a new line

Thanks to David Atkinson, David J. M. Karlsen, ImmanuelRhesa and quentinbricard for reporting these issues and contributing fixes.

New features

• Issue 1882 Add Maven artifact install and deploy scripts

Changes

• Issue 1881 Update copyright to 2018

Bug fixes

• Issue 1498 Cannot load migration SQL scripts from the root of the classpath in a jarfile

• Issue 1875 SAPHANATable.doDrop() should drop with CASCADE

• Issue 1879 Support for Redshift statements which cannot be run inside a transaction

Thanks to Gareth Rogers, Jonathan Bregler and Matyas Albert Nagy for reporting these issues and contributing fixes.

New features

• Issue 1872 SQL*Plus: Add SHOW EDITION support

Bug fixes

• Issue 502 sp_MSForeachtable statement hangs

• Issue 1250 One connection is used for all migrations causes an issue with session params redefined

• Issue 1508 Support for cleaning SQL Server Rule and Default objects

• Issue 1633 Implementing MigrationInfoProvider.getDescription() returning String longer than 200 characters

• Issue 1676 SQL Server USE statements within migration cause Flyway to fail

• Issue 1838 SQL Server migration batch terminator as first statement gives empty query error

• Issue 1861 SET SERVEROUTPUT ON Not working in 5.0.1 trial

• Issue 1869 Unknown configuration property: flyway.skip when property set to false or null

• Issue 1873 Support for cleaning SQL Server DATABASE triggers

Thanks to Ayrat Natfullin, Catchwa, gscht, mahidbdw, mpapetti, Patrik Duditš and vencoreguy for reporting these issues and contributing fixes.

Bug fixes

• Issue 1859 Validation error with schema_version table name

• Issue 1862 Gradle plugin not published successfully

• Issue 1863 flyway -dryRunOutput causes a migrate when a colon is used instead of =

Thanks to David Atkinson, Marceau Dewilde and Tommy Odom for reporting these issues and contributing fixes.

This release is identical to Flyway 5.0.0. It only adds the platform specific distribution of Flyway Command-line which were missing in Flyway 5.0.0.

Important note for users upgrading from Flyway 3.x: This release no longer supports a schema history table upgrade from Flyway 3.x. You must upgrade to Flyway 4.2.0 first before upgrading to Flyway 5.0.0.

Important note for EnterpriseDB, Vertica, SolidDB, Phoenix and Greenplum: Support for these databases has been kept back and will be integrated later in the Flyway 5.0 series. You can keep using Flyway 4.2.0 until then.

New features

• Issue 87 Output to sql file instead of committing against the DB

• Issue 109 Undo migrations

• Issue 797 Official Flyway Dockerfile

• Issue 809 Promote internal logging wrapper to external API

• Issue 944 Allow to use paths relative to flyway.conf location

• Issue 1562 Add flyway.configFiles support to Gradle plugin

• Issue 1624 Multiple configuration files

• Issue 1663 Support Testcontainers JDBC connection string

• Issue 1693 Command-line: Add -D support to define JVM system properties

• Issue 1699 Command-line: allow setting system properties in config file

• Issue 1727 Command-line: JAVA_ARGS environment variable support

• Issue 1728 Command-line: Use Windows CLASSPATH environment variable

• Issue 1733 Redshift JDBC 4.2 driver support

• Issue 1742 Allow Multiple Suffixes/File Extensions

• Issue 1754 Allow injecting a complete Configuration

• Issue 1760 CockroachDB support

• Issue 1777 Sybase ASE jConnect JDBC driver support

• Issue 1804 Repair: also correct migration type

• Issue 1806 Oracle: Automatically enable support TNSNames aliases if TNS_ADMIN is set

• Issue 1819 Flyway Command-line now ships with the official Microsoft JDBC driver for SQL Server

• Issue 1845 Oracle SQL*Plus commands support

• Issue 1849 Show output from select statements in console

Incompatible changes

• Issue 109 The FlywayCallback interface has 4 new methods: beforeUndo , beforeEachUndo , afterEachUndo and afterUndo

• Issue 109 The MigrationInfoProvider interface has 1 new method: isUndo

• Issue 109 The MigrationState enum has 2 new elements: AVAILABLE and UNDONE

• Issue 1402 Maven 3 is now the new minimum supported version

• Issue 1429 Gradle 3.0 is now the new minimum supported version

• Issue 1577 Flyway now fails on incorrect parameter instead of showing a warning

• Issue 1692 Java 8 is now the new minimum supported version

• Issue 1818 Sybase ASE 15.7 is now the new minimum supported version

• Issue 1820 DB2 z/OS support has been discontinued

• Issue 1827 Redshift users must now connect using the Redshift driver. Connections with the PostgreSQL driver are no longer supported.

• Issue 1841 MigrationState.SUPERSEEDED has now been renamed to SUPERSEDED

• Oracle 12.1 is now the new minimum supported by Flyway Community Edition

• SQL Server 2014 is now the new minimum supported by Flyway Community Edition

• DB2 10.5 is now the new minimum supported by Flyway Community Edition

• MySQL 5.5 is now the new minimum supported by Flyway Community Edition

• MariaDB 5.5 is now the new minimum supported by Flyway Community Edition

• PostgreSQL 9.3 is now the new minimum supported by Flyway Community Edition

• SAP HANA 2.0 is now the new minimum supported by Flyway Community Edition

• HSQLDB 2.0 is now the new minimum supported by Flyway Community Edition

• Derby 10.11 is now the new minimum supported by Flyway

Changes

• Issue 1752 Flyway Command-line now ships with MariaDB JDBC driver 2.2.0 Pull Request

• Issue 1756 Flyway Command-line now ships with PostgreSQL JDBC driver 42.1.4

• Issue 1822 Flyway Command-line now ships with H2 1.4.196

• Issue 1823 Flyway Command-line now ships with HSQLDB 2.4.0

• Issue 1824 Flyway Command-line now ships with SQLite 3.20.1

• Issue 1848 The default for flyway.table has been changed from schema_version to flyway_schema_history

• Issue 1850 The Flyway Command-line platform-specific archives now ship with JRE 8u152

Bug fixes

• Issue 183 Multiline RULE declarations are not parsed correctly

• Issue 1167 Clean on DB2 functions or procedures fails when two procedures have the same name Pull Request

• Issue 1305 Maven warning when using Flyway plugin with parallel builds

• Issue 1336 State column contents truncated in Info command

• Issue 1361 Clean fails to DROP AGGREGATE in SQL Server

• Issue 1426 SQL Server: ALTER DATABASE ... SET SINGLE_USER not supported

• Issue 1550 Numerous flaws in Clean implementation for Oracle DB Pull Request

• Issue 1554 validate does not respect target

• Issue 1575 Command info: Comparison method violates its general contract

• Issue 1601 Clean improvements for Oracle pt.2 Pull Request

• Issue 1620 Flyway logs passwords at INFO level

• Issue 1625 Callbacks are added and executed multiple times

• Issue 1627 Appengine & ClassPathScanner : throw AccessControlException since 4.1.0

• Issue 1634 DB2 inserting of triggers fails, depending on the format of the statement

• Issue 1636 Metadata table creation error is not reported

• Issue 1642 Java error when running flyway from bash shell of Git for Windows Pull Request

• Issue 1649 flyway:clean fails on db2 when trying to drop versioning on tables which is accessed by a MQT Pull Request

• Issue 1654 Deadlock produced in Postgres when running migrations in parallel with a migration task containing CREATE INDEX CONCURRENTLY Pull Request

• Issue 1678 ignoreMissingMigrations default not specified

• Issue 1686 Gradle plugin warning after migrating to Gradle 4.0 Pull Request

• Issue 1690 Support for labels preceding DB2 SQL PL BEGIN ... END block

• Issue 1691 DB2 stored procedure nested block support

• Issue 1694 Can't use Use MSDB in SQL server

• Issue 1701 Table.exists() very slow in Postgres Environments with a lot of objects Pull Request

• Issue 1711 SQL Server BACKUP and RESTORE statements broken

• Issue 1713 Suppress redundant "SQLite does not support setting the schema..." messages

• Issue 1723 Anonymous block in SAP HANA is not working

• Issue 1726 outOfOrder parameter value not validated

• Issue 1729 Resource leak detected enabling Strict Mode on Android platform Pull Request

• Issue 1732 Cannot create metadata table in DB2 when default table organization is set to column

• Issue 1757 Warn on incompatible class change

• Issue 1764 USE sql command leaks to subsequent migration files

• Issue 1782 First character in script column of schema_version table removed if double back slashes in location.

• Issue 1802 Clean fails when Postgres DOMAIN depends on SEQUENCE

• Issue 1813 Checksum mismatch error not helpful

• Issue 1817 DB2 truncate statement fails under Flyway 4.2.0

• Issue 1831 Incorrect Redshift search_path parsing

• Issue 1842 Oracle: Ignore lone /

• Issue 1846 Oracle statement fails when it contains DATE'11/29/2017' and no space in between

• Issue 1847 Documentation is not clear about the definition of missing and future migration

• Issue 1851 CockroachDb invalid default database name Pull Request

• Issue 1854 Adding comment surrounding usage of Oracle TNS Connection string

Thanks to Alexei Osipov, andrey-poltavskiy, aoksys, Carl Taylor, Christopher Smith, Craig Davidson, czyzby, Dennis Hoer, djohnsonmach, FlakM, Francesco Proietti, George Thomas, Gili Tzabari, hmtelbi, Igor Nikolaev, J0s3f, Jason Hinch, Jasper Brekelmans, Jasper van Wanrooy, jcoulehan, Jeffrey Li, Jens Doose, Jidehem, John McCall, Joshy Austin, jsross, Julien Coupez, Kevin Bloch, masc3d, Mattias Sällström, Mihir Mehta, mstarita, nvartolomei, o2dac, pswrdf, rbatllet, Renat Sabitov, Rob34, RobertRad, Roger Qiu, Sabine Heimsath, sandman24, sasivarnans, Simon Kissane, Stefano Teodorani, Stephan Pauxberger, Tibor Baksa, ToBeReplaced, Victor Osolovskiy, vojbarzz, wanglin0413, xindu and Yogi2803 for reporting these issues and contributing fixes.

New features

• Issue 181 Support Multiple Migrations within a single Transaction € Sponsored

• Issue 1219 Pivotal Greenplum support Pull Request

Changes

• Issue 1585 Rename allowMixedMigrations to mixed

• Issue 1588 Enable single-connection mode for SQL Server

• Issue 1589 Enable single-connection mode for DB2

• Issue 1590 Enable single-connection mode for Derby

Bug fixes

• Issue 1549 Flyway "(unsupported protocol: war)" with Tomcat 8.0.41 and unpackWARs=false Pull Request

• Issue 1553 cleanOnValidationError does not recover from "Detected failed migration" error

• Issue 1558 Fixed the current schema/current user confusion in OracleSchema Pull Request

• Issue 1559 Forbid performing Clean command against all system schemas in Oracle Pull Request

• Issue 1566 Make default resolvers handle all locations in one instance Pull Request

• Issue 1573 Clean improvements for Oracle Pull Request

• Issue 1578 Oracle statement fails when it contains 'string'as and no space in between

• Issue 1587 Repeatable migration with version incorrectly detected as versioned migration

• Issue 1607 For Postgresql migrations, add support for "DROP INDEX CONCURRENTLY .*" Pull Request

• Issue 1611 Fix a minor typo in Javadoc Pull Request

Thanks to Brian Chen, Durim Kryeziu, Gili Tzabari, Jamie Swain, mtcremin, Stephan Pauxberger, svitalsky, Thomas Meyer and Victor Osolovskiy for reporting these issues and contributing fixes.

Bug fixes

• Issue 1531 SAP HANA: CREATE PROCEDURE statements with embedded semicola don't work Pull Request

• Issue 1534 MetaDataTable not updated with autoCommit false

• Issue 1537 PostgreSQL: Flyway fails after applying migration containing SET ROLE statement

• Issue 1539 Gradle: Unable to instantiate JDBC driver declared as buildscript dependency

• Issue 1540 WITH (OIDS=FALSE) fails on CockroachDB

Thanks to ace130-github, Fabian Vogler, Geir Harald Hansen, Sachin Walia and sergey-selivanov for reporting these issues and contributing fixes.

Bug fixes

• Issue 1095 MSSQL Server: exclude microsoft tools procedures/functions from empty schema detection Pull Request

• Issue 1525 JRE missing from 4.1.0 release

• Issue 1527 Unable to instantiate JDBC driver defined in compile scope from Gradle plugin

• Issue 1533 NullPointerException while applying repeatable migration with Maven

Thanks to Dennis Hoer, Jean Revertera, Lightside Tech and Victor Boldurat for reporting these issues and contributing fixes.

New features

• Issue 364 EnterpriseDB support Pull Request

• Issue 738 Support multiple tasks of the same type in gradle

• Issue 851 Support for PostgreSQL statements that cannot run within a transaction € Sponsored by JustWatch and Porch

• Issue 1151 Support overriding of installed_by user in metadata table

• Issue 1352 Add ignoreMissingMigrations flag

• Issue 1477 Commandline: Add -n flag to suppress credentials prompt

Incompatible Changes

• Issue 1345 baseline() is now idempotent even after applying migrations Pull Request

Changes

• Schema marker metadata table entries (generated when Flyway creates a schema) do not have an explicit version anymore

• H2 Jdbc driver: Flyway is now tested with 1.4.193 (was 1.4.191)

• Hsql Jdbc driver: Flyway is now tested with 2.3.4 (was 2.3.3)

• The Gradle plugin has now been rewritten in Java (used to be written in Groovy)

Bug fixes

• Issue 1067 Metadata table creation failure with fresh db

• Issue 1163 DB2 change delimiter using --#SET TERMINATOR

• Issue 1180 sqlite: flyway migrate fails, reports database is locked

• Issue 1261 classpath scanner does not find db.migration package or resources € Sponsored by Startrack

• Issue 1318 sqlite DB locked when you specify flywayDriver

• Issue 1331 Validation fails on migrate when schema doesn't exist

• Issue 1333 OracleDB failed to migrate while schema name contains character "-"

• Issue 1346 Migration hanging with HsqlDB 2.3.4

• Issue 1348 Remove warning when using flyway.version maven property

• Issue 1351 Repair does not fix "Migration Description mismatch" error

• Issue 1358 Reverted version of a repeatable script should be reapplied

• Issue 1363 ValidateOnMigrate should fail for unapplied migration when outOfOrder=false Pull Request

• Issue 1364 Validate with target=current should fail on unapplied migration

• Issue 1368 Possible race condition on MetaDataTable-Upgrade

• Issue 1369 support for IBM DB2 users with dashes in username (like 'A-A')

• Issue 1382 Inconsistent usage documentation: conf/flyway.conf vs conf/flyway.properties vs ./flyway.conf Pull Request

• Issue 1387 schema_version column version not nullable on Sybase ASE

• Issue 1396 Log the inner exception thrown from JdbcMigrationResolver.resolveMigrations()

• Issue 1401 Not getting the full stack error

• Issue 1415 performance improvements when installing a large number of migration scripts

• Issue 1428 Repeatable migrations - error in case of checksum mismatch

• Issue 1430 Having only Repeatable Migrations crashes Flyway

• Issue 1446 SQL parsing problem when combining Postgres's COPY ... FROM stdin and SQL domains

• Issue 1457 When migrations have been applied by enabling out-of-order Flyway displays the wrong current version

• Issue 1463 Unable to clean schema that contains function calling another function and both have SCHEMABINDING

• Issue 1468 Using flyway.serverId produces WARNING log

• Issue 1470 Add support for Oracle editionable objects Pull Request

• Issue 1474 ClassCastException in AndroidScanner Pull Request

• Issue 1483 Flyway doesn't recognize Sybase ASE 12.5

• Issue 1487 Exception "Unable to resolve Jdbc Java migrations in location" due to wrong assumption on classloader behavior

• Issue 1499 Sqlite locks when attempting a migration result in SQLException: [SQLITE_BUSY]

• Issue 1512 Warnings when application is packaged as a Spring Boot executable war

Thanks to Andrew Berglund, Andrew McLaughlin, Antti Lampinen, azalesky, Benoit Devos, blimey74, Brian Krahmer, chrstnk, Craig Pardey, cristalp, David Vázquez Púa, Dustin Conrad, Eugen Pribulla, G. Richard Bellamy, JasonAUnrein, Jason Turim, JB Nizet, Jeremy Bush, Joris Kuipers, Juan Liska, masc3d, Michael Prankl, nathansgreen, Olivier Gérardin, PeeZu, Petar Tahchiev, pswrdf, qwazer, reactormonk, rousej, Stefan Ferstl, Stefan Hausner, sw00, Taufiq Hoven, tomaszglinski toro01 and zvika77 for reporting these issues and contributing fixes.

Special thanks to JustWatch , Porch and Startrack for sponsoring features and fixes.

Bug fixes

• Issue 1313 Flyway 4.0.1 Repeatable migrations running before versioned.

• Issue 1339 SQLite blob literal parsing support Pull Request

• Issue 1341 SQLite system table no drop Pull Request

Thanks to aaltergot and hartrc for reporting these issues and contributing fixes.

Changes

• Issue 1319 Update MariaDB driver to latest version

Bug fixes

• Issue 1211 PostgreSQL upper case schema names end up double quoted

• Issue 1307 Removed drop table because of issues with partitioned tables Pull Request

• Issue 1309 Maven plugin : warning about flyway.configFile

• Issue 1326 SqlScriptFlywayCallback errors in ALL_CALLBACKS list

• Issue 1327 Option to Suppress "SQLServer does not support setting the schema..." messages

Documentation fixes

• Issue 1312 Clarify validate javadoc

Thanks to Dennis Hoer, frbo42, Gili Tzabari, hartrc, John McCall, lrozenblyum, smohara and Sten Røkke for reporting these issues and contributing fixes.

Bug fixes

• Issue 1120 Db2 z/OS 3.x->4.0 migration, storage group setting, moved tests Pull Request

• Issue 1216 Parsing of string literals

• Issue 1220 Sybase support does not work with Sybase ASE 15.7 Pull Request

• Issue 1222 Regression with MySQL delimiter in Flyway 3.2

• Issue 1226 Postgres clean drop all types Pull Request

• Issue 1227 Resources not found from bundles without wiring to org.osgi.framework Pull Request

• Issue 1231 Upgrading AWS Redshift DB from Flyway 3.2.1 to 4.0 failed - couldn't upgrade metadata table Pull Request

• Issue 1233 Allow commandline client to specify placeholderReplacement Pull Request

• Issue 1235 Flyway upgrade from 3.2.1 to 4.0 fails with Oracle error ORA-00955: name is already used by an existing object Pull Request

• Issue 1238 Dollar-quoted PostgreSQL function definitions are parsed incorrectly in some situations

• Issue 1245 Flyway 4.0 config Postgres requires user/pass

• Issue 1249 MigrationInfoImpl violates the compareTo contract

• Issue 1255 Issue with create schema_version for Sybase ASE

• Issue 1264 Regression in multiline comments/quotes handling

• Issue 1265 Upgrade metadata table to v4.0 fails on Derby Pull Request

• Issue 1270 Vertica does not support repeatable migrations

• Issue 1280 beforeEachMigrate callback can't change search_path anymore

• Issue 1292 Clean does not delete procedures on case sensitive SQLServer Pull Request

• Issue 1293 Flyway cannot create schema table on Galera cluster (MariaDB) Pull Request

• Issue 1296 Order in which callbacks are executed

• Issue 1298 Warning about flyway.current property

• Issue 1299 Using MySQL Connector/J 6.x warns about JDBC driver class name

• Issue 1300 Fail if user is set in Flyway config, but password is only present in settings.xml

• Issue 1301 Fix IBM classloader regression Pull Request

• Issue 1302 NullPointerException migrating to "current" on empty DB

Documentation fixes

• Issue 62 Fix jre setup documentation

• Issue 65 Rewrite Android documentation to fit Android Studio/Gradle and SQLDroid better Pull Request

• Issue 66 fix sbt version Pull Request

• Issue 68 Remove flywaySettings from sample configurations Pull Request

• Issue 70 Fix of lost tag pre around sample configuration Pull Request

• Issue 1275 Document SBT custom configuration usage

• Issue 1277 The fact that repeatable migrations are applied after versioned migrations should be documented explicitly

Thanks to alekseevIN, Alexey Kobyakov, Antti Lampinen, Artem Konenko, Aurélien Mino, azalesky, Erin Drummond, fromi, Gian Marco Gherardi, Gili Tzabari, hntran8, J. Taylor O'Connor, Jeff Johnston, Johannes Brodwall, Kari Häkkinen, Kenji Yoshida, Kevin Wimmer, krispii, lrozenblyum, Maksim Serebro, Marat Abrarov, mezuzza, Nathan Vick, Nick Strecker, oohira, Renat Sabitov, ridiekel, sourcesmith, Sten Røkke, tsbx, Walter Gillett and Werner Mueller for reporting these issues and contributing fixes.

This version comes with a new metadata table format . Migration is transparent and automatic on first run of any Flyway command. This new format is not compatible with older Flyway versions.

Note: DB 2 z/OS, Vertica, and solidDB users may have to manually upgrade the metadata table or drop it and baseline the schema again.

New features

• Issue 102 Sybase ASE support Pull Request

• Issue 128 Repeatable Migrations support

• Issue 458 Allow disabling clean

• Issue 724 Prompt for userId and password in commandline mode

• Issue 805 JdbcMigrations and new FlywayCallback should have access to core configuration Pull Request

• Issue 929 Apache Phoenix Support Pull Request

• Issue 935 SAP HANA support € Sponsored by Softronic

• Issue 985 Log the update count with DEBUG priority after running a SQL script Pull Request

• Issue 1047 Using both custom and SQL callbacks

• Issue 1078 Allow default migration resolvers to be overriden Pull Request

• Issue 1117 Transparently upgrade metadata table from 3.x to 4.x format

• Issue 1119 Redshift-specific JDBC driver support Pull Request

• Issue 1114 Command-line tool: Add -v to print version and exit

• Issue 1188 Datasource auto-configuration when running in a Boxfuse instance

• Issue 1198 Included abstract base classes for resolvers and migrations Pull Request

Incompatible Changes

• Issue 477 When a location is not found a warning is now emitted instead of an exception

• Issue 724 When using the command-line tool with no database user or password, you must now pass in an empty value to avoid being prompted

• Issue 767 mvn flyway:clean is now executed in the clean phase by default

• Issue 891 The Flyway SBT plugin now requires SBT 0.13.7

• Issue 935 Command-line: error messages are now sent to stderr instead of stdout Pull Request

• Issue 979 The default location for the Flyway Maven, Gradle and SBT plugins is now filesystem:src/main/resources/db/migration

• Issue 988 Fail validate if an already applied migration couldn't be found

• Issue 989 To ignore failed future migrations, you must now also set ignoreFutureMigrations to false .

• Issue 1116 Removed all deprecated API from Flyway 3.x

Changes

• Issue 977 Flyway now warns on invalid command-line options

• Issue 1152 Upgrade Command-line tool bundled JRE to 8u74

• Issue 1214 Upgrade Command-line tool bundled JDBC drivers to latest versions

Bug fixes

• Issue 178 Support for reference-partitioned tables (Oracle 11g) Pull Request

• Issue 253 Ignore line endings when calculating checksums

• Issue 669 Ignore sqlplus set define off command

• Issue 737 search_path is not restored after migration

• Issue 763 sbt tasks do not use scope specific settings Pull Request

• Issue 788 Provide default implementation for FlywayCallback

• Issue 905 NullPointerException at org.flywaydb.maven.MigrateMojo.doExecute(MigrateMojo.java:35)

• Issue 917 After running flywayMigrate in SBT there is no straightforward way to know current db version

• Issue 983 Redshift COPY not working

• Issue 995 Error setting current schema to "public"

• Issue 999 ClassCastException in PostgreSQLDbSupport.executePgCopy when using BasicDataSource Pull Request

• Issue 1000 SQL exception in COPY statement when the DELIMITER is set to a semicolon

• Issue 1001 Gradle plugin can not set placeholderReplacement property

• Issue 1023 Flyway should not expect "org/flywaydb/core/internal/version.txt" to be on the custom classpath

• Issue 1025 afterEachMigrate fails, migration succeeds, but migration not written to schema_version

• Issue 1033 Missing Import-package MANIFEST.MF headers for postgresql

• Issue 1036 ORA-00911: invalid character

• Issue 1042 Single connection in DriverDataSource can never be closed

• Issue 1043 Migration with Flyway.setPlaceholderReplacement(false) fails with "org.flywaydb.core.api.FlywayException: No value provided for placeholder expressions"

• Issue 1049 ORA-32794 in Oracle 12c using identity columns

• Issue 1075 Support option to use Slf4j/Commons Logging/JUL when using the command line tool

• Issue 1077 Oracle JDBC issue on Linux - IO Error: Connection reset

• Issue 1080 ORA-00911: Invalid character on 'From' Pull Request

• Issue 1081 Change of Delimiter does not work correct for SQLite

• Issue 1085 Clean on embedded derby database does not clean triggers

• Issue 1089 SQL cannot be parsed when using binary type "char (16) for bit data": X'0123' Pull Request

• Issue 1093 ORA-01950 on schema baseline/init in Oracle 12.1

• Issue 1099 Flyway fails to connect with the database if the OS user name is longer than 30 characters

• Issue 1106 A tableName """t""" cause error on PostgreSQLSchema.doAllTables()

• Issue 1108 Flyway does not reset the current schema between migrations

• Issue 1109 ORA-65040 error when trying to clean different schema with system user

• Issue 1111 Support for Vertica (or replace) Function Pull Request

• Issue 1124 Fix flyway script on Git Bash for Windows Pull Request

• Issue 1129 Fails to clean materialized view that has dependent view on postgres

• Issue 1136 Multi Line comments are not handled correctly Pull Request

• Issue 1142 OsgiClassPathLocationScanner supports only current bundle Pull Request

• Issue 1154 Drop functions with length attributes in DB2 Pull Request

• Issue 1164 Use nanoTime() for StopWatch Pull Request

• Issue 1165 Sql file callbacks does not work with empty sqlMigrationPrefix

• Issue 1171 GAE uses different Driver: Unable to obtain Jdbc connection from DataSource Pull Request

• Issue 1190 PostgreSQL: Filter functions and views from extensions during clean Pull Request

• Issue 1193 Unable to clean schema that contain a Computed Column Defined with a User-Defined Function

• Issue 1196 PostgreSQL: trim schema name

• Issue 1197 Improved JavaDoc for callbacks, resolvers and migrations Pull Request

• Issue 1217 Fixed flyway 4.0 upgrade for Redshift (it does not support alter column) Pull Request

Documentation fixes

• Issue 49 Sentence was missing a word Pull Request

• Issue 53 Minor wording change in documentation around Java class naming Pull Request

• Issue 607 Doc enhancement: More features for the feature comparison matrix

Thanks to aegyed, Aurélien Mino, axaluss, Barry O'Neill, cajnoj, Christian Dedié, crump32, David Phillips, diwa, dukeyin, dzharikhin, Dzmitry Lazerka, Eduardo Piaro, Eric Parton, Fabio Lisboa, Gili Tzabari, gnomff, hamiller, Jason Wong, Jens Berke, Jens Doose, JGMM, Josh Mahonin, Karel Rank, Kevin Sheedy, khelsen, Kristopher Landon, Larivact, Lukas Eder, Luke Pryor, Marc-André Poulin, Mark Petrovic, Markus Umefjord, martin-grofcik, mdaquel, Michael Verrilli, MingoDynasty, mojoo, Nathan Vick, Neo Wu, Nitin Gautam, Pascal Gruen, pentavalle, pingw33n, PredatorVI, Ringerl, Sachin Walia, Salman Haq, sastorsl, Sebastian Tacke, Stephan Pauxberger, stkuehnl, Sylvain Guillopé, thelateperseus, Tim Büthe, Tom Eicher, Yevgeniy Mordovkin and ysobj for reporting these issues and contributing fixes.

Bug fixes

• Issue 969 Fix SQL syntax error in MetaDataTableImpl.java Pull Request

• Issue 971 Regression in 3.2: Invalid charater Pull Request

Thanks to avesse, David J. M. Karlsen and soemeier for reporting these issues and contributing fixes.

New features

• Issue 732 The command-line tool now optionally ships with a JRE

• Issue 885 SolidDB support Pull Request

• Issue 906 Option to validate only until current version of the schema Pull Request

• Issue 909 The commandline tool now also ships with the Derby Client driver

• Issue 915 Command-line: -q switch for quiet mode Pull Request

• Issue 945 Allow to skip placeholder resolution

• Issue 956 Try to load configFile from current directory first

Changes

• Issue 752 Deprecated Flyway.setBaselineVersion(String) , use setBaselineVersionAsString(String) instead.

• Issue 752 Deprecated Flyway.setTarget(String) , use setTargetAsString(String) instead.

• Issue 752 Deprecated Flyway.setCallbacks(String...) , use setCallbacksAsClassNames(String...) instead.

• Issue 752 Deprecated Flyway.setResolvers(String...) , use setResolversAsClassNames(String...) instead.

• Issue 895 Deprecated Gradle plugin ID flyway , use org.flywaydb.flyway instead. Pull Request

• Issue 966 Commandline: Deprecated jarDir , use jarDirs instead.

Bug fixes

• Issue 598 No "current" schema in flyway.url causes a Flyway exception

• Issue 752 Overloaded setters break Spring XML usage € Sponsored by David Harrigan

• Issue 892 Using (deprecated) init goal in Maven takes wrong baseline version

• Issue 893 Add command images to Javadoc

• Issue 898 Flyway baselines new schemas, since they always have a schema_version table

• Issue 902 slf4j optional package import missing from OSGi manifest

• Issue 903 Fix an error where MigrationVersion wouldn't parse correctly Pull Request

• Issue 905 NullPointerException at org.flywaydb.maven.MigrateMojo.doExecute(MigrateMojo.java:35)

• Issue 918 Explicitly drop Views then doing a Flyway.clean() on a PostgreSQL db

• Issue 921 Incorrect parsing when space is missing between end quote and next token

• Issue 922 Escape command-line arguments

• Issue 939 Multiline comment closing not detected properly

• Issue 940 Implicit baseline triggered by baselineOnMigrate does not respect baselineVersion

• Issue 951 Still issues with the Gradle plugin under Java 6

• Issue 955 Loading configFile from relative path seems to be broken

• Issue 957 Improve DataSource not set error message for non-API clients

• Issue 958 Backslashes are not treated properly in conf file

• Issue 965 Problem with double quotes

Documentation fixes

• Issue 959 Gradle documentation should have commas to separate placeholders

Thanks to Adrian Christen, Andrew Murray, Armin Gattung, benheilers, Cosmin Stejerean, David M. Carr, david-mas, Diego Plentz, Gili Tzabari, gergelyszakacs, janbols, Marcello Nuccio, Mauro Molinari, Michael Forstner, pete-experimenter, Rahul Prabhakar, Sabine Gallus, Sanjay Deshmukh, sogft, Sudeep Ambekar and vaesbart for reporting these issues and contributing fixes.

New Features

• Issue 344 HP Vertica support Pull Request

• Issue 638 DB2 on z/OS support Pull Request

• Issue 661 AWS Redshift support Pull Request

• Issue 728 SQL-based callbacks

• Issue 731 Package JDBC drivers with command-line tool

• Issue 778 Maven plugin: Expose new DB version in flyway.current property Pull Request

• Issue 834 Use Slf4j for logging if available

• Issue 863 PostgreSQL COPY ... FROM STDIN support € Sponsored by Dembach Goo Informatik

Incompatible Changes

• Issue 860 The FlywayCallback interface has two new methods: beforeBaseline() and afterBaseline() .

• Issue 860 info() now returns INIT migrations as BASELINE.

• Issue 860 info() now returns PREINIT migrations as BELOW_BASELINE.

Changes

• Issue 860 Deprecated init() , use baseline() instead.

• Issue 860 Deprecated initVersion , use baselineVersion instead.

• Issue 860 Deprecated initDescription , use baselineDescription instead.

• Issue 860 Deprecated initOnMigrate , use baselineOnMigrate instead.

• Issue 860 Deprecated FlywayCallback.beforeInit() , use FlywayCallback.beforeBaseline() instead.

• Issue 860 Deprecated FlywayCallback.afterInit() , use FlywayCallback.afterBaseline() instead.

• Issue 860 Deprecated MigrationState.PREINIT , use MigrationState.BELOW_BASELINE instead.

• Issue 860 Deprecated MigrationType.INIT , use MigrationType.BASELINE instead.

• Derby Jdbc driver: Flyway is now tested with 10.11.1.1 (was 10.8.2.2)

• Hsql Jdbc driver: Flyway is now tested with 2.3.2 (was 2.2.8)

• PostgreSQL Jdbc driver: Flyway is now tested with 9.3-1102-jdbc4 (was 9.0-801.jdbc4)

• SQLite Jdbc driver: Flyway is now tested with sqlite-jdbc 3.7.15-M1 (was sqlite-jdbc 3.7.2)

Bug fixes

• Issue 691 Clean fix #664 breaks DB2 clean in some cases

• Issue 718 SQLServer: no exception thrown when statement fails Pull Request

• Issue 735 cygwin classpath problem Pull Request

• Issue 742 flyway info does cuts off or truncates information

• Issue 746 Unhelpful error when forgetting "flyway.driver" with xerial sqlite-jdbc

• Issue 754 flyway fails to remove forward slash from a script if it contains a comment Pull Request

• Issue 758 Fixed OSGi metadata table create script loading Pull Request

• Issue 761 Clean Oracle scheduled jobs Pull Request

• Issue 770 Improve Oracle error - show the ORA code

• Issue 774 Informational message from database logged at WARN level Pull Request

• Issue 779 Restore JDK6 compatibility for Gradle plugin Pull Request

• Issue 783 Spring Jdbc not available from command line

• Issue 793 MySQL flywayMigrate fails due to user permission

• Issue 800 Handle Oracle java source Pull Request

• Issue 801 ClassPathScanner fails with enum

• Issue 802 Clean on DB2 does not clean triggers Pull Request

• Issue 806 Flyway does not clean sequences on SQL Server 2012

• Issue 816 Allow newer migrations to exist and be skipped by validateOnMigrate

• Issue 824 Classpath scanner does not detect sql-files in WEB-INF/classes in (non-exploded) war-file

• Issue 825 Warn instead of fail when clean cannot find a schema

• Issue 830 Allow gradle plugin to create multiple migrate tasks for different schemas Pull Request

• Issue 842 migrate [initOnMigrate, initVersion] should use initVersion when the schema does not exist

• Issue 843 Flyway suppresses warnings silently on SQLException

• Issue 866 Classpath Scanner swallows Instantiation Exceptions

• Issue 867 DB2 schema clean fails for expression-based index

• Issue 868 Update filed for MSSQL scripts containing 'Go'

• Issue 871 Please include SQLException message when failing to connect

• Issue 877 Exception cause lost in classutils instantiateAll

• Issue 884 Flyway incorrectly handles paths with a + in their name

Thanks to Adrian Chung, aldas, Armin Gattung, Boris Stumm, Brandon Bremen, Carlo Conserva, Christine Teig, cowwoc, crannym, Dan Nawrocki, Dembach Goo Informatik, Deryl Spielman, everflux, flavor8, Hurricane Hamilton, James Elliott, Jurica Krizanic, larry-s, Lukasz Rozek, Mark Sievers, Michael Yaakoby, Mikhail Chibel, Muni10, Nathan Vick, Nick Golubev, Olivier Adam, orbfish, PeeZu, Ray Holder, rekonvald, Rao Sadhu, Sajan Chandran, Sebastian Vuorinen, Siva Panduranga Stephan Pauxberger, Steve Todd, Tom Eicher, Wilkin Cheung and Yiyu Jia for reporting these issues and providing fixes.

New Features

• Issue 76 SQLite & Android support

• Issue 353 Command-line tool: Multiple operations can now be specified at once

• Issue 469 Custom MigrationResolver support

• Issue 618 Repair: update checksums after migration

• Issue 626 Custom ClassLoader support

• Issue 651 Pre and post hooks for each operation Pull Request

• Issue 655 Disable transaction for a particular migration

• Issue 667 MariaDB support

• Issue 679 Allow to configure maven plugin from a property file

• Issue 730 Configurable separator between version and description

Incompatible Changes

• Dropped compatibility with the Flyway 1.X metadata table format. If you are upgrading from 1.X, you must upgrade to 2.3 first, before upgrading to 3.0.

• Issue 97 Validate should fail if there are migrations in source that have not been run on the database

• Issue 536 Drop Java 5 support & remove deprecated API

• Issue 537 Move packages & groupId from com.googlecode.flyway to org.flywaydb

• Issue 695 validateOnMigrate is now true by default

Changes

• DB2 Jdbc driver: Flyway is now tested with db2jcc4 4.17.29 (was db2jcc 3.62.56)

• Oracle Jdbc driver: Flyway is now tested with OJDBC6 12.1.0.1 (was OJDBC5 11.2.0.2.0)

• PostgreSQL Jdbc driver: Flyway is now tested with 9.0-801.jdbc4 (was 9.0-801.jdbc3)

• SQL Server Jdbc driver: Flyway is now tested with Jtds 1.3.1 (was 1.2.7)

Bug fixes

• Issue 430 Display the connection url

• Issue 484 IllegalArgument when executing Flyway Ant build script several times in the same JVM

• Issue 489 Validate does not report different descriptions for same version

• Issue 496 Need sql print statements to be logged in Flyway logs

• Issue 540 ORA-00900: invalid SQL statement - bug in the parser

• Issue 543 Parser does not properly recognize some multiline string literals

• Issue 557 MySQL statement not recognized due to a space character at the end of a comment directive

• Issue 584 NumberFormatException thrown when using command line tools

• Issue 606 Found more than one migration with version when multiple locations named with the same roots

• Issue 612 Inconsistent definition of "locations" parameter

• Issue 621 flyway clean does not remove mysql events

• Issue 639 Flyway migrates correctly. but in the schema_version table the scriptname is prefixed with a /

• Issue 642 Local migration file overwrites database's description

• Issue 673 Some Unicode characters can still lead to StringIndexOutOfBoundsException Pull Request

• Issue 678 flyway fails recognizing sql server delimiter while parsing sql migration

• Issue 681 Maven site complains that repository url 'http://flywaydb.org/repo' is invalid

• Issue 682 Maven Plugin - Cannot set boolean system property Pull Request

• Issue 684 Allow passing custom initialization SQL for database connections Pull Request

• Issue 687 Oracle cleanup - flyway fails on tables that have Flashback enabled Pull Request

• Issue 688 Support for Oracle cluster Pull Request

• Issue 692 Flyway doesn't remove trailing slash in PL/SQL block

• Issue 694 sbt: Allow specifying URL through system properties Pull Request

• Issue 697 flyway:clean doesn't remove compiled java source Pull Request

• Issue 706 Info marks schema creation as missing (should be success)

• Issue 708 flyway.repair() doesn't commit when data source is not autocommit

• Issue 716 Load and inject configured Custom MigrationResolver implementations

• Issue 720 FlywayException message is not saying anything usefull Pull Request

• Issue 725 NullPointerException in quoteReplacement

• Issue 727 fix placeholders override by property configuration and add sbt large test for placeholders

Thanks to adelinor, adiGadiG, Andriy Binetskyy, Anthony Galea, Antti Virtanen, awal11, Ben Manes, bobwenx, Brian Hartin, Christian Dedie, cowwoc, Craig Forbes, Dan Bunker, Deryl Spielman, Eric Jain, Eugen Pyanov, Fatos Sopjani, Fernando Correia, Gerald Quintana, ggrussenmeyer, gregul, Jon Todd, Jonathan Holloway, kavithaparameswaran, kongslund, Lidija, Lukasz Rozek, Michal Lisiecki, Mircea Pop, Nicolas Peters, Patrick Kranz, Prismapanda, quiver, rattigan, Regis Leray, Roger Brechbühl, samidha14 and vertex-github for reporting these issues and providing fixes.