org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Migration V1__hoge.sql failed ------------------------------ SQL State : 42000 Error Code : 42000 Message : SQLステートメントに文法エラーがあります "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI " Syntax error in SQL statement "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI "; SQL statement: CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci [42000-190] Location : db/migration/V1__hoge.sql (/Users/niwashun/Workspaces/hogemoge/target/dev/scala-2.11/classes/db/migration/V1__hoge.sql) Line : 1 Statement : CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

qiita.com | 6 months 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

    Flyway + H2 with MySQL Compatibility Mode - Qiita

    qiita.com | 6 months ago
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Migration V1__hoge.sql failed ------------------------------ SQL State : 42000 Error Code : 42000 Message : SQLステートメントに文法エラーがあります "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI " Syntax error in SQL statement "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI "; SQL statement: CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci [42000-190] Location : db/migration/V1__hoge.sql (/Users/niwashun/Workspaces/hogemoge/target/dev/scala-2.11/classes/db/migration/V1__hoge.sql) Line : 1 Statement : CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

    Root Cause Analysis

    1. org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException

      Migration V1__hoge.sql failed ------------------------------ SQL State : 42000 Error Code : 42000 Message : SQLステートメントに文法エラーがあります "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI " Syntax error in SQL statement "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI "; SQL statement: CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci [42000-190] Location : db/migration/V1__hoge.sql (/Users/niwashun/Workspaces/hogemoge/target/dev/scala-2.11/classes/db/migration/V1__hoge.sql) Line : 1 Statement : CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

      at org.flywaydb.core.internal.dbsupport.SqlScript.execute()
    2. ${project.artifactId}
      TransactionTemplate.execute
      1. org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
      2. org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
      3. org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284)
      4. org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282)
      5. org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      6. org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282)
      7. org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
      8. org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
      9. org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
      10. org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      10 frames