liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'"

JIRA | Dieter Van de Walle | 1 year 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

    When generating a snapshot of a BIT column, SqlUtil supports the following syntax: b'0' But not with uppercase B: B'0' Apparently HSQL returns an uppercase B notation. Just making SqlUtil.parseValue() case insensitive regarding the BIT value parsing should fix this. {code} Diff Results: DEBUG 10/7/15 4:02 PM: liquibase: Computed checksum for 1444226543130 as 737a0effc6b811c400b91a47e679a02e DEBUG 10/7/15 4:02 PM: liquibase: Executing QUERY database command: SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES WHERE SEQUENCE_SCHEMA = 'PUBLIC' Unexpected error running Liquibase: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" SEVERE 10/7/15 4:02 PM: liquibase: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" at liquibase.integration.commandline.CommandLineUtils.doDiff(CommandLineUtils.java:164) at liquibase.integration.commandline.Main.doMigration(Main.java:964) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" at liquibase.command.AbstractCommand.execute(AbstractCommand.java:13) at liquibase.integration.commandline.CommandLineUtils.doDiff(CommandLineUtils.java:162) ... 3 more Caused by: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" at liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:116) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:73) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:194) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:273) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:273) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:315) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:70) at liquibase.snapshot.DatabaseSnapshot.<init>(DatabaseSnapshot.java:44) at liquibase.snapshot.JdbcDatabaseSnapshot.<init>(JdbcDatabaseSnapshot.java:21) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:150) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139) at liquibase.command.DiffCommand.createReferenceSnapshot(DiffCommand.java:190) at liquibase.command.DiffCommand.createDiffResult(DiffCommand.java:140) at liquibase.command.DiffCommand.run(DiffCommand.java:132) at liquibase.command.AbstractCommand.execute(AbstractCommand.java:8) ... 4 more Caused by: java.lang.NumberFormatException: For input string: "B'0'" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:580) at java.lang.Integer.<init>(Integer.java:867) at liquibase.util.SqlUtil.parseValue(SqlUtil.java:129) at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readDefaultValue(ColumnSnapshotGenerator.java:372) at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readColumn(ColumnSnapshotGenerator.java:219) at liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:111) ... 38 more {code}

    JIRA | 1 year ago | Dieter Van de Walle
    liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'"
  2. 0

    When generating a snapshot of a BIT column, SqlUtil supports the following syntax: b'0' But not with uppercase B: B'0' Apparently HSQL returns an uppercase B notation. Just making SqlUtil.parseValue() case insensitive regarding the BIT value parsing should fix this. {code} Diff Results: DEBUG 10/7/15 4:02 PM: liquibase: Computed checksum for 1444226543130 as 737a0effc6b811c400b91a47e679a02e DEBUG 10/7/15 4:02 PM: liquibase: Executing QUERY database command: SELECT SEQUENCE_NAME FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES WHERE SEQUENCE_SCHEMA = 'PUBLIC' Unexpected error running Liquibase: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" SEVERE 10/7/15 4:02 PM: liquibase: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" at liquibase.integration.commandline.CommandLineUtils.doDiff(CommandLineUtils.java:164) at liquibase.integration.commandline.Main.doMigration(Main.java:964) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" at liquibase.command.AbstractCommand.execute(AbstractCommand.java:13) at liquibase.integration.commandline.CommandLineUtils.doDiff(CommandLineUtils.java:162) ... 3 more Caused by: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'" at liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:116) at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:73) at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:194) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:273) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:273) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293) at liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:315) at liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235) at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208) at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:70) at liquibase.snapshot.DatabaseSnapshot.<init>(DatabaseSnapshot.java:44) at liquibase.snapshot.JdbcDatabaseSnapshot.<init>(JdbcDatabaseSnapshot.java:21) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:150) at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139) at liquibase.command.DiffCommand.createReferenceSnapshot(DiffCommand.java:190) at liquibase.command.DiffCommand.createDiffResult(DiffCommand.java:140) at liquibase.command.DiffCommand.run(DiffCommand.java:132) at liquibase.command.AbstractCommand.execute(AbstractCommand.java:8) ... 4 more Caused by: java.lang.NumberFormatException: For input string: "B'0'" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:580) at java.lang.Integer.<init>(Integer.java:867) at liquibase.util.SqlUtil.parseValue(SqlUtil.java:129) at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readDefaultValue(ColumnSnapshotGenerator.java:372) at liquibase.snapshot.jvm.ColumnSnapshotGenerator.readColumn(ColumnSnapshotGenerator.java:219) at liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:111) ... 38 more {code}

    JIRA | 1 year ago | Dieter Van de Walle
    liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: java.lang.NumberFormatException: For input string: "B'0'"
  3. 0

    Logback 1.1.7 NumberFormatException with "springProperty"

    Stack Overflow | 3 months ago | rafambbr
    ch.qos.logback.core.util.PropertySetterException: Conversion to type [int] failed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    CZI files with bitdepths 12/14/36/42 can not be loaded

    GitHub | 4 years ago | smozen
    java.lang.NumberFormatException: For input string: "2.5"
  6. 0

    FC when enter altitude not integer

    GitHub | 5 years ago | mucek4
    java.lang.RuntimeException: Unable to pause activity {cgeo.geocaching/cgeo.geocaching.cgeoinit}: java.lang.NumberFormatException: unable to parse '+13' as integer

  1. guizmaii 1 times, last 3 months ago
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. java.lang.NumberFormatException

    For input string: "B'0'"

    at java.lang.NumberFormatException.forInputString()
  2. Java RT
    Integer.<init>
    1. java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    2. java.lang.Integer.parseInt(Integer.java:580)
    3. java.lang.Integer.<init>(Integer.java:867)
    3 frames
  3. Liquibase Core
    Main.main
    1. liquibase.util.SqlUtil.parseValue(SqlUtil.java:129)
    2. liquibase.snapshot.jvm.ColumnSnapshotGenerator.readDefaultValue(ColumnSnapshotGenerator.java:372)
    3. liquibase.snapshot.jvm.ColumnSnapshotGenerator.readColumn(ColumnSnapshotGenerator.java:219)
    4. liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:111)
    5. liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:73)
    6. liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)
    7. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:194)
    8. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:273)
    9. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    10. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    11. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293)
    12. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    13. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    14. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293)
    15. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    16. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    17. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:273)
    18. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    19. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    20. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293)
    21. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    22. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    23. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293)
    24. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    25. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    26. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:293)
    27. liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:315)
    28. liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:235)
    29. liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:208)
    30. liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:70)
    31. liquibase.snapshot.DatabaseSnapshot.<init>(DatabaseSnapshot.java:44)
    32. liquibase.snapshot.JdbcDatabaseSnapshot.<init>(JdbcDatabaseSnapshot.java:21)
    33. liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:150)
    34. liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:139)
    35. liquibase.command.DiffCommand.createReferenceSnapshot(DiffCommand.java:190)
    36. liquibase.command.DiffCommand.createDiffResult(DiffCommand.java:140)
    37. liquibase.command.DiffCommand.run(DiffCommand.java:132)
    38. liquibase.command.AbstractCommand.execute(AbstractCommand.java:8)
    39. liquibase.integration.commandline.CommandLineUtils.doDiff(CommandLineUtils.java:162)
    40. liquibase.integration.commandline.Main.doMigration(Main.java:964)
    41. liquibase.integration.commandline.Main.run(Main.java:180)
    42. liquibase.integration.commandline.Main.main(Main.java:99)
    42 frames