Não estou conseguindo rodar o jar do projeto | React parte 1: componentes reutilizáveis para sua webapp

4
respostas

por Bruno Pires Oliveira

| 364.3k xp | 6 posts

Desenvolvedor

Já fiz a configuração do MySQL, porém ainda não consigo rodar o jar do projeto, segue erro.

2019-04-23 13:11:50.109  INFO 12328 --- [           main] org.hibernate.tool.hbm2ddl.SchemaUpdate  : HHH000232: Schema update complete
2019-04-23 13:11:50.685  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerAdapter : Looking for @ControllerAdvice: org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@d1fda3: startup date [Tue Apr 23 13:11:45 BRT 2019]; root of context hierarchy
2019-04-23 13:11:50.782  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/api/autores],methods=[GET],produces=[application/json]}" onto public java.lang.Iterable<br.com.caelum.cdcreact.models.Autor> br.com.caelum.cdcreact.controllers.AutorController.lista()
2019-04-23 13:11:50.785  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/api/autores],methods=[POST],consumes=[application/json]}" onto public java.lang.Iterable<br.com.caelum.cdcreact.models.Autor> br.com.caelum.cdcreact.controllers.AutorController.salva(br.com.caelum.cdcreact.controllers.forms.AutorForm)
2019-04-23 13:11:50.786  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/api/livros],methods=[GET],produces=[application/json]}" onto public java.lang.Iterable<br.com.caelum.cdcreact.models.Livro> br.com.caelum.cdcreact.controllers.LivrosController.lista()
2019-04-23 13:11:50.786  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/api/livros],methods=[POST],consumes=[application/json]}" onto public java.lang.Iterable<br.com.caelum.cdcreact.models.Livro> br.com.caelum.cdcreact.controllers.LivrosController.salva(br.com.caelum.cdcreact.controllers.forms.LivroForm)
2019-04-23 13:11:50.795  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
2019-04-23 13:11:50.796  INFO 12328 --- [           main] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
2019-04-23 13:11:50.853  INFO 12328 --- [           main] o.s.w.s.handler.SimpleUrlHandlerMapping  : Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2019-04-23 13:11:50.853  INFO 12328 --- [           main] o.s.w.s.handler.SimpleUrlHandlerMapping  : Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2019-04-23 13:11:50.903  INFO 12328 --- [           main] o.s.w.s.handler.SimpleUrlHandlerMapping  : Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2019-04-23 13:11:51.125  INFO 12328 --- [           main] o.s.j.e.a.AnnotationMBeanExporter        : Registering beans for JMX exposure on startup
2019-04-23 13:11:51.200  INFO 12328 --- [           main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat started on port(s): 8080 (http)
2019-04-23 13:11:51.206  INFO 12328 --- [           main] br.com.caelum.cdcreact.Boot              : Started Boot in 6.645 seconds (JVM running for 7.146)
2019-04-23 13:12:18.862  INFO 12328 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring FrameworkServlet 'dispatcherServlet'
2019-04-23 13:12:18.862  INFO 12328 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : FrameworkServlet 'dispatcherServlet': initialization started
2019-04-23 13:12:18.896  INFO 12328 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : FrameworkServlet 'dispatcherServlet': initialization completed in 32 ms

4 respostas

por Felipe Moreno Borges

| 1130.9k xp | 1471 posts

Instrutor Desenvolvedor Android/iOS

23/04/2019

Bruno, boa tarde!

Primeiro precisamos verificar duas coisas:

Versão do MySQL;
Versão do Java

Para verificar a versão do MySQL:

mysql -u root;

O retorno vai ser parecido com isso:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 29
(VERSÃO 5.7.25)------> Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Para verificar a versão do Java

java -version

O retorno vai ser parecido com isso

(VERSÃO 1.8.0)------> openjdk version "1.8.0_191"
OpenJDK Runtime Environment (build 1.8.0_191-8u191-b12-2ubuntu0.18.04.1-b12)
OpenJDK 64-Bit Server VM (build 25.191-b12, mixed mode)

Depois de verificar se ambos estão nas versões corretas você irá precisar ver como qual é o plugin usado no seu user root, usando o código:

sudo mysql -u root

mysql> USE mysql;
mysql> SELECT User, Host, plugin FROM mysql.user;

O retorno vai ser assim:

+------------------+-----------------------+
| User             | plugin                |
+------------------+-----------------------+
| root             | auth_socket           |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+

Caso na linha do root esteja escrito: auth_socket também, rodar os códigos abaixo:

sudo mysql -u root 

mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ service mysql restart

Depois disso só entrar na pasta do arquivo .jar e rodar o código:

java -jar nomeDoArquivo.jar

Qualquer dúvida ou diferença só falar

Espero ter ajudado e bons estudos!

por Bruno Pires Oliveira

| 364.3k xp | 6 posts

Desenvolvedor

23/04/2019

Retorno MySql

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 34
Server version: 10.1.26-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Retorno Java

java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) Client VM (build 25.171-b11, mixed mode, sharing)

Plugin MySql

MariaDB [(none)]> USE mysql
Database changed
MariaDB [mysql]> SELECT User, Host, plugin FROM mysql.user;
+-------+-----------+-----------------------+
| User  | Host      | plugin                |
+-------+-----------+-----------------------+
| root  | localhost | mysql_native_password |
| root  | 127.0.0.1 | mysql_native_password |
| root  | ::1       | mysql_native_password |
|       | localhost |                       |
| pma   | localhost |                       |
| maico | localhost |                       |
+-------+-----------+-----------------------+
6 rows in set (0.00 sec)

por Felipe Nascimento

| 481k xp | 657 posts

Instrutor

23/04/2019

Oi Bruno tudo bem ?

Uma coisa que eu notei é que você está usando o mariadbe para rodar o .jar precisamos do mysql5.7

Depois de rodar o comando java -jar cdcreact-1.0.0-SNAPSHOT.jar e acessar o localhost você obteve algum erro ?

por Bruno Pires Oliveira

| 364.3k xp | 6 posts

Desenvolvedor

23/04/2019

Oi Felipe, tudo bem sim.

Então, vou desinstalar o MariaDB e ir de Mysql se for o caso.

Respondendo a tua dúvida, quando acesso o localhost me retorna apenas "[]" sem valor nenhum.