com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 5: CALL DROP_TABLE_IF_EXISTS('RETRIEVED_OBJECTS')

GitHub | galphanet | 2 months ago
  1. 0

    SQL error when forcing updates of the Trust Anchors

    GitHub | 2 months ago | galphanet
    com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 5: CALL DROP_TABLE_IF_EXISTS('RETRIEVED_OBJECTS')
  2. 0

    Using flyway with play in test mode: Schema "public" not found

    Stack Overflow | 3 years ago | Heinzi
    com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 10: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
  3. 0

    Using flyway with play in test mode: Schema "public" not found

    Stack Overflow | 3 years ago | Heinzi
    com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 17: CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL )
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.googlecode.flyway.core.command.FlywaySqlScriptException

      Error executing statement at line 5: CALL DROP_TABLE_IF_EXISTS('RETRIEVED_OBJECTS')

      at com.googlecode.flyway.core.dbsupport.SqlScript.execute()
    2. ${project.artifactId}
      Flyway.migrate
      1. com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:92)
      2. com.googlecode.flyway.core.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:72)
      3. com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:243)
      4. com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:241)
      5. com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      6. com.googlecode.flyway.core.command.DbMigrate.applyMigration(DbMigrate.java:241)
      7. com.googlecode.flyway.core.command.DbMigrate.access$700(DbMigrate.java:44)
      8. com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:186)
      9. com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:135)
      10. com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      11. com.googlecode.flyway.core.command.DbMigrate.migrate(DbMigrate.java:135)
      12. com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:872)
      13. com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:819)
      14. com.googlecode.flyway.core.Flyway.execute(Flyway.java:1200)
      15. com.googlecode.flyway.core.Flyway.migrate(Flyway.java:819)
      15 frames