Hi,
i am trying to use liquibase to bootstrap a complete DB schema, thus i
dont have any tables. Only the schema. Normally Liquibase creates its
two management tables and then runs the changeset. This works with
MySQL but with DB2 for iSeries, i am getting the following stack. It
seems Liquibase use a Constraint names two times. Lquibase wants to
create "PK_DATABASECHANGE" two times.
java.sql.SQLException: [SQL0601] PK_DATABASECHANGE der Art * in
NETVERSYS2 bereits vorhanden.
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at
com
.ibm
.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:
1378)
at
com
.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:
1729)
at
org
.apache
.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at liquibase.database.template.JdbcTemplate
$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
at
liquibase
.database
.AbstractDatabase
.checkDatabaseChangeLogLockTable(AbstractDatabase.java:712)
at liquibase.lock.LockHandler.acquireLock(LockHandler.java:40)
at liquibase.lock.LockHandler.waitForLock(LockHandler.java:150)
at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:518)
The SQL message is in german, it translates to:
java.sql.SQLException: [SQL0601] PK_DATABASECHANGE of Type * in
NETVERSYS2 already existant.
And in fact it already exists because Liquibase already created its
first (the lock table) entity. It seems it wants to create the second
with the same constraint name. Can this be?
---
regards
Marc Logemann
http://www.logemann.org
http://www.logentis.de
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
