I’m starting to look at liquibase and I started with the quickstart. It failed in creating the table in DB2. The default value of the active column is supposed to be 1. but the sql generated is:
CREATE
TABLE vap.departmentTest
(
id INT NOT NULL,
name VARCHAR(50) NOT NULL,
active SMALLINT DEFAULT ‘1’,
CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id)
)
This failed in DB2. I had to remove the single quotes around the 1 to get it to work.
CREATE
TABLE vap.departmentTest
(
id INT NOT NULL,
name VARCHAR(50) NOT NULL,
active SMALLINT DEFAULT 1,
CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id)
)
Here is the error
C:\Tools\liquibase-1.9.5>liquibase migrate
Aug 31, 2010 10:50:27 AM liquibase.database.template.JdbcTemplate comment
INFO: Lock Database
Aug 31, 2010 10:50:27 AM liquibase.lock.LockHandler acquireLock
INFO: Successfully acquired change log lock
Aug 31, 2010 10:50:27 AM liquibase.database.AbstractDatabase getRanChangeSetList
INFO: Reading from vap.DATABASECHANGELOG
Aug 31, 2010 10:50:27 AM liquibase.database.template.JdbcTemplate comment
INFO: Changeset changeLog.xml::3::bob::(MD5Sum: 1328b4eed1fa2acd9df8dd48b1d32ac4)
Aug 31, 2010 10:50:27 AM liquibase.database.template.JdbcTemplate comment
INFO: Release Database Lock
Aug 31, 2010 10:50:27 AM liquibase.lock.LockHandler releaseLock
INFO: Successfully released change log lock
Migration Failed: Error executing SQL CREATE TABLE vap.departmentTest (id INT NOT NULL, name VARCHAR(50) NOT NULL, activ
e SMALLINT DEFAULT ‘1’, CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id)). For more information, use the --logLevel flag)
Aug 31, 2010 10:50:27 AM liquibase.commandline.Main main
SEVERE: Error executing SQL CREATE TABLE vap.departmentTest (id INT NOT NULL, name VARCHAR(50) NOT NULL, active SMALLINT
DEFAULT ‘1’, CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id))
liquibase.exception.MigrationFailedException: Migration failed for change set changeLog.xml::3::bob:
Reason: liquibase.exception.JDBCException: Error executing SQL CREATE TABLE vap.departmentTest (id INT NOT NULL, na
me VARCHAR(50) NOT NULL, active SMALLINT DEFAULT ‘1’, CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id)):
Caused By: Error executing SQL CREATE TABLE vap.departmentTest (id INT NOT NULL, name VARCHAR(50) NOT NULL, ac
tive SMALLINT DEFAULT ‘1’, CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id)):
Caused By: DB2 SQL Error: SQLCODE=-574, SQLSTATE=42894, SQLERRMC=ACTIVE;VAP.DEPARTMENTTEST;1, DRIVER=3.58.82
at liquibase.ChangeSet.execute(ChangeSet.java:260)
at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
at liquibase.Liquibase.update(Liquibase.java:112)
at liquibase.commandline.Main.doMigration(Main.java:650)
at liquibase.commandline.Main.main(Main.java:97)
Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE TABLE vap.departmentTest (id INT NOT NULL, name
VARCHAR(50) NOT NULL, active SMALLINT DEFAULT ‘1’, CONSTRAINT PK_DEPARTMENTTEST PRIMARY KEY (id))
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
at liquibase.ChangeSet.execute(ChangeSet.java:236)
… 5 more
Caused by: com.ibm.db2.jcc.am.ro: DB2 SQL Error: SQLCODE=-574, SQLSTATE=42894, SQLERRMC=ACTIVE;VAP.DEPARTMENTTEST;1, DRI
VER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.d(tm.java:2511)
at com.ibm.db2.jcc.am.tm.b(tm.java:1931)
at com.ibm.db2.jcc.t4.fb.h(fb.java:221)
at com.ibm.db2.jcc.t4.fb.b(fb.java:47)
at com.ibm.db2.jcc.t4.t.b(t.java:38)
at com.ibm.db2.jcc.t4.ub.h(ub.java:114)
at com.ibm.db2.jcc.am.tm.eb(tm.java:1926)
at com.ibm.db2.jcc.am.tm.a(tm.java:3017)
at com.ibm.db2.jcc.am.tm.e(tm.java:1009)
at com.ibm.db2.jcc.am.tm.execute(tm.java:993)
at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
… 9 more