A new topic, 'Quickstart not working with DB2', has been made on a board you
are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=680.new#new
The text of the topic is shown below:
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:Toolsliquibase-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
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
