Liquibase Informix generateChangelog问题

Question

我正在使用Liquibase version3.3.2通过generateChangeLog命令为我现有的Informix DB创建一个changelog。

成功创建了changelog.xml (483KB)，但不包含任何变更集！我尝试过使用Liquibase的其他版本，但没有成功。是Liquibase的bug吗？

我的命令看起来像这样-

liquibase --changeLogFile=changelog.xml --url="jdbc:informix-sqli://172.28.137.182:9088/glsnextgen:informixserver=testgif" --username=abc --password=abc --logLevel=debug --logFile=log.txt --defaultSchema=sysmaster generateChangeLog

但是，生成的changelog没有变更集。这是changelog的样子-

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" 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.3.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd"/>

我的调试日志是这样的-

DEBUG 18/2/15 11:22 AM: liquibase: Connected to santhosh@jdbc:informix-sqli://172.28.137.182:9088/glsnextgen:informixserver=testgif

DEBUG 18/2/15 11:22 AM: liquibase: Setting auto commit to false from true

DEBUG 18/2/15 11:22 AM: liquibase: Executing EXECUTE database command: EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T');

DEBUG 18/2/15 11:22 AM: liquibase: Computed checksum for 1424238728847 as 9ed2ff6dc6133a2a2bb8f27d79bd1597

INFO 18/2/15 11:22 AM: liquibase: changelog1.xml does not exist, creating

DEBUG 18/2/15 11:22 AM: liquibase: MissingObjectChangeGenerator type order:     liquibase.structure.core.Catalog    liquibase.structure.core.Schema    liquibase.structure.core.Sequence    liquibase.structure.core.StoredProcedure    liquibase.structure.core.Table    liquibase.structure.core.Column    liquibase.structure.core.PrimaryKey    liquibase.structure.core.UniqueConstraint    liquibase.structure.core.ForeignKey    liquibase.structure.core.Index    liquibase.structure.core.View

DEBUG 18/2/15 11:22 AM: liquibase: UnexpectedObjectChangeGenerator type order:     liquibase.structure.core.Catalog    liquibase.structure.core.ForeignKey    liquibase.structure.core.Schema    liquibase.structure.core.StoredProcedure    liquibase.structure.core.UniqueConstraint    liquibase.structure.core.View    liquibase.structure.core.Table    liquibase.structure.core.PrimaryKey    liquibase.structure.core.Column    liquibase.structure.core.Index    liquibase.structure.core.Sequence

DEBUG 18/2/15 11:22 AM: liquibase: ChangedObjectChangeGenerator type order:     liquibase.structure.core.Catalog    liquibase.structure.core.ForeignKey    liquibase.structure.core.Schema    liquibase.structure.core.Sequence    liquibase.structure.core.StoredProcedure    liquibase.structure.core.Table    liquibase.structure.core.Column    liquibase.structure.core.PrimaryKey    liquibase.structure.core.Index    liquibase.structure.core.UniqueConstraint    liquibase.structure.core.View

Answer 1

它似乎假设Informix始终使用ansi模式，并且在该模式下，模式是表的所有者。

然后，在参数--defaultSchemaName=sysmaster中，应将其更改为--defaultSchemaName=

update此功能适用于版本3.4.1，您可以在可选参数command line documentation上看到