A new topic, 'liquibase 1.9.4 - DB2 - addPrimaryKey - No SQL generated.', has
been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=102.new#new
The text of the topic is shown below:
Liquibase gives the error:
-------------------------------------------------------------------------------------------------
Aug 4, 2009 8:30:51 AM liquibase.database.template.JdbcTemplate comment
INFO: Lock Database
Aug 4, 2009 8:30:51 AM liquibase.lock.LockHandler acquireLock
INFO: Successfully acquired change log lock
Aug 4, 2009 8:30:52 AM liquibase.database.AbstractDatabase getRanChangeSetList
INFO: Reading from CASEY.DATABASECHANGELOG
Aug 4, 2009 8:30:52 AM liquibase.database.template.JdbcTemplate comment
INFO: Changeset test.xml::1-1::dsharma::(MD5Sum:
adf9bd425556f6c9dc13cb352279982b)
Aug 4, 2009 8:30:52 AM liquibase.database.template.JdbcTemplate comment
INFO: Changeset test.xml::1-2::dsharma::(MD5Sum:
b450ff193e23ce1bb92c90359cccc3a)
Aug 4, 2009 8:30:54 AM liquibase.database.template.JdbcTemplate comment
INFO: Release Database Lock
Aug 4, 2009 8:30:54 AM liquibase.lock.LockHandler releaseLock
INFO: Successfully released change log lock
Migration Failed: Error executing SQL null. For more information, use the
--logLevel flag)
Aug 4, 2009 8:30:54 AM liquibase.commandline.Main main
SEVERE: Error executing SQL null
liquibase.exception.MigrationFailedException: Migration failed for change set
test.xml::1-2::dsharma:
Reason: liquibase.exception.JDBCException: Error executing SQL null:
Caused By: Error executing SQL null:
Caused By: Null SQL string passed.
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 null
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.a.SqlException: Null SQL string passed.
at com.ibm.db2.jcc.a.o.d(o.java:778)
at com.ibm.db2.jcc.a.cy.m(cy.java:2427)
at com.ibm.db2.jcc.a.cy.a(cy.java:1569)
at com.ibm.db2.jcc.a.cy.e(cy.java:696)
at com.ibm.db2.jcc.a.cy.execute(cy.java:680)
at
liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
... 9 more
-----------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd";>
<changeSet author="dsharma" id="1-1">
<createTable tableName="DEPARTMENT">
<column name="ID" type="BIGINT">
<constraints nullable="false"/>
</column>
<column name="NAME" type="VARCHAR(20)"/>
</createTable>
</changeSet>
<changeSet author="dsharma" id="1-2">
<addPrimaryKey columnNames="ID" constraintName="PK_DPT"
tableName="DEPARTMENT"/>
</changeSet>
</databaseChangeLog>
-------------------------------------------------------------------
db2 jdbc driver - db2jcc-8.2
DB2 version 8.x
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.------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
