LiquiBase

There are times when I have seen projects with a version 1.9 that means “the last 1.x release before 2.0″. In our case, “1.9″ simply means “the release after 1.8″

After a bit of discussion on the liquibase-user mailing list, we decided that we didn’t want to go to a 2.0 release at this point because there has not been any major changes and we have kept backwords compatibility.

Therefore, we are going to continue our current 1.x numbering strategy and continue to provide evolutionary improvements for the foreseeable future.  1.10, 1.11 etc. do look a bit confusing and like 1.1.0, 1.1.1 etc, but I think most LiquiBase users will be smart enough to figure it out

LiquiBase 1.9.0 has been released!

Major features include:

• <modifySql> support
• <includeAll> support
• Sybase Adaptive SQL Anywhere support
• Paths in <include> can be relative to changelog using the “relativeToChangeLog” attribute
• <stop> support
  
• runInTransaction attribute for changeSet
• Stronger validation in .xsd
• Better Derby support (drop column, rename column)
• Bug fixes

If you are using the standard LiquiBase library, upgrading is simply a matter of replacing the liquibase.jar file.   If you are using Grails, Maven, or the IntelliJ plugin, an updated version should be available via standard plugin repository within in the next day.

NOTE: DUE TO A BUG IN THE “ADD NOT NULL CONSTRAINT” AND “DROP NOT NULL CONSTRAINT” CODE, YOU WILL GET CHECKSUM VALIDATION ERRORS FOR EXISTING CHANGESETS THAT USE THOSE TAGS.

To solve the problem, either:

1. Add the <validCheckSum> tag to the failing changesets specifying the old MD5 sum (the one listed in the validation failed message)
2. Or, run “UPDATE DATABASECHANGELOG SET MD5SUM=NULL”

To take advantage of newer change log features, change your XSD declaration to:

<databasechangelog xmlns=”http://www.liquibase.org/xml/ns/dbchangelog/1.9″
xsi=”http://www.w3.org/2001/XMLSchema-instance”
schemalocation=”http://www.liquibase.org/xml/ns/dbchangelog/1.9
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd”>

Download LiquiBase 1.9 from:

http://www.liquibase.org/download

As usual, make sure you let us know if you have any questions, problems, or ideas.  Also, thank you to everyone who submitted bug reports and patches over the last couple months.