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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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