API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2018
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.81 KB | None | 0 0
raw download clone embed print report
  1. # ===============================
  2. # = DATA SOURCE
  3. # ===============================
  4.  
  5. # Set here configurations for the database connection
  6.  
  7. # Connection url for the database "netgloo_blog"
  8. spring.datasource.url = jdbc:mysql://localhost:3306/farmacia_da_natureza?useSSL=false
  9.  
  10. spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  11. # Username and senha
  12. spring.datasource.usuario = root
  13. spring.datasource.senha = password
  14. # Keep the connection alive if idle for a long time (needed in production)
  15. spring.datasource.testWhileIdle = true
  16. spring.datasource.validationQuery = SELECT 1
  17.  
  18. # ===============================
  19. # = JPA / HIBERNATE
  20. # ===============================
  21.  
  22. # Use spring.jpa.properties.* for Hibernate native properties (the prefix is
  23. # stripped before adding them to the entity manager).
  24.  
  25. # Show or not log for each sql query
  26. spring.jpa.show-sql = true
  27.  
  28. # Hibernate ddl auto (create, create-drop, update): with "update" the database
  29. # schema will be automatically updated accordingly to java entities found in
  30. # the project update
  31. spring.jpa.hibernate.ddl-auto = drop-and-create
  32.  
  33. # Naming strategy
  34. spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy
  35.  
  36. # Allows Hibernate to generate SQL optimized for a particular DBMS
  37. spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
  38.  
  39. java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
  40. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.24.jar:na]
  41. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) ~[mysql-connector-java-5.1.24.jar:na]
  42. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) ~[mysql-connector-java-5.1.24.jar:na]
  43. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) ~[mysql-connector-java-5.1.24.jar:na]
  44. at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704) ~[mysql-connector-java-5.1.24.jar:na]
  45. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250) ~[mysql-connector-java-5.1.24.jar:na]
  46. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483) ~[mysql-connector-java-5.1.24.jar:na]
  47. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516) ~[mysql-connector-java-5.1.24.jar:na]
  48. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301) ~[mysql-connector-java-5.1.24.jar:na]
  49. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) ~[mysql-connector-java-5.1.24.jar:na]
  50. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.24.jar:na]
  51. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_161]
  52. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_161]
  53. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_161]
  54. at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_161]
  55. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.24.jar:na]
  56. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) ~[mysql-connector-java-5.1.24.jar:na]
  57. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) ~[mysql-connector-java-5.1.24.jar:na]
  58. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) ~[HikariCP-2.7.9.jar:na]
  59. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) ~[HikariCP-2.7.9.jar:na]
  60. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) ~[HikariCP-2.7.9.jar:na]
  61. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) [HikariCP-2.7.9.jar:na]
  62. at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:534) [HikariCP-2.7.9.jar:na]
  63. at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-2.7.9.jar:na]
  64. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-2.7.9.jar:na]
  65. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151) [spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  66. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) [spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  67. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) [spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  68. at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:319) [spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  69. at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:356) [spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  70. at org.springframework.boot.autoconfigure.orm.jpa.DatabaseLookup.getDatabase(DatabaseLookup.java:72) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  71. at org.springframework.boot.autoconfigure.orm.jpa.JpaProperties.determineDatabase(JpaProperties.java:166) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  72. at org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.jpaVendorAdapter(JpaBaseConfiguration.java:111) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  73. at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration$$EnhancerBySpringCGLIB$$30fa9bdb.CGLIB$jpaVendorAdapter$4(<generated>) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  74. at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration$$EnhancerBySpringCGLIB$$30fa9bdb$$FastClassBySpringCGLIB$$cee6bf0e.invoke(<generated>) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  75. at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) [spring-core-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  76. at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:361) [spring-context-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  77. at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration$$EnhancerBySpringCGLIB$$30fa9bdb.jpaVendorAdapter(<generated>) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  78. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_161]
  79. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_161]
  80. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
  81. at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
  82. (...)
  83.  
  84. 2018-07-23 12:32:16.198 WARN 8940 --- [ost-startStop-1] o.s.b.a.orm.jpa.DatabaseLookup : Unable to determine jdbc url from datasource
  85.  
  86. org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
  87. at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:328) ~[spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  88. at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:356) ~[spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  89. at org.springframework.boot.autoconfigure.orm.jpa.DatabaseLookup.getDatabase(DatabaseLookup.java:72) ~[spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  90. at org.springframework.boot.autoconfigure.orm.jpa.JpaProperties.determineDatabase(JpaProperties.java:166) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  91. at org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.jpaVendorAdapter(JpaBaseConfiguration.java:111) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  92. at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration$$EnhancerBySpringCGLIB$$30fa9bdb.CGLIB$jpaVendorAdapter$4(<generated>) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  93. at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration$$EnhancerBySpringCGLIB$$30fa9bdb$$FastClassBySpringCGLIB$$cee6bf0e.invoke(<generated>) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  94. at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) [spring-core-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  95. at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:361) [spring-context-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  96. at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration$$EnhancerBySpringCGLIB$$30fa9bdb.jpaVendorAdapter(<generated>) [spring-boot-autoconfigure-2.0.3.RELEASE.jar:2.0.3.RELEASE]
  97. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_161]
  98. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_161]
  99. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
  100. at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
  101. (...)
  102. Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
  103. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.24.jar:na]
  104. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) ~[mysql-connector-java-5.1.24.jar:na]
  105. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) ~[mysql-connector-java-5.1.24.jar:na]
  106. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) ~[mysql-connector-java-5.1.24.jar:na]
  107. at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704) ~[mysql-connector-java-5.1.24.jar:na]
  108. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250) ~[mysql-connector-java-5.1.24.jar:na]
  109. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2483) ~[mysql-connector-java-5.1.24.jar:na]
  110. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516) ~[mysql-connector-java-5.1.24.jar:na]
  111. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301) ~[mysql-connector-java-5.1.24.jar:na]
  112. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) ~[mysql-connector-java-5.1.24.jar:na]
  113. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.24.jar:na]
  114. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_161]
  115. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_161]
  116. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_161]
  117. at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_161]
  118. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.24.jar:na]
  119. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) ~[mysql-connector-java-5.1.24.jar:na]
  120. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) ~[mysql-connector-java-5.1.24.jar:na]
  121. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) ~[HikariCP-2.7.9.jar:na]
  122. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) ~[HikariCP-2.7.9.jar:na]
  123. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) ~[HikariCP-2.7.9.jar:na]
  124. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) ~[HikariCP-2.7.9.jar:na]
  125. at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:534) ~[HikariCP-2.7.9.jar:na]
  126. at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-2.7.9.jar:na]
  127. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-2.7.9.jar:na]
  128. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151) ~[spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  129. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~[spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  130. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~[spring-jdbc-5.0.7.RELEASE.jar:5.0.7.RELEASE]
  131. ... 121 common frames omitted
  132.  
  133. @SpringBootApplication
  134. public class FarmaciadanaturezaApplication {
  135.  
  136. public static void main(String[] args) {
  137. SpringApplication.run(FarmaciadanaturezaApplication.class, args);
  138. }
  139. }
  140.  
  141. <?xml version="1.0" encoding="UTF-8"?>
  142. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  143. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  144. <modelVersion>4.0.0</modelVersion>
  145.  
  146. <groupId>br.com.jamalxvi</groupId>
  147. <artifactId>farmaciadanatureza</artifactId>
  148. <version>0.0.1-SNAPSHOT</version>
  149. <packaging>jar</packaging>
  150.  
  151. <name>farmaciadanatureza</name>
  152. <description>Demo project for Spring Boot</description>
  153.  
  154. <parent>
  155. <groupId>org.springframework.boot</groupId>
  156. <artifactId>spring-boot-starter-parent</artifactId>
  157. <version>2.0.3.RELEASE</version>
  158. <relativePath/> <!-- lookup parent from repository -->
  159. </parent>
  160.  
  161. <properties>
  162. <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  163. <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  164. <java.version>1.8</java.version>
  165. </properties>
  166.  
  167. <dependencies>
  168. <dependency>
  169. <groupId>org.springframework.boot</groupId>
  170. <artifactId>spring-boot-starter-data-jpa</artifactId>
  171. </dependency>
  172. <dependency>
  173. <groupId>org.springframework.boot</groupId>
  174. <artifactId>spring-boot-starter-security</artifactId>
  175. </dependency>
  176. <dependency>
  177. <groupId>org.springframework.boot</groupId>
  178. <artifactId>spring-boot-starter-web</artifactId>
  179. </dependency>
  180.  
  181. <dependency>
  182. <groupId>org.springframework.boot</groupId>
  183. <artifactId>spring-boot-devtools</artifactId>
  184. <scope>runtime</scope>
  185. </dependency>
  186. <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  187. <dependency>
  188. <groupId>mysql</groupId>
  189. <artifactId>mysql-connector-java</artifactId>
  190. <version>5.1.24</version>
  191. </dependency>
  192.  
  193. <dependency>
  194. <groupId>org.projectlombok</groupId>
  195. <artifactId>lombok</artifactId>
  196. <optional>true</optional>
  197. </dependency>
  198. <dependency>
  199. <groupId>org.springframework.boot</groupId>
  200. <artifactId>spring-boot-starter-test</artifactId>
  201. <scope>test</scope>
  202. </dependency>
  203. <dependency>
  204. <groupId>org.springframework.security</groupId>
  205. <artifactId>spring-security-test</artifactId>
  206. <scope>test</scope>
  207. </dependency>
  208. <dependency>
  209. <groupId>io.jsonwebtoken</groupId>
  210. <artifactId>jjwt</artifactId>
  211. <version>0.9.0</version>
  212. </dependency>
  213. <dependency>
  214. <groupId>joda-time</groupId>
  215. <artifactId>joda-time</artifactId>
  216. </dependency>
  217.  
  218. </dependencies>
  219.  
  220. <build>
  221. <plugins>
  222. <plugin>
  223. <groupId>org.springframework.boot</groupId>
  224. <artifactId>spring-boot-maven-plugin</artifactId>
  225. </plugin>
  226. </plugins>
  227. </build>
  228.  
  229.  
  230. </project>
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!