Liquibase不使用Ant提交变更集

Question

我已经用Spring试用过LiquiBase3.0测试版了（顺便说一句，它不适合2.0）。很顺利。

现在，我正在用Ant和相同的数据库和changelog测试它，在回滚所有更改并删除表DATABASECHANGELOG和DatabaseChangeloglock之后。

问题是liquibase将所有更改集记录在表DATABASECHANGELOG中，这意味着我的配置中没有任何错误，但它没有将更改提交给数据库。

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog  http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.0.xsd">

  <preConditions>
    <dbms type="mysql"/>
  </preConditions>

  <changeSet id="1" author="bob" runAlways="true">
    <createTable tableName="department">
      <column name="id" type="int">
        <constraints primaryKey="true" nullable="false"/>
      </column>
      <column name="name" type="varchar(50)">
        <constraints nullable="false"/>
      </column>
      <column name="active" type="boolean" defaultValueBoolean="true"/>
    </createTable>
  </changeSet>

  <changeSet id="2" author="roger" runAlways="true">
    <comment>test add column</comment>
    <addColumn tableName="department">
      <column name="header" type="varchar(8)"/>
    </addColumn>
  </changeSet>

  <changeSet id="3" author="gabriel" runAlways="true">
    <createTable tableName="records">
      <column name="id" type="int" autoIncrement="true">
        <constraints primaryKey="true" nullable="false"/>
      </column>
      <column name="title" type="varchar(50)"/>
    </createTable>
  </changeSet>

  <changeSet id="4" author="gabriel" context="test" runAlways="true">
    <insert tableName="records">
      <column name="title" value="Liquibase 0.8 Released"/>
    </insert>
    <insert tableName="records">
      <column name="title" value="Liquibase 0.9 Released"/>
    </insert>
  </changeSet>

  <changeSet id="6" author="nvoxland" runAlways="true">
    <comment>test update eam_company</comment>
    <sql>update eam_company set companyName='haha' where companyId=15</sql>
  </changeSet>

</databaseChangeLog>

<?xml version="1.0" encoding="utf-8"?>
<project name="ncpsys_v2" default="all">
  <!-- define time stamp -->
  <tstamp>
    <format property="current.time" pattern="yyyy_MM_dd_HH_mm_ss"/>
  </tstamp>

  <!-- define varibles and path -->
  <property file="liquibaseconf.properties"/>
  <path id="ant.classpath">
    <fileset dir="${ant.home}">
      <include name="**/*.jar"/>
    </fileset>
  </path>

  <target name="sync-database">
    <fail unless="db.changelog.file">db.changelog.file not set</fail>
    <fail unless="database.url">database.url not set</fail>
    <fail unless="database.username">database.username not set</fail>
    <fail unless="database.password">database.password not set</fail>
    <taskdef resource="liquibasetasks.properties">
      <classpath refid="ant.classpath"/>
    </taskdef>
    <changeLogSync changeLogFile="${db.changelog.file}" driver="${database.driver}" url="${database.url}" username="${database.username}" password="${database.password}" promptOnNonLocalDatabase="true" defaultSchemaName="root" classpathref="ant.classpath">
     </changeLogSync>
  </target>

  <target name="all" depends="sync-database"/>
</project>

LiquiBaseTasks.Properties文件

local.dir=.
#gwt.home=E:/work/libaray/gwt-2.3.0
jdk.home.1.6=C:/Program Files/Java/jdk1.6.0_10
ant_home=D:/software/apache-ant-1.8.3
tomcat.home=C:/Program Files/Apache Software Foundation/apache-tomcat-6.0.36

#liquibase config
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/ncpsys_v2?useUnicode=true&characterEncoding=UTF-8
database.username=root
database.password=1234
db.changelog.file=changelog.xml

我运行Ant任务，liquibase为我创建了表DATABASECHANGELOG和DATABASECHANGELOGLOCK，并在DATABASECHANGELOG中插入日志。

我的生成日志：

sync-database:
[changeLogSync] INFO 13-4-2 下午1:22:liquibase: Successfully acquired change log lock
[changeLogSync] INFO 13-4-2 下午1:22:liquibase: Creating database history table with name: `ncpsys_v2`.`DATABASECHANGELOG`
[changeLogSync] INFO 13-4-2 下午1:22:liquibase: Reading from `ncpsys_v2`.`DATABASECHANGELOG`
[changeLogSync] INFO 13-4-2 下午1:22:liquibase: Reading from `ncpsys_v2`.`DATABASECHANGELOG`
[changeLogSync] INFO 13-4-2 下午1:22:liquibase: Successfully released change log lock

all:

BUILD SUCCESSFUL

Total time: 2 seconds

Answer 1

您正在运行changeLogSync ANT任务。描述如下：

将所有更改集标记为对数据库运行。在手动更新数据库时很有用。

这解释了为什么没有向数据库提交任何内容。我认为您应该改用updateDatabase任务