---
layout: documentation
menu: releaseNotes
subtitle: Release Notes
---
<h1>Release Notes</h1>
<p>Thank you all for reporting all these issues and contributing fixes!</p>
<div class="release">
<h2 id="4.1.0">Flyway 4.1.0 (2017-01-XX)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1348">Issue 1348</a>
Remove warning when using flyway.version maven property
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1468">Issue 1468</a>
Using flyway.serverId produces WARNING log
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1474">Issue 1474</a>
ClassCastException in AndroidScanner
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1475"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1499">Issue 1499</a>
Sqlite locks when attempting a migration result in SQLException: [SQLITE_BUSY]
</li>
</ul>
<p>
Thanks to Benoit Devos, Michael Prankl and Taufiq Hoven for reporting these issues and contributing fixes.
</p>
<h2 id="4.0.3">Flyway 4.0.3 (2016-06-17)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1313">Issue 1313</a>
Flyway 4.0.1 Repeatable migrations running before versioned.
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1339">Issue 1339</a>
SQLite blob literal parsing support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1339"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1341">Issue 1341</a>
SQLite system table no drop
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1341"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
</ul>
<p>
Thanks to aaltergot and hartrc for reporting these issues and contributing fixes.
</p>
<h2 id="4.0.2">Flyway 4.0.2 (2016-06-09)</h2>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1319">Issue 1319</a>
Update MariaDB driver to latest version
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1211">Issue 1211</a>
PostgreSQL upper case schema names end up double quoted
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1307">Issue 1307</a>
Removed drop table because of issues with partitioned tables
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1307"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1309">Issue 1309</a>
Maven plugin : warning about flyway.configFile
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1326">Issue 1326</a>
SqlScriptFlywayCallback errors in ALL_CALLBACKS list
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1327">Issue 1327</a>
Option to Suppress "SQLServer does not support setting the schema..." messages
</li>
</ul>
<h3>Documentation fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1312">Issue 1312</a>
Clarify validate javadoc
</li>
</ul>
<p>
Thanks to Dennis Hoer, frbo42, Gili Tzabari, hartrc, John McCall, lrozenblyum, smohara and Sten Røkke
for reporting these issues and contributing fixes.
</p>
<h2>Flyway 4.0.1 (2016-05-06)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1120">Issue 1120</a>
Db2 z/OS 3.x->4.0 migration, storage group setting, moved tests
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1237"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1216">Issue 1216</a>
Parsing of string literals
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1220">Issue 1220</a>
Sybase support does not work with Sybase ASE 15.7
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1221"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1222">Issue 1222</a>
Regression with MySQL delimiter in Flyway 3.2
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1226">Issue 1226</a>
Postgres clean drop all types
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1226"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1227">Issue 1227</a>
Resources not found from bundles without wiring to org.osgi.framework
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1228"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1231">Issue 1231</a>
Upgrading AWS Redshift DB from Flyway 3.2.1 to 4.0 failed - couldn't upgrade metadata table
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1256"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1233">Issue 1233</a>
Allow commandline client to specify placeholderReplacement
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1233"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1235">Issue 1235</a>
Flyway upgrade from 3.2.1 to 4.0 fails with Oracle error ORA-00955: name is already used by an existing object
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1290"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1238">Issue 1238</a>
Dollar-quoted PostgreSQL function definitions are parsed incorrectly in some situations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1245">Issue 1245</a>
Flyway 4.0 config Postgres requires user/pass
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1249">Issue 1249</a>
MigrationInfoImpl violates the compareTo contract
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1255">Issue 1255</a>
Issue with create schema_version for Sybase ASE
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1264">Issue 1264</a>
Regression in multiline comments/quotes handling
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1265">Issue 1265</a>
Upgrade metadata table to v4.0 fails on Derby
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1269"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1270">Issue 1270</a>
Vertica does not support repeatable migrations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1280">Issue 1280</a>
beforeEachMigrate callback can't change search_path anymore
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1292">Issue 1292</a>
Clean does not delete procedures on case sensitive SQLServer
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1297"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1293">Issue 1293</a>
Flyway cannot create schema table on Galera cluster (MariaDB)
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1294"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1296">Issue 1296</a>
Order in which callbacks are executed
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1298">Issue 1298</a>
Warning about flyway.current property
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1299">Issue 1299</a>
Using MySQL Connector/J 6.x warns about JDBC driver class name
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1300">Issue 1300</a>
Fail if user is set in Flyway config, but password is only present in settings.xml
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1301">Issue 1301</a>
Fix IBM classloader regression
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1301"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1302">Issue 1302</a>
NullPointerException migrating to "current" on empty DB
</li>
</ul>
<h3>Documentation fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flywaydb.org/issues/62">Issue 62</a>
Fix jre setup documentation
</li>
<li>
<a href="https://github.com/flyway/flywaydb.org/pull/65">Issue 65</a>
Rewrite Android documentation to fit Android Studio/Gradle and SQLDroid better
<span class="label label-info"><a href="https://github.com/flyway/flywaydb.org/pull/65"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flywaydb.org/pull/66">Issue 66</a>
fix sbt version
<span class="label label-info"><a href="https://github.com/flyway/flywaydb.org/pull/66"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flywaydb.org/pull/68">Issue 68</a>
Remove flywaySettings from sample configurations
<span class="label label-info"><a href="https://github.com/flyway/flywaydb.org/pull/68"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flywaydb.org/pull/70">Issue 70</a>
Fix of lost tag `pre` around sample configuration
<span class="label label-info"><a href="https://github.com/flyway/flywaydb.org/pull/70"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1275">Issue 1275</a>
Document SBT custom configuration usage
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1277">Issue 1277</a>
The fact that repeatable migrations are applied after versioned migrations should be documented explicitly
</li>
</ul>
<p>
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.
</p>
<h2>Flyway 4.0 (2016-02-29)</h2>
<p>This version comes with a <strong>new metadata table format</strong>. Migration is transparent and automatic on first
run of any Flyway command. This new format is not compatible with older Flyway versions.</p>
<p><strong>Note:</strong> DB 2 z/OS, Vertica, and solidDB users may have to manually upgrade the metadata table or drop it and baseline the schema again.</p>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/102">Issue 102</a>
Sybase ASE support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/880"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/128">Issue 128</a>
Repeatable Migrations support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/458">Issue 458</a>
Allow disabling clean
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/724">Issue 724</a>
Prompt for userId and password in commandline mode
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/805">Issue 805</a>
JdbcMigrations and new FlywayCallback should have access to core configuration
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/811"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/929">Issue 929</a>
Apache Phoenix Support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1012"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/935">Issue 935</a>
SAP HANA support <span class="label label-success"><a href="/support/#sponsor">€
Sponsored</a></span> by <a href="http://www.softronic.cz/">Softronic</a>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/985">Issue 985</a>
Log the update count with DEBUG priority after running a SQL script
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/985"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1047">Issue 1047</a>
Using both custom and SQL callbacks
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1078">Issue 1078</a>
Allow default migration resolvers to be overriden
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1191"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1117">Issue 1117</a>
Transparently upgrade metadata table from 3.x to 4.x format
</li>
<li>
<a href="https://github.com/flyway/flyway/issue/1058">Issue 1119</a>
Redshift-specific JDBC driver support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1119"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1114">Issue 1114</a>
Command-line tool: Add -v to print version and exit
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1188">Issue 1188</a>
Datasource auto-configuration when running in a Boxfuse instance
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1198">Issue 1198</a>
Included abstract base classes for resolvers and migrations
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1198"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/477">Issue 477</a>
When a location is not found a warning is now emitted instead of an exception
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/724">Issue 724</a>
When using the command-line tool with no database user or password, you must now pass in an empty value to avoid being prompted
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/767">Issue 767</a>
mvn flyway:clean is now executed in the clean phase by default
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/891">Issue 891</a>
The Flyway SBT plugin now requires SBT 0.13.7
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/935">Issue 935</a>
Command-line: error messages are now sent to stderr instead of stdout
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/935"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/979">Issue 979</a>
The default location for the Flyway Maven, Gradle and SBT plugins is now <code>filesystem:src/main/resources/db/migration</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/989">Issue 989</a>
To ignore failed future migrations, you must now also set <code>ignoreFutureMigrations</code> to <code>false</code>.
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1116">Issue 1116</a>
Removed all deprecated API from Flyway 3.x
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/977">Issue 977</a>
Flyway now warns on invalid command-line options
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1152">Issue 1152</a>
Upgrade Command-line tool bundled JRE to 8u74
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1214">Issue 1214</a>
Upgrade Command-line tool bundled JDBC drivers to latest versions
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/178">Issue 178</a>
Support for reference-partitioned tables (Oracle 11g)
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1006"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/253">Issue 253</a>
Ignore line endings when calculating checksums
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/669">Issue 669</a>
Ignore sqlplus set define off command
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/737">Issue 737</a>
search_path is not restored after migration
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/763">Issue 763</a>
sbt tasks do not use scope specific settings
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/891"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/788">Issue 788</a>
Provide default implementation for FlywayCallback
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/905">Issue 905</a>
NullPointerException at org.flywaydb.maven.MigrateMojo.doExecute(MigrateMojo.java:35)
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/917">Issue 917</a>
After running flywayMigrate in SBT there is no straightforward way to know current db version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/983">Issue 983</a>
Redshift COPY not working
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/988">Issue 988</a>
Fail validate if an already applied migration couldn't be found
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/995">Issue 995</a>
Error setting current schema to "public"
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/999">Issue 999</a>
ClassCastException in PostgreSQLDbSupport.executePgCopy when using BasicDataSource
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1003"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1000">Issue 1000</a>
SQL exception in COPY statement when the DELIMITER is set to a semicolon
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1001">Issue 1001</a>
Gradle plugin can not set placeholderReplacement property
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1023">Issue 1023</a>
Flyway should not expect "org/flywaydb/core/internal/version.txt" to be on the custom classpath
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1025">Issue 1025</a>
afterEachMigrate fails, migration succeeds, but migration not written to schema_version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1033">Issue 1033</a>
Missing Import-package MANIFEST.MF headers for postgresql
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1036">Issue 1036</a>
ORA-00911: invalid character
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1042">Issue 1042</a>
Single connection in DriverDataSource can never be closed
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1043">Issue 1043</a>
Migration with Flyway.setPlaceholderReplacement(false) fails with "org.flywaydb.core.api.FlywayException: No value provided for placeholder expressions"
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1049">Issue 1049</a>
ORA-32794 in Oracle 12c using identity columns
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1075">Issue 1075</a>
Support option to use Slf4j/Commons Logging/JUL when using the command line tool
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1077">Issue 1077</a>
Oracle JDBC issue on Linux - IO Error: Connection reset
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1080">Issue 1080</a>
ORA-00911: Invalid character on 'From'
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1097"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1081">Issue 1081</a>
Change of Delimiter does not work correct for SQLite
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1085">Issue 1085</a>
Clean on embedded derby database does not clean triggers
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1089">Issue 1089</a>
SQL cannot be parsed when using binary type "char (16) for bit data": X'0123'
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1090"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1093">Issue 1093</a>
ORA-01950 on schema baseline/init in Oracle 12.1
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1099">Issue 1099</a>
Flyway fails to connect with the database if the OS user name is longer than 30 characters
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1106">Issue 1106</a>
A tableName """t""" cause error on PostgreSQLSchema.doAllTables()
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1108">Issue 1108</a>
Flyway does not reset the current schema between migrations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1109">Issue 1109</a>
ORA-65040 error when trying to clean different schema with system user
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1111">Issue 1111</a>
Support for Vertica (or replace) Function
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1112"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1124">Issue 1124</a>
Fix flyway script on Git Bash for Windows
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1124"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1129">Issue 1129</a>
Fails to clean materialized view that has dependent view on postgres
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1136">Issue 1136</a>
Multi Line comments are not handled correctly
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1140"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1142">Issue 1142</a>
OsgiClassPathLocationScanner supports only current bundle
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1143"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1154">Issue 1154</a>
Drop functions with length attributes in DB2
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1155"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1164">Issue 1164</a>
Use nanoTime() for StopWatch
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1164"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1165">Issue 1165</a>
Sql file callbacks does not work with empty sqlMigrationPrefix
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1171">Issue 1171</a>
GAE uses different Driver: Unable to obtain Jdbc connection from DataSource
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1172"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1190">Issue 1190</a>
PostgreSQL: Filter functions and views from extensions during clean
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1190"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1193">Issue 1193</a>
Unable to clean schema that contain a Computed Column Defined with a User-Defined Function
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1196">Issue 1196</a>
PostgreSQL: trim schema name
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1197">Issue 1197</a>
Improved JavaDoc for callbacks, resolvers and migrations
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1197"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1217">Issue 1217</a>
Fixed flyway 4.0 upgrade for Redshift (it does not support alter column)
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1217"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
</ul>
<h3>Documentation fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flywaydb.org/pull/49">Issue 49</a>
Sentence was missing a word
<span class="label label-info"><a href="https://github.com/flyway/flywaydb.org/pull/49"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flywaydb.org/issues/53">Issue 53</a>
Minor wording change in documentation around Java class naming
<span class="label label-info"><a href="https://github.com/flyway/flywaydb.org/pull/54"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/607">Issue 607</a>
Doc enhancement: More features for the feature comparison matrix
</li>
</ul>
<p>
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.
</p>
<h2>Flyway 3.2.1 (2015-03-20)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/pull/969">Issue 969</a>
Fix SQL syntax error in MetaDataTableImpl.java
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/969"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/971">Issue 971</a>
Regression in 3.2: Invalid charater
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/973"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
</ul>
<p>
Thanks to avesse, David J. M. Karlsen and soemeier for reporting these issues and contributing fixes.
</p>
<h2>Flyway 3.2 (2015-03-16)</h2>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/732">Issue 732</a>
The command-line tool now optionally ships with a JRE
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/885">Issue 885</a>
SolidDB support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/886"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/906">Issue 906</a>
Option to validate only until current version of the schema
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/913"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/909">Issue 909</a>
The commandline tool now also ships with the Derby Client driver
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/915">Issue 915</a>
Command-line: -q switch for quiet mode
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/920"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/945">Issue 945</a>
Allow to skip placeholder resolution
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/956">Issue 956</a>
Try to load configFile from current directory first
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/752">Issue 752</a>
Deprecated <code>Flyway.setBaselineVersion(String)</code>, use <code>setBaselineVersionAsString(String)</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/752">Issue 752</a>
Deprecated <code>Flyway.setTarget(String)</code>, use <code>setTargetAsString(String)</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/752">Issue 752</a>
Deprecated <code>Flyway.setCallbacks(String...)</code>, use <code>setCallbacksAsClassNames(String...)</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/752">Issue 752</a>
Deprecated <code>Flyway.setResolvers(String...)</code>, use <code>setResolversAsClassNames(String...)</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/895">Issue 895</a>
Deprecated Gradle plugin ID <code>flyway</code>, use <code>org.flywaydb.flyway</code> instead.
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/946"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/966">Issue 966</a>
Commandline: Deprecated <code>jarDir</code>, use <code>jarDirs</code> instead.
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/598">Issue 598</a>
No "current" schema in flyway.url causes a Flyway exception
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/752">Issue 752</a>
Overloaded setters break Spring XML usage <span class="label label-success"><a href="/support/#sponsor">€
Sponsored</a></span> by <a href="https://twitter.com/davidharrigan">David Harrigan</a>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/892">Issue 892</a>
Using (deprecated) init goal in Maven takes wrong baseline version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/893">Issue 893</a>
Add command images to Javadoc
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/898">Issue 898</a>
Flyway baselines new schemas, since they always have a schema_version table
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/902">Issue 902</a>
slf4j optional package import missing from OSGi manifest
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/903">Issue 903</a>
Fix an error where MigrationVersion wouldn't parse correctly
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/903"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/905">Issue 905</a>
NullPointerException at org.flywaydb.maven.MigrateMojo.doExecute(MigrateMojo.java:35)
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/918">Issue 918</a>
Explicitly drop Views then doing a Flyway.clean() on a PostgreSQL db
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/921">Issue 921</a>
Incorrect parsing when space is missing between end quote and next token
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/922">Issue 922</a>
Escape command-line arguments
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/939">Issue 939</a>
Multiline comment closing not detected properly
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/940">Issue 940</a>
Implicit baseline triggered by baselineOnMigrate does not respect baselineVersion
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/951">Issue 951</a>
Still issues with the Gradle plugin under Java 6
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/955">Issue 955</a>
Loading configFile from relative path seems to be broken
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/957">Issue 957</a>
Improve DataSource not set error message for non-API clients
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/958">Issue 958</a>
Backslashes are not treated properly in conf file
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/965">Issue 965</a>
Problem with double quotes
</li>
</ul>
<h3>Documentation fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/959">Issue 959</a>
Gradle documentation should have commas to separate placeholders
</li>
</ul>
<p>
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.
</p>
<h2>Flyway 3.1 (2014-11-27)</h2>
<h3>New Features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/344">Issue 344</a>
HP Vertica support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/740"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/638">Issue 638</a>
DB2 on z/OS support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/713"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/661">Issue 661</a>
AWS Redshift support
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/743"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/728">Issue 728</a>
SQL-based callbacks
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/731">Issue 731</a>
Package JDBC drivers with command-line tool
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/778">Issue 778</a>
Maven plugin: Expose new DB version in <code>flyway.current</code> property
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/778"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/834">Issue 834</a>
Use Slf4j for logging if available
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/863">Issue 863</a>
PostgreSQL COPY ... FROM STDIN support <span class="label label-success"><a href="/support/#sponsor">€
Sponsored</a></span> by <a href="https://www.dg-i.net/">Dembach Goo Informatik</a>
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
The <code>FlywayCallback</code> interface has two new methods: <code>beforeBaseline()</code> and <code>afterBaseline()</code>.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
<code>info()</code> now returns INIT migrations as BASELINE.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
<code>info()</code> now returns PREINIT migrations as BELOW_BASELINE.
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>init()</code>, use <code>baseline()</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>initVersion</code>, use <code>baselineVersion</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>initDescription</code>, use <code>baselineDescription</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>initOnMigrate</code>, use <code>baselineOnMigrate</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>FlywayCallback.beforeInit()</code>, use <code>FlywayCallback.beforeBaseline()</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>FlywayCallback.afterInit()</code>, use <code>FlywayCallback.afterBaseline()</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>MigrationState.PREINIT</code>, use <code>MigrationState.BELOW_BASELINE</code> instead.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/860">Issue 860</a>
Deprecated <code>MigrationType.INIT</code>, use <code>MigrationType.BASELINE</code> instead.
</li>
<li>Derby Jdbc driver: Flyway is now tested with 10.11.1.1 (was 10.8.2.2)</li>
<li>Hsql Jdbc driver: Flyway is now tested with 2.3.2 (was 2.2.8)</li>
<li>PostgreSQL Jdbc driver: Flyway is now tested with 9.3-1102-jdbc4 (was 9.0-801.jdbc4)</li>
<li>SQLite Jdbc driver: Flyway is now tested with sqlite-jdbc 3.7.15-M1 (was sqlite-jdbc 3.7.2)</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/691">Issue 691</a>
Clean fix #664 breaks DB2 clean in some cases
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/718">Issue 718</a>
SQLServer: no exception thrown when statement fails
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/780"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/735">Issue 735</a>
cygwin classpath problem
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/736"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/742">Issue 742</a>
flyway info does cuts off or truncates information
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/746">Issue 746</a>
Unhelpful error when forgetting "flyway.driver" with xerial sqlite-jdbc
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/754">Issue 754</a>
flyway fails to remove forward slash from a script if it contains a comment
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/758"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/758">Issue 758</a>
Fixed OSGi metadata table create script loading
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/765"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/761">Issue 761</a>
Clean Oracle scheduled jobs
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/799"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/770">Issue 770</a>
Improve Oracle error - show the ORA code
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/774">Issue 774</a>
Informational message from database logged at WARN level
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/872"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/779">Issue 779</a>
Restore JDK6 compatibility for Gradle plugin
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/836"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/783">Issue 783</a>
Spring Jdbc not available from command line
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/793">Issue 793</a>
MySQL flywayMigrate fails due to user permission
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/800">Issue 800</a>
Handle Oracle java source
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/800"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/801">Issue 801</a>
ClassPathScanner fails with enum
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/802">Issue 802</a>
Clean on DB2 does not clean triggers
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/803"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/806">Issue 806</a>
Flyway does not clean sequences on SQL Server 2012
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/816">Issue 816</a>
Allow newer migrations to exist and be skipped by validateOnMigrate
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/824">Issue 824</a>
Classpath scanner does not detect sql-files in WEB-INF/classes in (non-exploded) war-file
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/825">Issue 825</a>
Warn instead of fail when clean cannot find a schema
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/830">Issue 830</a>
Allow gradle plugin to create multiple migrate tasks for different schemas
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/831"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/842">Issue 842</a>
migrate [initOnMigrate, initVersion] should use initVersion when the schema does not exist
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/843">Issue 843</a>
Flyway suppresses warnings silently on SQLException
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/866">Issue 866</a>
Classpath Scanner swallows Instantiation Exceptions
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/867">Issue 867</a>
DB2 schema clean fails for expression-based index
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/868">Issue 868</a>
Update filed for MSSQL scripts containing 'Go'
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/871">Issue 871</a>
Please include SQLException message when failing to connect
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/877">Issue 877</a>
Exception cause lost in classutils instantiateAll
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/884">Issue 884</a>
Flyway incorrectly handles paths with a + in their name
</li>
</ul>
<p>
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.
</p>
</div>
<div class="release">
<h2 id="flyway-3.0">Flyway 3.0 (2014-04-20)</h2>
<h3>New Features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/76">Issue 76</a>
SQLite & Android support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/353">Issue 353</a>
Command-line tool: Multiple operations can now be specified at once
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/469">Issue 469</a>
Custom MigrationResolver support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/618">Issue 618</a>
Repair: update checksums after migration
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/626">Issue 626</a>
Custom ClassLoader support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/651">Issue 651</a>
Pre and post hooks for each operation <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/709"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/655">Issue 655</a>
Disable transaction for a particular migration
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/667">Issue 667</a>
MariaDB support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/679">Issue 679</a>
Allow to configure maven plugin from a property file
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/730">Issue 730</a>
Configurable separator between version and description
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>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.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/97">Issue 97</a>
Validate should fail if there are migrations in source that have not been run on the database
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/536">Issue 536</a>
Drop Java 5 support & remove deprecated API
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/537">Issue 537</a>
Move packages & groupId from <strong>
<del>com.googlecode.flyway</del>
</strong> to <strong>org.flywaydb</strong>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/695">Issue 695</a>
<code>validateOnMigrate</code> is now true by default
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>DB2 Jdbc driver: Flyway is now tested with db2jcc4 4.17.29 (was db2jcc 3.62.56)</li>
<li>Oracle Jdbc driver: Flyway is now tested with OJDBC6 12.1.0.1 (was OJDBC5 11.2.0.2.0)</li>
<li>PostgreSQL Jdbc driver: Flyway is now tested with 9.0-801.jdbc4 (was 9.0-801.jdbc3)</li>
<li>SQL Server Jdbc driver: Flyway is now tested with Jtds 1.3.1 (was 1.2.7)</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/430">Issue 430</a>
Display the connection url
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/484">Issue 484</a>
IllegalArgument when executing Flyway Ant build script several times in the same JVM
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/489">Issue 489</a>
Validate does not report different descriptions for same version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/496">Issue 496</a>
Need sql print statements to be logged in Flyway logs
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/540">Issue 540</a>
ORA-00900: invalid SQL statement - bug in the parser
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/543">Issue 543</a>
Parser does not properly recognize some multiline string literals
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/557">Issue 557</a>
MySQL statement not recognized due to a space character at the end of a comment directive
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/584">Issue 584</a>
NumberFormatException thrown when using command line tools
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/606">Issue 606</a>
Found more than one migration with version when multiple locations named with the same roots
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/612">Issue 612</a>
Inconsistent definition of "locations" parameter
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/621">Issue 621</a>
flyway clean does not remove mysql events
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/639">Issue 639</a>
Flyway migrates correctly. but in the schema_version table the scriptname is prefixed with a /
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/642">Issue 642</a>
Local migration file overwrites database's description
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/673">Issue 673</a>
Some Unicode characters can still lead to StringIndexOutOfBoundsException <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/674"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/678">Issue 678</a>
flyway fails recognizing sql server delimiter while parsing sql migration
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/681">Issue 681</a>
Maven site complains that repository url 'http://flywaydb.org/repo' is invalid
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/682">Issue 682</a>
Maven Plugin - Cannot set boolean system property <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/683"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/684">Issue 684</a>
Allow passing custom initialization SQL for database connections <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/685"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/687">Issue 687</a>
Oracle cleanup - flyway fails on tables that have Flashback enabled <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/689"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/688">Issue 688</a>
Support for Oracle cluster <span class="label label-info"><a href="https://github.com/flyway/flyway/pull/688"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/692">Issue 692</a>
Flyway doesn't remove trailing slash in PL/SQL block
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/694">Issue 694</a>
sbt: Allow specifying URL through system properties <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/700"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/697">Issue 697</a>
flyway:clean doesn't remove compiled java source <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/698"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/706">Issue 706</a>
Info marks schema creation as missing (should be success)
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/708">Issue 708</a>
flyway.repair() doesn't commit when data source is not autocommit
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/716">Issue 716</a>
Load and inject configured Custom MigrationResolver implementations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/720">Issue 720</a>
FlywayException message is not saying anything usefull <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/721"><i class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/725">Issue 725</a>
NullPointerException in quoteReplacement
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/727">Issue 727</a>
fix placeholders override by property configuration and add sbt large test for placeholders
</li>
</ul>
<p>
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.
</p>
</div>
<div class="release">
<h2>Flyway 2.3 (2013-12-17)</h2>
<h3>New Features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/85">Issue 85</a>
SBT Plugin <span class="label label-info"><a href="https://github.com/flyway/flyway/pull/662"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/562">Issue 562</a>
Cygwin support <span class="label label-info"><a href="https://github.com/flyway/flyway/pull/616"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Flyway is now tested with Ant 1.8.4 (was 1.8.2)</li>
<li>Deprecated the <code>MigrationVersion()</code> constructor. Use
<code>MigrationVersion.fromVersion(String)</code> instead.
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/456">Issue 456</a>
MySQL CharSet cast support <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/605"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/480">Issue 480</a>
MySQL SQL Parsing Error <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/613"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/575">Issue 575</a>
Output failed statement <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/649"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/576">Issue 576</a>
flyway:migrate complains about missing URL even when execution should be skipped
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/585">Issue 585</a>
Maven Plugin not overriding properties with System Properties
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/589">Issue 589</a>
flyway:clean doesnt remove check constraint <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/605"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/593">Issue 593</a>
Parse error with mysql string literal that ends in b' or x' <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/600"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/594">Issue 594</a>
Parse error with mysql string literal that ends in an escaped backslash <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/599"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/598">Issue 598</a>
No "current" schema in flyway.url causes a Flyway exception <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/609"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/604">Issue 604</a>
[oracle] flyway:clean doesn't handle DDL triggers very well
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/611">Issue 611</a>
MySQL : Parse error with a very simple script and mixed simple / double quotes <span
class="label label-info"><a href="https://github.com/flyway/flyway/pull/613"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/625">Issue 625</a>
change or indicate in doc where flyway.locations filesystem in looking from ant task
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/640">Issue 640</a>
MySQL multi-line comment directives not recognised <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/641"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/656">Issue 656</a>
Support Oracles multibyte datatype statements
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/663">Issue 663</a>
Clean doesn't handle temporal/versioned tables correctly in DB2 <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/664"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
</ul>
<p>
Thanks to Adam Green, Baptiste Gaillard, Christian Dedié, Christoffer Eide, Dave O'Flynn, garichner, Kevin
Sheedy,
Lukasz Rozek, Matt Garner, migore, pimlottc, Pavel Boldyrev, Piotr Wielgolaski,
Rajnish Srivastava, Robert Handschmann, Thomas Queste, Tom Eicher and Ulf Bamberg
for reporting these issues and providing fixes.
</p>
</div>
<div class="release">
<h2>Flyway 2.2.1 (2013-08-20)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/555">Issue 555</a>
True exception causes lost when there is no cause chain
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/559">Issue 559</a>
NullPointerException on database without default schema
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/563">Issue 563</a>
MigrationVersion compareTo is very slow <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/564"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/570">Issue 570</a>
Flyway failing with single quote as part of MySQL Stored Procedure Create Statement
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/571">Issue 571</a>
Plugin fails with Maven 3.1 - An API incompatibility was encountered during configuration of mojo
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/572">Issue 572</a>
NumberFormatException with file names like V1..1__desc.sql <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/573"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/574">Issue 574</a>
Passing in target property causes GroovyCastExtention <span class="label label-info"><a
href="https://github.com/flyway/flyway/pull/581"><i class="fa fa-mail-reply"></i> Pull
Request</a></span>
</li>
</ul>
<p>
Thanks to Chrissyx, Dario Matonicki, hvvikram, Michael Krotscheck, Piotr Wielgolaski, Thomas Jung and Tom
Stordy-Allison
for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2>Flyway 2.2 (2013-07-15)</h2>
<h3>New Features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/78">Issue 78</a>
Gradle Plugin
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/182">Issue 182</a>
SQL Azure support
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>Flyway now throws an exception if a placeholder is missing a replacement value</li>
<li><code>init</code> is now idempotent. Calling <code>init</code> multiple times with the same values no longer
throws an exception.
</li>
<li><strong>Ant:</strong> Dropped support for the separate Spring distribution.<br/>Spring is still supported by
adding the
Spring jars yourself on Flyway's classpath
</li>
<li><strong>Ant:</strong> The distribution is now called <code>flyway-ant-2.2.[zip|tar.gz]</code> (dropped the
-dist part)
</li>
<li><strong>Command-line:</strong> Dropped support for the Spring distribution.<br/>Spring is still supported by
adding the
Spring jars yourself in the /jars directory
</li>
<li><strong>Command-line:</strong> The distribution is now called
<code>flyway-commandline-2.2.[zip|tar.gz]</code> (dropped the -dist part)
</li>
<li><strong>Command-line:</strong> The root directory is now called flyway-2.2 (dropped the -commandline part)
</li>
<li><strong>Command-line:</strong> On Linux and OSX the script is now called <code>flyway</code> (dropped the
.sh)
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Flyway is now tested with the Microsoft JDBC Driver 4.0.2206.100 (was 3.0.1301.101)</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
Small Bug in Flyway.getLocations() -> flyway-test-extension crash
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=453">Issue 453</a>
flyway.cmd cannot determine console width on windows 7
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=456">Issue 456</a>
"Migrate" command fails when the SQL Server login doesn't have a default schema
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=458">Issue 458</a>
FlywayException executing flyway:info with -f maven option
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=459">Issue 459</a>
Flyway.migrate() leaves the metadata table locked if it throws an exception
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=462">Issue 462</a>
Flyway 2.1.1 hangs on ANALYZE command <span class="label label-success"><a href="/support/#sponsor">€
Sponsored</a></span>
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=463">Issue 463</a>
Clean on DB2 functions or procedures fails when two procedures have the same name
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=464">Issue 464</a>
Clean on DB2 fails to clean schemas with ARRAY TYPES
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=471">Issue 471</a>
Dropping queue tables throws Exception
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=472">Issue 472</a>
SQL Server Unable to drop schema when functions exist
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=473">Issue 473</a>
SQL Server: flyway:clean should drop synonyms
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=474">Issue 474</a>
MySql - Cannot create table or query data from tables in migration steps because meta data table is locked
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=477">Issue 477</a>
Fail fast for missing placeholders
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=481">Issue 481</a>
Hexadecimal Value using x'1234' notation not parsed correctly
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=491">Issue 491</a>
Oracle COMPOUND TRIGGER with initialization section not working properly
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=497">Issue 497</a>
MySQLSqlStatementBuilder gets confused with lines containing escaped single quote
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=499">Issue 499</a>
MySQL dump file's Views are not migrated
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/501">Issue 501</a>
Flyway Clean on PostgreSQL leaves TYPES
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/505">Issue 505</a>
Ant Tasks "validate" and "migrate" do not show actual and expected checksums
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/542">Issue 542</a>
zero-length delimited identifier at or near """" on Postgres
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/548">Issue 548</a>
Need a way to find out from FlywayException which SQL command failed
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/23">Pull Request 23</a>
Consider colons as a token separator
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/25">Pull Request 25</a>
Version in child projects is redundant, since it is inherited from the parent
</li>
</ul>
<p>
Thanks to Alex Zuroff, Brian Hartin, Christian Holzer, David Bellem, Florian Eska, Geoff, Giovanni Toraldo,
Jason Januzelli, Jens Berke,
Leandro de Oliveira, Mark Garrison, Michael Hirsch,
Nayan Hajratwala, Patrick Malouin, Pavel Boldyrev, Pekka Mannisto, Radek Mensik, Roger Brechbühl, Ryan Williams,
service (figel.it) and Tim Andersen
for reporting these issues and contributing fixes.
</p>
<p>Special thanks to David Harrigan for <a href="/support/#sponsor">sponsoring the fix</a> for issue 462!
</p>
<p>Special thanks to Ben Manes for contributing the Gradle Plugin!</p>
</div>
<div class="release">
<h2>Flyway 2.1.1 (2013-03-15)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=443">Issue 443</a>
Property flyway.consoleWidth should be optional in 2.1 command line
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=444">Issue 444</a>
Add -X option to command line tool help
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=445">Issue 445</a>
T-SQL Unicode string syntax broken in 2.1
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=449">Issue 449</a>
Maven plugin raises NPE when url configuration is missing
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=450">Issue 450</a>
MySQL - schema_version table remains LOCKed after Flyway runs
</li>
</ul>
<p>
Thanks to Alex Krauss, Alex Panchenko, Alex Zuroff and Greg Case for reporting and contributing fixes for
these issues.
</p>
</div>
<div class="release">
<h2>Flyway 2.1 (2013-03-05)</h2>
<p>This version <strong>fixes minor issues with the metadata table</strong>. Migration is transparent and automatic
on first
run.</p>
<h3>New Features</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=74">Issue 74</a>
Automatic schema creation
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=219">Issue 219</a>
Allow 'skip' in Maven Plugin
</li>
<li>
Maven Plugin: Support encrypted passwords in settings.xml
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=223">Issue 223</a>
Command-line: Customizible location of jars folder
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=247">Issue 247</a>
Allow loading SQL migrations from Filesystem (instead of only from classpath)
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=277">Issue 277</a>
Command-line: Allow to load sql-migrations from different directory
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=324">Issue 324</a>
<code>flyway.driver</code> is now optional. It is auto-detected based on <code>flyway.url</code> when
omitted
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>The deprecated <code>flyway.baseDir</code> property has been removed.</li>
<li>The deprecated <code>flyway.basePackage</code> property has been removed.</li>
<li>The default for <code>flyway.initVersion</code> has been changed to 1 (was 0).</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=340">Issue 340</a>
Invalid locations now result in an exception being thrown instead of being silently ignored.
</li>
<li>Command-line: The default for <code>flyway.locations</code> has been changed to <code>filesystem:<<INSTALL-DIR>>/sql</code>
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Deprecated <code>
<del>flyway.initialVersion</del>
</code>. Use <code>flyway.initVersion</code> instead.
</li>
<li>Deprecated <code>
<del>flyway.initialDescription</del>
</code>. Use <code>flyway.initDescription</code> instead.
</li>
<li>Flyway now enforces the <a href="/documentation/migration/#versions">rules for what constitutes a
valid
version</a>.
</li>
<li>SqlServer: Flyway is now tested with Jtds 1.2.7 (was 1.2.4).</li>
<li>H2: Flyway is now tested with H2 1.3.170 (still compatible with 1.2.137 and above).</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=244">Issue 244</a>
Flyway can now also be built with JDK 7 and above. (Minimum is still JDK 6)
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=351">Issue 351</a>
better log messages of DBMigrator
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=377">Issue 377</a>
db/migration-test not recognized as location
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=381">Issue 381</a>
setLocations does not override deprecated baseDir or basePackage
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=383">Issue 383</a>
Support longer usernames
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=384">Issue 384</a>
Special umlauts create IndexOutOfBoundsExceptions
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=387">Issue 387</a>
schema_version table could have a primary key
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=394">Issue 394</a>
HSQLDB : Quote in comment breaks parser
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=404">Issue 404</a>
Bash script compatibility
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=407">Issue 407</a>
OSGi: Add support for felix framework
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=413">Issue 413</a>
Uninstantiatable JdbcMigration tests should throw exception
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=415">Issue 415</a>
Support of db2 stored procedures
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=423">Issue 423</a>
Classpath issue with EAR and Websphere
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=426">Issue 426</a>
Current version of schema is always 0
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=427">Issue 427</a>
Support for anonymous blocks in postgresql
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=428">Issue 428</a>
Unclosed string literals in comments break statement parsing
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=430">Issue 430</a>
H2 breaks when DATABASE_TO_UPPER=FALSE
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=432">Issue 432</a>
Maven Plugin does not scan the test classpath for sql files
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=436">Issue 436</a>
Description field isn't long enough
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=439">Issue 439</a>
mysql cluster synchronize fail
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/9">Pull Request 9</a>
Command-line Unix: Resolve symlinks in flyway.sh
</li>
</ul>
<p>
Thanks to agattiker, Benoit Cantin, Christian Haelg, Constantine Linnick, Daniel Wilmer,
Dmitry Bitman, dyou08, Gerd Behrmann, Gerrit Brehmer,
Giorgio Gallo, Herve Martin, István Nagy, Joe McCall, Jonathan Tougas, Judith Aigner, Kamil Szymański,
Klas Klassen, Marcin Jancewicz, Marcin Z., Martin Baillie, Michael Meyer,
rbrueske, Tero Keski-Valkama, Tom Stordy-Allison, Tomek Kaczanowski and Viktoras Makauskas
for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2>Flyway 2.0.3 (2012-12-05)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=372">Issue 372</a>
Schemas property bug in AbstractFlywayMojo
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=374">Issue 374</a>
OracleDbSupport assumes XML DB installed
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=375">Issue 375</a>
Flyway is extremely slow on MySQL with a lot of schemas
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=379">Issue 379</a>
maven flyway:migrate initOnMigrate and initVersion
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=380">Issue 380</a>
First character of migration script name is removed in schema_version.
</li>
</ul>
<p>
Thanks to David Gundersen, Don (dyou08), Mark Allen, turbohappy and Viktoras Makauskas
for reporting these issues.
</p>
</div>
<div class="release">
<h2>Flyway 2.0.2 (2012-11-22)</h2>
<p>This version performs <strong>minor fixes on the metadata table</strong>. Migration is transparent and automatic
on first
run.</p>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=362">Issue 362</a>
NPE when using "Serve modules without publishing"
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=367">Issue 367</a>
Migrations fail with escaped single quote characters from mysqldump
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=368">Issue 368</a>
flyway2.0.1 #setOutOfOrder() fails due to constraint violations
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=369">Issue 369</a>
Broken link in documentation
</li>
</ul>
<p>
Thanks to Leandro de Oliveira, Nelson Loyola, NoSuchLuke and Oliver Heil
for reporting these issues.
</p>
</div>
<div class="release">
<h2>Flyway 2.0.1 (2012-11-20)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=358">Issue 358</a>
Flyway 2.0 can break validation of applied PostgreSQL migrations because it removes "public" from the search
path
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=360">Issue 360</a>
Command-line: OutOfOrder property doesn't get applied
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=361">Issue 361</a>
flyway:clean does not work with Oracle XML DB and XMLIndex
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=364">Issue 364</a>
Wrong DDL upgradeTo20FormatPart1.sql for Oracle
</li>
</ul>
<p>
Thanks to Jens Berke, Nikos Sikalias, Sebastian (movio.co) and Sten Røkke
for reporting these issues.
</p>
</div>
<div class="release">
<h2>Flyway 2.0 (2012-11-14)</h2>
<p>This version comes with a <strong>new metadata table format</strong>. Migration is transparent and automatic on first
run.</p>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=99">Issue 99</a> New
<code>Flyway.repair()</code> call for repairing the metadata table after a failed migration on a database
without DDL
transaction support.
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=105">Issue 105</a>
<code>initOnMigrate</code> flag to automatically initialize a non-empty schema to initVersion.
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=138">Issue 138</a>
<code>outOfOrder</code> flag for applying migrations with older version numbers that haven't been applied yet
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=248">Issue 248</a> New
<code>Flyway.info()</code> call for info about both applied and pending migrations and current status of the
DB.
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>Migrations now always require a description.</li>
<li>The name of the schemas specified with <code>schemas</code> are now case-sensitive.</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=273">Issue 273</a> When <code>schemas</code> is
set, the first schema in the list is now automatically set as the default one.
</li>
<li>Core: <code>
<del>Version</del>
</code> has been renamed to <code>MigrationVersion</code> for consistency.
</li>
<li>Core: <code>Flyway.getInitVersion()</code> now returns an instance of <code>MigrationVersion</code> (was
<code>SchemaVersion</code>).
</li>
<li>Core: <code>Flyway.getTarget()</code> now returns an instance of <code>MigrationVersion</code> (was <code>SchemaVersion</code>).
</li>
<li>Core: <code>MigrationInfoProvider.getVersion()</code> now returns an
instance of
<code>MigrationVersion</code>.
</li>
<li>Maven: <code>schemas</code> is now a nested configuration element instead of a simply configuration property
</li>
</ul>
<h3>Changes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=290">Issue 290</a> Commons-Logging
Dependency is now optional.
</li>
<li>Deprecated <code>
<del>Flyway.status()</del>
</code>. Use <code>Flyway.info()</code> instead.
</li>
<li>Deprecated <code>
<del>Flyway.history()</del>
</code>. Use <code>Flyway.info()</code> instead.
</li>
<li>Deprecated <code>
<del>validationMode</del>
</code>. Use <code>validateOnMigrate</code> instead.
</li>
<li>Deprecated <code>
<del>validationErrorMode</del>
</code>. Use <code>cleanOnValidationError</code> instead.
</li>
<li>Deprecated <code>
<del>disableInitCheck</del>
</code>. Use <code>initOnMigrate</code> instead.
</li>
<li>Core: Deprecated <code>
<del>com.googlecode.flyway.core.exception.FlywayException</del>
</code>. Use
<code>com.googlecode.flyway.core.api.FlywayException</code> instead.
</li>
<li>Core: Deprecated <code>
<del>Flyway.setinitVersion(SchemaVersion)</del>
</code>. Use
<code>Flyway.setinitVersion(MigrationVersion)</code> instead.
</li>
<li>Core: Deprecated <code>
<del>Flyway.setTarget(SchemaVersion)</del>
</code>. Use
<code>Flyway.setTarget(MigrationVersion)</code> instead.
</li>
<li>Command-line: Distribution without Spring no longer contains logging jars</li>
<li>Ant: Distribution without Spring no longer contains logging jars</li>
<li>HsqlDb: Flyway is now tested against HsqlDb 2.2.6 (was 1.8.0.10). Still compatible with HsqlDb 1.8.</li>
<li>HsqlDb: Concurrent migration support for HsqlDb 2.0 and newer.</li>
<li>Oracle: To be compatible with SqlPlus, Flyway now always expects /
to terminate a create type statement.
</li>
<li>DB2: Flyway is now tested against 9.7.0.7 (was 9.7.0.2). Fix Pack 7 fixes important issues related to
calling REORG from JDBC.
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=145">Issue 145</a>
SQL Scripts with wrong description separator fail due to DB constraints
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=183">Issue 183</a>
Calculation of checksum is platform encoding dependent.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=199">Issue 199</a> Trimming of
whitespaces in SQL migrations breaks stored procedures formatting.
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=218">Issue 218</a>
createMetaDataTable.sql doesn't escape schema, table and field names
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=228">Issue 228</a> Oracle - SQL
hints
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=231">Issue 231</a> Oracle Sql
Parser: support comments inside package body
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=240">Issue 240</a> Empty lines are
stripped from multi-line string inserts
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=276">Issue 276</a>
Older DB2 versions limit the length of constraint names causing schema_version creation to fail
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=285">Issue 285</a>
OracleSqlScript does not support delimiter for TYPE(s) in
1.6.1
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=287">Issue 287</a> JNLP classloader not supported
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=293">Issue 293</a> 1.7 issues
warnings about deprecated baseDir and basePackage even if they are not defined
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=296">Issue 296</a> "unexpected
end of statement" in flyway 1.7 when creating multi-statement TRIGGER in HSQL
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=298">Issue 298</a> Java migrations:
ignore abstract classes
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=300">Issue 300</a> flyway:clean
doesn't remove Schema-level triggers on Oracle
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=303">Issue 303</a>
dropping aggregate function fails with clean
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=304">Issue 304</a>
SQL migration with multiline INSERT takes too long
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=305">Issue 305</a>
SqlScript parser misses */ closing comment if line starts with --
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=307">Issue 307</a>
CommandLine 1.7 --- More than one migration with same version
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=309">Issue 309</a>
SQL script multiple comments issue
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=310">Issue 310</a>
Having Delimiter keyword within block comment
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=313">Issue 313</a>
Flyway breaks on quotes inside comments
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=315">Issue 315</a>
Oracle clean schema fails to drop SYS_IOT_OVER tables
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=341">Issue 341</a>
NTLM Authentication
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=348">Issue 348</a>
ORA-00933 in case of schema name containing a dot symbol
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=355">Issue 355</a>
Flyway clean fails with Oracle nested tables
</li>
<li>
<a href="http://code.google.com/p/flyway/issues/detail?id=356">Issue 356</a>
Cannot create multi-statement triggers on DB2
</li>
<li>Added JBoss VFS v2 support to enable deployment inside JBoss 5.</li>
</ul>
<p>
Thanks to Adam Peresztegi, Adriano Machado, alehby, Alix Warnke, Anssi Huusko, Brian Troutwine, Cornelius
Buschka, Daniel Kan, Darragh O'Toole, Dmitry Bedrin, donald87, Emmanuel Potvin, Geir Nerboe, Gilman Tolle,
Greg Bujak, Haam Tham, Jochen Munz, Klaus Etkar, Kris Mulica, kwbrockhoff, Luc Degraef, Patrick van Dissel,
saran600101, Stefan Röck, Stephen Friedrich, Steve Tarka, Tim Andersen, Tomek Kaczanowski and Vikram Hullukunte
for reporting these issues.
</p>
</div>
<div class="release">
<h2>Flyway 1.7 (2012-07-10)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=174">Issue 174</a> Multiple
differently named base dirs for SQL Migrations
</li>
</ul>
<h3>Changes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=59">Issue 59</a> Spring Dependency
is now optional.
</li>
<li>Core: Flyway now directly depends on commons-logging. This previously happened transitively through the
spring-jdbc dependency.
</li>
<li>Core: Removed deprecated Flyway.get/setTransactionManager() methods. They already had no effect anymore
since 1.6
</li>
<li>Core: Deprecated <a href="/documentation/migration/java">JavaMigration</a>. Use
SpringJdbcMigration instead.
</li>
<li>Core: Deprecated JavaMigrationInfoProvider. Use MigrationInfoProvider instead.</li>
<li>Core: Deprecated JavaMigrationChecksumProvider. Use MigrationChecksumProvider instead.</li>
<li>Core: Deprecated flyway.baseDir and flyway.basePackage properties. Use the new flyway.locations instead.
</li>
<li>Command-line: New download distribution without Spring dependencies</li>
<li>Ant: New download distribution without Spring dependencies</li>
<li>Ant: Deprecated direct nesting of placeholder elements. They must now be wrapped inside a placeholders
container.
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=156">Issue 156</a> OSGI: Incorrect
Unable to find path for sql migrations
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=181">Issue 181</a> Deploying
flyway-core in virgo (Spring DM Server) fails with ClassNotFoundException: javax.sql.DataSource
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=182">Issue 182</a> Allow spring
3.0.x in osgi import-package
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=198">Issue 198</a> Angled-brackets
need to be escaped in Javadoc
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=211">Issue 211</a> Validation
package missing from OSGi exported packages
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=227">Issue 227</a> Deployment in a
WAR on JBoss
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=252">Issue 252</a> 1.6.1 flyway.sh
classloader problem
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=256">Issue 256</a> Enable File
Scanning for Zip Protocol
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=262">Issue 262</a> Fix incorrect
handling of nested dollar quotes in PostgreSQL scripts
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=263">Issue 263</a> Flyway
commandline 1.6.1 no available on Maven central
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=264">Issue 264</a> Getting
FlywayException when running maven flyway:migrate goal in
Jenkins
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=269">Issue 269</a>
FileSystemLocationScanner and Symbolic Links on
Unix
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=271">Issue 271</a> Flyway clean
fails to clean db2 when using views with materialized query tables
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=272">Issue 272</a> Flyway clean
doesn't drop DB2 aliases
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=279">Issue 279</a> Migrate fails on
.sql files with utf-8 signature
</li>
</ul>
<p>Thanks to Anssi Huusko, Cornelius Buschka, cowwoc, Friedrich Schaeuffelhut, Haam Tham, jtucker, Jussi Mononen,
Konstantin Zmanovsky, Marco Descher, Mathias Bogaert, Michael Lubavin, Michal Sabo, Stefan Ferstl, Thomas
Letsch, Thomas Recloux and Tsai Liming for reporting and providing patches for these issues.
</p>
</div>
<div class="release">
<h2>Flyway 1.6.1 (2012-04-21)</h2>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=239">Issue 239</a> Flyway 1.6
classpath scanner does not find files unless baseDir has trailing '/' </li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=241">Issue 241</a> 1.6 ant task no
longer works with sql migrations
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=242">Issue 242</a> Fail to properly
load resource files (SQL) in WebappClassLoader
</li>
</ul>
<p>Thanks to Marc Dumontier, Steve Tarka and vtkstef for reporting these issues.</p>
</div>
<div class="release">
<h2>Flyway 1.6 (2012-04-09)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=42">Issue 42</a> Derby support</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=197">Issue 197</a> Google Cloud SQL
support
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Flyway is now built with JDK 6, but still compatible with JDK 5.</li>
<li>Flyway is now tested against the SQL Server sqljdbc4 driver (was sqljdbc).</li>
<li>Flyway.get/setTransactionManager are now deprecated and have no effect anymore. <a
href="http://code.google.com/p/flyway/issues/detail?id=203">More info</a></li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=79">Issue 79</a> Migrations don't
support semicolons within quotes
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=184">Issue 184</a> Huge SQL
migrations force huge heap space for doing flyway migrate
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=186">Issue 186</a> Javadoc of
getBaseDir method of Flyway class is not consistent with implementation.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=192">Issue 192</a> Regression in
1.5 -- Oracle parsing of SQL Script fails due to fieldname 'Function' </li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=200">Issue 200</a> Cannot invoke
setDataSource() multiple times
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=208">Issue 208</a> Incorrect
Javadoc for Flyway.setBaseDir(String)
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=209">Issue 209</a> Support dropping
custom domains and enums in PostgreSQL
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=212">Issue 212</a> Multiline
inserts not supported by PostgreSQLSqlScript
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=217">Issue 217</a> Command-line
tool may fail to find config on windows machine
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=220">Issue 220</a> Maximum open
cursors
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=224">Issue 224</a> Oracle triggers
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=225">Issue 225</a> Clean for SQL
Server does not remove User Defined Table Types
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=232">Issue 232</a>
SqlMigrationResolver ignores scripts in a multi-module
environment
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=236">Issue 236</a> Flyway clean
fails for table created by Oracle text
</li>
</ul>
<p>Thanks to Alexander Hansen, Andrew Hunt, asotobu, Corin Fletcher, cowwoc, jaggerjackkurosaki, Juha Komulainen,
Klaus Etkar, Kris Mulica, Luc Degraef and vadim for reporting and contributing patches for these
issues.</p>
</div>
<div class="release">
<h2>Flyway 1.5 (2011-11-09)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=39">Issue 39</a> Ant Tasks for
Flyway
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=136">Issue 136</a> Support for
server credentials from settings.xml (Maven plugin)
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Calling validate either through the API, the Maven plugin, the Command-Line client or the Ant Tasks now
automatically sets the validationMode to ALL
</li>
<li>Removed the deprecated Flyway.init(version,description) method</li>
<li>Removed the deprecated BaseJavaMigration class and the pre
1.0 inheritance-based Java Migration support (update to implements <a
href="/documentation/migration/java">JavaMigration</a>
if you haven't already done so)
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=135">Issue 135</a> Include URL of
offending migrations in case of conflict
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=143">Issue 143</a> flyway.sh clean
fails due to dependencies (PostgreSQL cleaning of base types & functions)
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=144">Issue 144</a> Postgresql
functions defined in multiple-lines with $_$ placeholders fail to migrate
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=146">Issue 146</a> Allow
placeholder to disable sql code
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=148">Issue 148</a> Flyway command
line returns exit status 0, even on failure
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=152">Issue 152</a> NullPointerExcpetion
Null
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=153">Issue 153</a> Command line
tool 1.4.2 (Windows) - sql folder - unexpected behavior
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=154">Issue 154</a> Command line
tool 1.4.2 (Windows) - validating changes to executed migrations not happening
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=159">Issue 159</a> Delimiter change
happens outside of FUNCTIONS, PROCEDUREs and PACKAGES in Oracle
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=160">Issue 160</a> Not dropping
database object types during a Clean (Oracle)
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=161">Issue 161</a> Maven validate
goal doesn't validate
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=162">Issue 162</a> Migrations won't
work on MS SQL Server with case sensitive collation
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=168">Issue 168</a> flyway:clean
doesn't work in PostgreSQL on tables with child tables
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=170">Issue 170</a> Must not apply
migration if migration pattern is violated
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=173">Issue 173</a> Oracle: create
procedure parser issue
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=175">Issue 175</a> HsqlDB does not
cleanup sequences
</li>
</ul>
<p>Thanks to Seb Brousse, Christoph Giess, Jeremy Smith, Jon Roler, cowwoc, donald87, Timo Meinen, Octavian,
Dileep Hareendran, Kris Mulica, Ulf Bamberg, Luc Degraef and casibbald for contributing patches and reporting
these issues.</p>
</div>
<div class="release">
<h2>Flyway 1.4.2 (2011-06-29)</h2>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=119">Issue 119</a> Support Oracle
connection users
</li>
</ul>
<p>Thanks to Armin Gattung for reporting this issue.</p>
</div>
<div class="release">
<h2>Flyway 1.4.1 (2011-05-27)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=129">Issue 129</a> Use user
supplied TransactionManager
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=121">Issue 121</a> Maven 3 plugin
print logs
</li>
</ul>
<p>Thanks to jmarin and floburka for reporting these issues.</p>
</div>
<div class="release">
<h2>Flyway 1.4 (2011-05-13)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=116">Issue 116</a> Java 5 support
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Flyway is now tested with the DB2 Db2jcc driver (was Db2jcc4)</li>
<li>Flyway is now tested with the Oracle Ojdbc5 driver (was Ojdbc6)</li>
<li>Flyway is now tested with the PostgreSQL Jdbc3 driver (was Jdbc4)</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=93">Issue 93</a> Include paths of
offenders in migration conflict error message
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=94">Issue 94</a> "Found more
than one migration" error for duplicate resources
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=96">Issue 96</a> Migration fails of
version description is excessive
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=124">Issue 124</a> Maven:
flyway.schemas seems not be recognized
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=125">Issue 125</a> Oracle
Materialized View logs cause an exception during cleaning.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=126">Issue 126</a> Cleaning Oracle
Materialized Views causes exception
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=128">Issue 128</a> H2SqlScript does
not correctly detect statements
</li>
</ul>
<p>Thanks to Armin Gattung, Chris Wewerka, Gili Tzabari, Adriano Machado, everflux and stembler for reporting these
issues.</p>
</div>
<div class="release">
<h2>Flyway 1.3.1 (2011-04-06)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=106">Issue 106</a> Multiple schema
support
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=109">Issue 109</a> OSGi manifest
entries
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=102">Issue 102</a> Oracle: Flyway
now throws an exception when a clean is attempted on the SYSTEM schema
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=108">Issue 108</a> DB2Support:
Detection of tables for schema cleaning also includes views
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=110">Issue 110</a> H2 Problem: drop
table statements are created for views
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=111">Issue 111</a> Flyway should
not attempt to clean generated sequences on H2
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=113">Issue 113</a> DB2Support
Clean: Generation of drop sequences should not include system generated sequences
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=115">Issue 115</a> The command line
tool does not support -target property
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=120">Issue 120</a> Accept "go"
delimiter in small caps for SQL Server
</li>
<li>Fixed cleaning of views for HsqlDb</li>
</ul>
<p>Thanks to Chris Wewerka, Eric Jain, Derek Kwok, Matthew Lai and Julien Dumetier for reporting these
issues.</p>
</div>
<div class="release">
<h2>Flyway 1.3 (2011-03-18)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=40">Issue 40</a> DB2 support</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=103">Issue 103</a> Flyway can now
clean sequences, constants and domains on H2
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=104">Issue 104</a> mvn flyway:clean
fails with SQL-Exception when db user does not have DBA permissions (Oracle XE)
</li>
</ul>
<p>Thanks to Chris Wewerka for contributing the DB2 support!<br/> Thanks to M.Ahyaie, Jonas Kilian and Martin
Pletzer for reporting these issues.</p>
</div>
<div class="release">
<h2>Flyway 1.2 (2011-02-27)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=19">Issue 19</a> SQL Server support
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Flyway is now tested with MySQL version 5.1 (up from 5.0)</li>
<li>Flyway is now tested with the Oracle OJDBC6 JDBC driver (up from OJDBC14)</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=92">Issue 92</a> Flyway might be
leaking database connections
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=95">Issue 95</a> The clean command
needs to quote table names
</li>
<li>Support for semicolon at the end of a line inside a string literal (H2)</li>
<li>Support for CREATE PACKAGE statements (Oracle)</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=63">Issue 63</a> Support trailing
single line comments
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=97">Issue 97</a> Maven Plugin
should not log spring messages to console
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=89">Issue 89</a> Restore capability
to use non-empty database without init
</li>
</ul>
<p>Thanks to Adriano Machado for contributing the SQL Server support!<br/> Thanks to Gili Tzabari, René
Samselnig, Daniel Garcia, Ulf Bamberg and Gene Gotimer for reporting the other issues</p>
</div>
<div class="release">
<h2>Flyway 1.1 (2011-02-03)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=43">Issue 43</a> Standalone tool to
run Flyway directly from the command-line
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=77">Issue 77</a> The Flyway Maven
plugin now suggests running mvn compile if no migrations have been found.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=80">Issue 80</a> Prevent migrate()
or validate() on a non-empty schema without a metadata table with at least one applied migration.
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=78">Issue 78</a> Spring JDBC
dependency missing from POM.
</li>
<li>Support for semicolon at the end of a line inside a string literal (Hsql only for now)</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=81">Issue 81</a> Validation fails
with type mismatch for INIT
</li>
</ul>
<p>Thanks to jaggerjackkurosaki and Thomas Kruse for reporting these issues</p>
</div>
<div class="release">
<h2>Flyway 1.0.1 (2010-12-27)</h2>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=75">Issue 75</a> Wrong detection of
Spatial Extensions on Oracle 10g (but works on XE)
</li>
</ul>
</div>
<div class="release">
<h2 id="flyway-1.0">Flyway 1.0 (2010-12-26)</h2>
<h3>New Features</h3>
<ul>
<li>Clean now purges the Oracle recycle bin</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=72">Issue 72</a>
Flyway.configure(Properties) also works when the DataSource is
set explicitly beforehand.
</li>
</ul>
<p>Thanks to Mathias Bogaert for reporting the Flyway.configure issue</p>
</div>
<div class="release">
<h2>Flyway 0.9.5 (2010-12-12)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=36">Issue 36</a> Added support for
specifying a target version up to which Flyway should run migrations.
</li>
<li>Added new property <em>ignoreFailedFutureMigration</em> to ignore migration failures that happened while
deploying a newer version of the software. This allows for software rollbacks without having to do database
rollbacks, at the cost of weakening fail fast.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=31">Issue 31</a> Flyway now has its
own exception hierarchy. All exceptions thrown are now of type FlywayException.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=44">Issue 44</a> Flyway can now
find SQL migrations even if they are in subfolders of baseDir.
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>Removed support for upgrading from pre 0.9 versions. If you need to upgrade from 0.8.5 and earlier, you must
migrate to 0.9.4 first before migrating to this version.
</li>
<li>Removed support for the deprecated <em>metaDataTable</em> property. Use <em>table</em> instead.</li>
<li>Removed the deprecated <em>Flyway.init(SchemaVersion version)</em> method. Use <em>Flyway.init(SchemaVersion
version,
String description)</em> instead.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=30">Issue 30</a> Java migrations
are now based on interfaces instead of inheritance. The existing <em>BaseJavaMigration</em> class has been
deprecated and retrofitted to
this new model.
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>Fixed an issue with Oracle Spatial Index tables causing a failure when attempting to clean.</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.9.4 (2010-11-24)</h2>
<h3>Changes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=61">Issue 61</a> Reduced the info
logging to a single line per migration
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>Fixed a bug in the Oracle Sql Parser which caused it to trip over column names starting with 'begin'</li>
<li>Fixed custom version table name handling. Setting the datasource before the table name was causing an error.
This also affected the Maven plugin.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=65">Issue 65</a> New-lines are now
preserved in statements to improve the readability of stored procedures.
</li>
</ul>
<p>Thanks to Mathias Bogaert for reporting the logging issue and Daniel Garcia for reporting and contributing a
patch for the new-line issue</p>
</div>
<div class="release">
<h2>Flyway 0.9.3 (2010-11-09)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=62">Issue 62</a> Added support for
MySQL comment directives (/*!...*/;) so MySQL dumps can be used as migrations
</li>
</ul>
<p>Thanks to Mathias Bogaert for reporting this issue</p>
</div>
<div class="release">
<h2>Flyway 0.9.2 (2010-11-05)</h2>
<h3>New Features</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=51">Issue 51</a> The Flyway class
can now be configured using a Properties object
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=41">Issue 41</a> Support for
PostgreSQL, including stored procedures (CREATE FUNCTION with $$ escapes)
</li>
</ul>
<h3>Changes</h3>
<ul>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=38">Issue 38</a> The
SchemaVersion class doesn't contain the description
anymore
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=57">Issue 57</a> Ignoring oracle
recycle bin tables when running clean
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=55">Issue 55</a> Maven plugin does
not trigger phase compile anymore (use mvn compile flyway:migrate instead). Fixes Hudson problems.
</li>
<li><a href="http://code.google.com/p/flyway/issues/detail?id=55">Issue 53</a> Added default
phase pre-integration-test to clean and migrate mojos
</li>
</ul>
<p>Thanks to Philipp (godhood) for contributing large parts of the PostgreSQL support</p>
</div>
<div class="release">
<h2>Flyway 0.9.1 (2010-09-14)</h2>
<h3>Bug fixes</h3>
<ul>
<li>Fixed parsing of CREATE FUNCTION and CREATE PROCEDURE statements in PL/SQL</li>
</ul>
<p>Thanks to Hilario Fernandes for reporting this issue.</p>
</div>
<div class="release">
<h2>Flyway 0.9 (2010-08-25)</h2>
<h3>New Features</h3>
<ul>
<li>Support for migration checksums (CRC-32 for SQL Migrations, optional custom implementation for Java
migrations)
</li>
<li>Optional accidental change detection running validation (including checksums) before migration</li>
<li>mvn flyway:validate goal to validate the applied migrations against the available ones in the
classpath
</li>
<li>Sql migrations file names can now have a configurable prefix (Default: V) and suffix (Default: .sql)
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>The metadata table format has been extended with new columns (type, checksum, installed_by). Existing
metadata tables will be upgraded automatically on the first run, no manual intervention is required.
</li>
<li>The <em>schemaMetaDataTable</em> property has been renamed to <em>table</em> in both the Flyway class and
the Maven plugin. The old property still works, but has been deprecated and will be removed in 0.9.5
</li>
<li>mvn flyway:migrate now automatically triggers the compile phase to ensure that new migrations are found
by the plugin
</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>Fixed a problem where Flyway could not clean an Oracle database when the spatial extensions where
missing
</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.8.5 (2010-07-26)</h2>
<ul>
<li>Added mvn flyway:history goal to display the complete migration history of the schema</li>
<li>The encoding of the Sql migration files is now configurable</li>
<li>mvn flyway:clean is now more robust and available for all supported databases</li>
<li>Added mvn flyway:init to initialize an existing schema with a metadata table and an initial version</li>
<li>mvn flyway:status show installation date instead of execution time</li>
<li>Added MySQL stored procedure support</li>
<li>Java migrations now inherit from
<strong>com.googlecode.flyway.core.migration.java.BaseJavaMigration</strong></li>
<li>Fixed all known bugs</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.8 (2010-07-15)</h2>
<ul>
<li>Added mvn flyway:status goal to display the current version of the schema</li>
<li>Fixed logging in Maven Plugin</li>
<li>Base package changed to <strong>com.googlecode.flyway</strong> to match Maven groupId</li>
<li>Restored Spring 2.5 compatibility</li>
<li>Added an example of a Java Migration to the sample application</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.7 (2010-06-29)</h2>
<ul>
<li>Added support for parallel migrations. Flyway is now safe to deploy in a cluster.</li>
<li>[<em>Alpha</em>] Added initial mvn flyway:clean goal to remove all objects from the
schema. Note: Only for Oracle in 0.7
</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.6 (2010-06-13)</h2>
<ul>
<li>Updated maven groupId to <strong>com.googlecode.flyway</strong></li>
<li>Added HsqlDb support</li>
<li>Added Maven Plugin with Migrate mojo (mvn flyway:migrate)</li>
<li>Added Sample application</li>
<li>Fail-fast when a previous migration failed</li>
<li>Improved performance and logging output</li>
<li>Added H2 database support</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.0.5 (2010-05-13)</h2>
<ul>
<li>Fixed connection leaks</li>
<li>Improved support for PL/SQL blocks having a declare section</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.0.4 (2010-05-09)</h2>
<ul>
<li>Display exact script name and line number when a statement could not be executed</li>
<li>Added support for multi-line comments /* */ in sql scripts</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.0.3 (2010-04-26)</h2>
<ul>
<li>Added support for Ant-style ${placeholder} replacement in sql migrations</li>
<li>Added support for oracle pl/sql blocks in sql migrations</li>
</ul>
</div>
<div class="release">
<h2>Flyway 0.0.2 (2010-04-23)</h2>
<ul>
<li>Fixed current version index on Oracle</li>
</ul>
</div>
<div id="0.0.1" class="release">
<h2>Flyway 0.0.1 (2010-04-20)</h2>
<ul>
<li>Initial Release</li>
</ul>
</div>
<p class="next-steps">
<a class="btn btn-primary" href="/documentation/roadmap">Roadmap <i class="fa fa-arrow-right"></i></a>
</p>