Advertisement
Guest User

Untitled

a guest
Jul 28th, 2016
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. #Datasource
  2. spring.datasource.url=jdbc:h2:mem:testDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE;DATABASE_TO_UPPER=true
  3. spring.datasource.username=
  4. spring.datasource.password=
  5. spring.datasource.driver-class-name=org.h2.Driver
  6. spring.datasource.default-transaction-isolation-level=1
  7.  
  8. CREATE TABLE `file_storage` (
  9. `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
  10. `file_name` VARCHAR(45) NULL,
  11. PRIMARY KEY (`id`))
  12. DEFAULT CHARACTER SET = utf8;
  13.  
  14. Execution failed for task ':dbschema:flywayMigrate'.
  15. > Error occurred while executing flywayMigrate
  16.  
  17. Migration V2016_02_26_12_59__create_file_storage.sql failed
  18. -----------------------------------------------------------
  19. SQL State : 42000
  20. Error Code : 42000
  21. Message : Syntax error in SQL statement "CREATE TABLE ""FILE_STORAGE"" (
  22. ""ID"" BIGINT(64) NOT NULL AUTO_INCREMENT,
  23. ""FILE_NAME"" VARCHAR(45) NULL,
  24. PRIMARY KEY (""ID""))
  25. DEFAULT CHARACTER[*] SET = UTF8 "; SQL statement:
  26. CREATE TABLE `file_storage` (
  27. `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
  28. `file_name` VARCHAR(45) NULL,
  29. PRIMARY KEY (`id`))
  30. DEFAULT CHARACTER SET = utf8 [42000-190]
  31. Location : db/migration/V2016_02_26_12_59__create_file_storage.sql (/Users/yzzhao/dev/cooltoo/cooltoo_backend/dbschema/build/resources/main/db/migration/V2016_02_26_12_59__create_file_storage.sql)
  32. Line : 1
  33. Statement : CREATE TABLE `file_storage` (
  34. `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
  35. `file_name` VARCHAR(45) NULL,
  36. PRIMARY KEY (`id`))
  37. DEFAULT CHARACTER SET = utf8
  38.  
  39. Syntax error in SQL statement "CREATE TABLE ""FILE_STORAGE"" (
  40. ""ID"" BIGINT(64) NOT NULL AUTO_INCREMENT,
  41. ""FILE_NAME"" VARCHAR(45) NULL,
  42. PRIMARY KEY (""ID""))
  43. DEFAULT CHARACTER[*] SET = UTF8 "; SQL statement:
  44. CREATE TABLE `file_storage` (
  45. `id` BIGINT(64) NOT NULL AUTO_INCREMENT,
  46. `file_name` VARCHAR(45) NULL,
  47. PRIMARY KEY (`id`))
  48. DEFAULT CHARACTER SET = utf8 [42000-190]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement