# liquibase 1.9.4 - DB2 - addPrimaryKey - No SQL generated.

**URL:** <https://forum.liquibase.org/t/liquibase-1-9-4-db2-addprimarykey-no-sql-generated/177>\
**Category:** General Discussion\
**Created:** [August 4, 2009, 1:42pm UTC](https://forum.liquibase.org/t/liquibase-1-9-4-db2-addprimarykey-no-sql-generated/177 "2009-08-04T13:42:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dsharma\_lb](https://avatars.discourse-cdn.com/v4/letter/d/94ad74/32.png) [@dsharma\_lb](https://forum.liquibase.org/u/dsharma_lb)\
**Post date:** [August 4, 2009, 1:42pm UTC](https://forum.liquibase.org/t/liquibase-1-9-4-db2-addprimarykey-no-sql-generated/177/1 "2009-08-04T13:42:00Z")

</div>

## 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.&nbsp; 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: &nbsp; &nbsp; Reason: liquibase.exception.JDBCException: Error executing SQL null: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Caused By: Error executing SQL null: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Caused By: Null SQL string passed. &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.ChangeSet.execute(ChangeSet.java:260) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.Liquibase.update(Liquibase.java:112) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.commandline.Main.doMigration(Main.java:650) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.commandline.Main.main(Main.java:97) Caused by: liquibase.exception.JDBCException: Error executing SQL null &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.change.AbstractChange.execute(AbstractChange.java:247) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.ChangeSet.execute(ChangeSet.java:236) &nbsp; &nbsp; &nbsp; &nbsp; … 5 more Caused by: com.ibm.db2.jcc.a.SqlException: Null SQL string passed. &nbsp; &nbsp; &nbsp; &nbsp; at com.ibm.db2.jcc.a.o.d(o.java:778) &nbsp; &nbsp; &nbsp; &nbsp; at com.ibm.db2.jcc.a.cy.m(cy.java:2427) &nbsp; &nbsp; &nbsp; &nbsp; at com.ibm.db2.jcc.a.cy.a(cy.java:1569) &nbsp; &nbsp; &nbsp; &nbsp; at com.ibm.db2.jcc.a.cy.e(cy.java:696) &nbsp; &nbsp; &nbsp; &nbsp; at com.ibm.db2.jcc.a.cy.execute(cy.java:680) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) &nbsp; &nbsp; &nbsp; &nbsp; at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) &nbsp; &nbsp; &nbsp; &nbsp; … 9 more

## \<?xml version="1.0" encoding="UTF-8"?\> \<databaseChangeLog xmlns=“[http://www.liquibase.org/xml/ns/dbchangelog/1.9”](http://www.liquibase.org/xml/ns/dbchangelog/1.9%22) xmlns:xsi=“[http://www.w3.org/2001/XMLSchema-instance”](http://www.w3.org/2001/XMLSchema-instance%22) xsi:schemaLocation=“[http://www.liquibase.org/xml/ns/dbchangelog/1.9](http://www.liquibase.org/xml/ns/dbchangelog/1.9) [http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd”\>](http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd%22>) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

db2 jdbc driver - db2jcc-8.2  
DB2 version 8.x

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [August 4, 2009, 1:42pm UTC](https://forum.liquibase.org/t/liquibase-1-9-4-db2-addprimarykey-no-sql-generated/177/2 "2009-08-04T13:42:00Z")

</div>

I created an issue to look into it more: [http://liquibase.jira.com/browse/CORE-435](http://liquibase.jira.com/browse/CORE-435)

You should be able to use the tag for now to work around the problem.&nbsp; Thanks for the report.

Nathan