API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 8th, 2017
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.18 KB | None | 0 0
raw download clone embed print report
  1. spring.jpa.database=POSTGRESQL
  2. spring.datasource.url=jdbc:postgresql://localhost/wine
  3. spring.datasource.username=postgres
  4. spring.datasource.password=root
  5.  
  6. spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
  7. spring.jpa.show-sql=true
  8.  
  9.  
  10.  
  11.  
  12. . ____ _ __ _ _
  13. /\ / ___'_ __ _ _(_)_ __ __ _
  14. ( ( )___ | '_ | '_| | '_ / _` |
  15. \/ ___)| |_)| | | | | || (_| | ) ) ) )
  16. ' |____| .__|_| |_|_| |___, | / / / /
  17. =========|_|==============|___/=/_/_/_/
  18. :: Spring Boot :: (v1.3.6.RELEASE)
  19.  
  20. 2016-08-08 13:42:53.337 INFO 6572 --- [ restartedMain] com.algaworks.wine.WineApplication : Starting WineApplication on Manoel with PID 6572 (C:CURSOSspring-boot-template-projeto-mastertargetclasses started by Manoel in C:CURSOSspring-boot-template-projeto-master)
  21. 2016-08-08 13:42:53.346 INFO 6572 --- [ restartedMain] com.algaworks.wine.WineApplication : No active profile set, falling back to default profiles: default
  22. 2016-08-08 13:42:53.847 INFO 6572 --- [ restartedMain] ationConfigEmbeddedWebApplicationContext : Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@e66d742: startup date [Mon Aug 08 13:42:53 GMT-03:00 2016]; root of context hierarchy
  23. 2016-08-08 13:42:58.029 INFO 6572 --- [ restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [class org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$417efcb6] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  24. 2016-08-08 13:42:59.087 INFO 6572 --- [ restartedMain] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 8080 (http)
  25. 2016-08-08 13:42:59.113 INFO 6572 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service Tomcat
  26. 2016-08-08 13:42:59.116 INFO 6572 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet Engine: Apache Tomcat/8.0.36
  27. 2016-08-08 13:42:59.418 INFO 6572 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
  28. 2016-08-08 13:42:59.418 INFO 6572 --- [ost-startStop-1] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 5582 ms
  29. 2016-08-08 13:43:00.313 INFO 6572 --- [ost-startStop-1] o.s.b.c.e.ServletRegistrationBean : Mapping servlet: 'dispatcherServlet' to [/]
  30. 2016-08-08 13:43:00.319 INFO 6572 --- [ost-startStop-1] o.s.b.c.embedded.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' to: [/*]
  31. 2016-08-08 13:43:00.320 INFO 6572 --- [ost-startStop-1] o.s.b.c.embedded.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' to: [/*]
  32. 2016-08-08 13:43:00.320 INFO 6572 --- [ost-startStop-1] o.s.b.c.embedded.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' to: [/*]
  33. 2016-08-08 13:43:00.320 INFO 6572 --- [ost-startStop-1] o.s.b.c.embedded.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: [/*]
  34. 2016-08-08 13:43:00.860 INFO 6572 --- [ restartedMain] o.f.core.internal.util.VersionPrinter : Flyway 3.2.1 by Boxfuse
  35. 2016-08-08 13:43:03.081 INFO 6572 --- [ restartedMain] o.f.c.i.dbsupport.DbSupportFactory : Database: jdbc:postgresql://localhost/wine (PostgreSQL 9.4)
  36. 2016-08-08 13:43:03.185 INFO 6572 --- [ restartedMain] o.f.core.internal.command.DbValidate : Validated 1 migration (execution time 00:00.038s)
  37. 2016-08-08 13:43:03.238 INFO 6572 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Current version of schema "public": << Empty Schema >>
  38. 2016-08-08 13:43:03.239 INFO 6572 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migrating schema "public" to version 01 - criar tabela vinho
  39. 2016-08-08 13:43:03.262 ERROR 6572 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migration of schema "public" to version 01 failed! Changes successfully rolled back.
  40. 2016-08-08 13:43:03.266 WARN 6572 --- [ restartedMain] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  41. Migration V01__criar_tabela_vinho.sql failed
  42. --------------------------------------------
  43. SQL State : 42601
  44. Error Code : 0
  45. Message : ERROR: syntax error at or near "("
  46. Posição: 36
  47. Location : db/migration/V01__criar_tabela_vinho.sql (C:CURSOSspring-boot-template-projeto-mastertargetclassesdbmigrationV01__criar_tabela_vinho.sql)
  48. Line : 1
  49. Statement : CREATE TABLE vinho (
  50. codigo BIGINT(20) PRIMARY KEY AUTO_INCREMENT,
  51. nome VARCHAR(50) NOT NULL,
  52. tipo VARCHAR(50) NOT NULL,
  53. safra INT NOT NULL,
  54. volume INT NOT NULL,
  55. valor DECIMAL (10,2) NOT NULL
  56.  
  57. )ENGINE=InnoDB DEFAULT CHARSET=utf8
  58.  
  59. 2016-08-08 13:43:03.297 INFO 6572 --- [ restartedMain] o.apache.catalina.core.StandardService : Stopping service Tomcat
  60. 2016-08-08 13:43:03.324 ERROR 6572 --- [ restartedMain] o.s.boot.SpringApplication : Application startup failed
  61.  
  62. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  63. Migration V01__criar_tabela_vinho.sql failed
  64. --------------------------------------------
  65. SQL State : 42601
  66. Error Code : 0
  67. Message : ERROR: syntax error at or near "("
  68. Posição: 36
  69. Location : db/migration/V01__criar_tabela_vinho.sql (C:CURSOSspring-boot-template-projeto-mastertargetclassesdbmigrationV01__criar_tabela_vinho.sql)
  70. Line : 1
  71. Statement : CREATE TABLE vinho (
  72. codigo BIGINT(20) PRIMARY KEY AUTO_INCREMENT,
  73. nome VARCHAR(50) NOT NULL,
  74. tipo VARCHAR(50) NOT NULL,
  75. safra INT NOT NULL,
  76. volume INT NOT NULL,
  77. valor DECIMAL (10,2) NOT NULL
  78.  
  79. )ENGINE=InnoDB DEFAULT CHARSET=utf8
  80.  
  81. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  82. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  83. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  84. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  85. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  86. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  87. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  88. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  89. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  90. at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1054) ~[spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  91. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:829) ~[spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  92. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538) ~[spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  93. at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118) ~[spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  94. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:760) [spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  95. at org.springframework.boot.SpringApplication.createAndRefreshContext(SpringApplication.java:360) [spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  96. at org.springframework.boot.SpringApplication.run(SpringApplication.java:306) [spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  97. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1185) [spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  98. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1174) [spring-boot-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  99. at com.algaworks.wine.WineApplication.main(WineApplication.java:10) [classes/:na]
  100. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_51]
  101. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_51]
  102. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_51]
  103. at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_51]
  104. at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  105. Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
  106. Migration V01__criar_tabela_vinho.sql failed
  107. --------------------------------------------
  108. SQL State : 42601
  109. Error Code : 0
  110. Message : ERROR: syntax error at or near "("
  111. Posição: 36
  112. Location : db/migration/V01__criar_tabela_vinho.sql (C:CURSOSspring-boot-template-projeto-mastertargetclassesdbmigrationV01__criar_tabela_vinho.sql)
  113. Line : 1
  114. Statement : CREATE TABLE vinho (
  115. codigo BIGINT(20) PRIMARY KEY AUTO_INCREMENT,
  116. nome VARCHAR(50) NOT NULL,
  117. tipo VARCHAR(50) NOT NULL,
  118. safra INT NOT NULL,
  119. volume INT NOT NULL,
  120. valor DECIMAL (10,2) NOT NULL
  121.  
  122. )ENGINE=InnoDB DEFAULT CHARSET=utf8
  123.  
  124. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117) ~[flyway-core-3.2.1.jar:na]
  125. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71) ~[flyway-core-3.2.1.jar:na]
  126. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284) ~[flyway-core-3.2.1.jar:na]
  127. at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282) ~[flyway-core-3.2.1.jar:na]
  128. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-3.2.1.jar:na]
  129. at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282) ~[flyway-core-3.2.1.jar:na]
  130. at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) ~[flyway-core-3.2.1.jar:na]
  131. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) ~[flyway-core-3.2.1.jar:na]
  132. at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) ~[flyway-core-3.2.1.jar:na]
  133. at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-3.2.1.jar:na]
  134. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) ~[flyway-core-3.2.1.jar:na]
  135. at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059) ~[flyway-core-3.2.1.jar:na]
  136. at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006) ~[flyway-core-3.2.1.jar:na]
  137. at org.flywaydb.core.Flyway.execute(Flyway.java:1418) ~[flyway-core-3.2.1.jar:na]
  138. at org.flywaydb.core.Flyway.migrate(Flyway.java:1006) ~[flyway-core-3.2.1.jar:na]
  139. at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-1.3.6.RELEASE.jar:1.3.6.RELEASE]
  140. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  141. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574) ~[spring-beans-4.2.7.RELEASE.jar:4.2.7.RELEASE]
  142. ... 23 common frames omitted
  143. Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "("
  144. Posição: 36
  145. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) ~[postgresql-9.4-1200-jdbc41.jar:9.4]
  146. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) ~[postgresql-9.4-1200-jdbc41.jar:9.4]
  147. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.4-1200-jdbc41.jar:9.4]
  148. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) ~[postgresql-9.4-1200-jdbc41.jar:9.4]
  149. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406) ~[postgresql-9.4-1200-jdbc41.jar:9.4]
  150. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398) ~[postgresql-9.4-1200-jdbc41.jar:9.4]
  151. at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238) ~[flyway-core-3.2.1.jar:na]
  152. at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114) ~[flyway-core-3.2.1.jar:na]
  153. ... 40 common frames omitted
  154.  
  155. 2016-08-08 13:43:03.329 INFO 6572 --- [ restartedMain] .b.l.ClasspathLoggingApplicationListener : Application failed to start with classpath: [file:/C:/CURSOS/spring-boot-template-projeto-master/target/classes/]
  156.  
  157. CREATE TABLE vinho
  158. (
  159. codigo serial primary key,
  160. nome VARCHAR(50) NOT NULL,
  161. tipo VARCHAR(50) NOT NULL,
  162. safra integer NOT NULL,
  163. volume integer NOT NULL,
  164. valor NUMERIC (10, 2) NOT NULL
  165. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!