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

JIRA | Nathan Voxland | 7 years ago
  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 | 7 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 | 7 years ago | Nathan Voxland
    liquibase.exception.JDBCException: Error executing SQL null: Caused By: Error executing SQL null: Caused By: Null SQL string passed.
  3. 0

    Inserting an uploaded file to DB2 Clob using Spring Framework or general JDBC

    Stack Overflow | 3 years ago | user2928305
    com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 4.21::DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 ad

    hivmr.com | 5 months ago
    com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: LEASEAC;PROCEDURE
  6. 0

    Sometimes SQLCODE: -805 appears

    Google Groups | 1 decade ago | Marcel
    com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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