liquibase.exception.JDBCException: Error executing SQL null: Caused By: Error executing SQL null: Caused By: Null SQL string passed.

JIRA | Nathan Voxland | 8 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    From http://liquibase.org/forum/index.php?topic=102.msg381#msg381 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

    JIRA | 8 years ago | Nathan Voxland
    liquibase.exception.JDBCException: Error executing SQL null: Caused By: Error executing SQL null: Caused By: Null SQL string passed.
  2. 0

    From http://liquibase.org/forum/index.php?topic=102.msg381#msg381 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

    JIRA | 8 years ago | Nathan Voxland
    liquibase.exception.JDBCException: Error executing SQL null: Caused By: Error executing SQL null: Caused By: Null SQL string passed.

    Root Cause Analysis

    1. com.ibm.db2.jcc.a.SqlException

      Null SQL string passed.

      at com.ibm.db2.jcc.a.o.d()
    2. IBM DB2
      cy.execute
      1. com.ibm.db2.jcc.a.o.d(o.java:778)
      2. com.ibm.db2.jcc.a.cy.m(cy.java:2427)
      3. com.ibm.db2.jcc.a.cy.a(cy.java:1569)
      4. com.ibm.db2.jcc.a.cy.e(cy.java:696)
      5. com.ibm.db2.jcc.a.cy.execute(cy.java:680)
      5 frames
    3. liquibase.database.template
      JdbcTemplate.execute
      1. liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78)
      2. liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
      3. liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
      3 frames
    4. Liquibase Core
      ChangeSet.execute
      1. liquibase.change.AbstractChange.execute(AbstractChange.java:247)
      2. liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
      3. liquibase.ChangeSet.execute(ChangeSet.java:236)
      3 frames
    5. liquibase.parser.visitor
      UpdateVisitor.visit
      1. liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
      1 frame
    6. Liquibase Core
      Liquibase.update
      1. liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
      2. liquibase.Liquibase.update(Liquibase.java:112)
      2 frames
    7. liquibase.commandline
      Main.main
      1. liquibase.commandline.Main.doMigration(Main.java:650)
      2. liquibase.commandline.Main.main(Main.java:97)
      2 frames