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
  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 | 4 days 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 1 week 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