cami-la/academia-digital

Projeto de LAB: Conhendo o projeto Spring data JPA com Java na prática

academia-digital's Issues

SQLIntegrityConstraintViolationException ao tentar implementar o delete

Olá Camila, Boa tarde! Estou tendo dificuldades ao implementar o método delete na entidade Aluno, fico recebendo essa Exception que está no título.

Na classe AlunoServiceImpl, coloquei o seguinte método:

	@Override
	public void delete(Long id) {
	//	Aluno aluno = repository.findById(id).get();
	//	repository.deleteById(aluno.getId());
		repository.deleteById(id);
	}

Na classe AlunoController:

	@DeleteMapping("/{id}")
	public void delete(@PathVariable Long id) {
		service.delete(id);
	}

Daí, no Postman, ao fazer uma requisição com método DELETE, ocorre a seguinte saída:

{
    "timestamp": "2022-08-18T19:54:28.367+00:00",
    "status": 500,
    "error": "Internal Server Error",
    "path": "/alunos/1"
}

e a saída no console:

Hibernate: 
    select
        aluno0_.id as id1_0_0_,
        aluno0_.bairro as bairro2_0_0_,
        aluno0_.cpf as cpf3_0_0_,
        aluno0_.data_de_nascimento as data_de_4_0_0_,
        aluno0_.nome as nome5_0_0_ 
    from
        tb_alunos aluno0_ 
    where
        aluno0_.id=?
2022-08-18 17:15:10.366 TRACE 16260 --- [p-nio-80-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [1]
2022-08-18 17:15:10.380 TRACE 16260 --- [p-nio-80-exec-4] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([bairro2_0_0_] : [VARCHAR]) - [Ceilândia]
2022-08-18 17:15:10.380 TRACE 16260 --- [p-nio-80-exec-4] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([cpf3_0_0_] : [VARCHAR]) - [454.953.730-22]
2022-08-18 17:15:10.382 TRACE 16260 --- [p-nio-80-exec-4] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([data_de_4_0_0_] : [DATE]) - [1975-07-14]
2022-08-18 17:15:10.382 TRACE 16260 --- [p-nio-80-exec-4] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([nome5_0_0_] : [VARCHAR]) - [Pedro Pettigrew Two]
2022-08-18 17:15:10.386 TRACE 16260 --- [p-nio-80-exec-4] org.hibernate.type.CollectionType        : Created collection wrapper: [me.dio.academiadigital.entity.Aluno.avaliacoes#1]
Hibernate: 
    delete 
    from
        tb_alunos 
    where
        id=?
2022-08-18 17:15:10.399 TRACE 16260 --- [p-nio-80-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [1]
2022-08-18 17:15:10.409  WARN 16260 --- [p-nio-80-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1451, SQLState: 23000
2022-08-18 17:15:10.409 ERROR 16260 --- [p-nio-80-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper   : Cannot delete or update a parent row: a foreign key constraint fails (`academia`.`tb_matriculas`, CONSTRAINT `FKl73aqabid14pcakkq2w5631jl` FOREIGN KEY (`aluno_id`) REFERENCES `tb_alunos` (`id`))
2022-08-18 17:15:10.410  INFO 16260 --- [p-nio-80-exec-4] o.h.e.j.b.internal.AbstractBatchImpl     : HHH000010: On release of batch it still contained JDBC statements
2022-08-18 17:15:10.441 ERROR 16260 --- [p-nio-80-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause

java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`academia`.`tb_matriculas`, CONSTRAINT `FKl73aqabid14pcakkq2w5631jl` FOREIGN KEY (`aluno_id`) REFERENCES `tb_alunos` (`id`))
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-4.0.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3698) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3958) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:123) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:721) ~[na:na]
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:489) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3290) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2425) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:449) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.6.10.Final.jar:5.6.10.Final]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:562) ~[spring-orm-5.3.22.jar:5.3.22]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.3.22.jar:5.3.22]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.3.22.jar:5.3.22]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:654) ~[spring-tx-5.3.22.jar:5.3.22]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:407) ~[spring-tx-5.3.22.jar:5.3.22]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.22.jar:5.3.22]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.22.jar:5.3.22]
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.22.jar:5.3.22]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.22.jar:5.3.22]
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:174) ~[spring-data-jpa-2.7.2.jar:2.7.2]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.22.jar:5.3.22]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.22.jar:5.3.22]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.22.jar:5.3.22]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.22.jar:5.3.22]
	at jdk.proxy2/jdk.proxy2.$Proxy112.deleteById(Unknown Source) ~[na:na]
	at me.dio.academiadigital.service.impl.AlunoServiceImpl.delete(AlunoServiceImpl.java:70) ~[classes/:na]
	at me.dio.academiadigital.controller.AlunoController.delete(AlunoController.java:52) ~[classes/:na]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:577) ~[na:na]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.22.jar:5.3.22]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkServlet.java:931) ~[spring-webmvc-5.3.22.jar:5.3.22]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) ~[tomcat-embed-core-9.0.65.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.22.jar:5.3.22]

push no git

Boa noite. Clonei o projeto e não estou conseguindo comitar nem subir para o meu repositorio.

vc pode me ajudar?

Erro com o postgress

estou com esse errro e não estou conseguindo resolver
org.postgresql.util.PSQLException: O servidor pediu autenticação baseada em senha, mas nenhuma senha foi fornecida.
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:643) ~[postgresql-42.3.1.jar:42.3.1]
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:163) ~[postgresql-42.3.1.jar:42.3.1]
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:215) ~[postgresql-42.3.1.jar:42.3.1]
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) ~[postgresql-42.3.1.jar:42.3.1]
at org.postgresql.jdbc.PgConnection.(PgConnection.java:225) ~[postgresql-42.3.1.jar:42.3.1]
at org.postgresql.Driver.makeConnection(Driver.java:466) ~[postgresql-42.3.1.jar:42.3.1]

Obrigado

Camila, boa tarde.
Obrigado pela atenção
o erro estava na minha cara e eu não enxergava.
compilei, deu certo.

obg.

Duvidas no projeto academia

Olá, cami tudo bem?
me chamo Moisés, nesse projeto da academia, não consegui compilar pois apresentou estes erros, comparei com os seus no video, e baixei sem falha do GitHub também. não consigo identificar este erro. Por favor me ajude

aguardo retorno..

Olá, Camila tudo bem? preciso sua ajuda

Olá, Camila estou no curso Python Developer com professor Guilherme e me deparei com um desafio que há mais uma semana não consigo chegar aos valores de validação do desafio...Seria possivel vc verificar onde estou errando.. é o desafio: "Aproveite a Oferta"
segue código abaixo;

T = int(input())

for _ in range(T):
N, K = map(int, input().split())
garrafas_compradas = N
garrafas_totais = N

while garrafas_compradas >= K:
garrafas_trocadas = garrafas_compradas // K
garrafas_totais += garrafas_trocadas
garrafas_compradas = garrafas_trocadas + (garrafas_compradas % K)

print(garrafas_totais)

Agradeço sua atenção.

problemas para configurar o projeto para Mysql

Estou tentandoi configurar o projeto para o Mysql mudando o aplication.properties:

server.port=8080
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/academia?useTimezone=true&serverTimezone=UTC
useTimezone=true&serverTimezone=UTC
spring.datasource.username= ****
spring.datasource.password=*******
spring.jpa.hibernate.ddl-auto=update

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true

e adicionei a dependencia no pom:

mysql
mysql-connector-java
runtime

mas aparece o seguinte erro:
Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': Unsatisfied dependency expressed through constructor parameter 0...

tentei todas as possibilidades possíveis do Stack mas nada surtiu efeito
Alguém, por favor, tem a solução?

Exclusão de avaliações

Olá Camila, tudo bem com você?
Estou finalizando o projeto final, acertando alguns detalhes. Acredito que encontrei um probleminha no seu código.
Ao implementar métodos 'delete', percebi que ao excluir uma avaliação física, o Aluno correspondente também era excluído.
Isso ocorre por causa do elemento 'cascade= CascadeType.ALL' na anotação @manytoone, da entidade AvaliacaoFisica.
Retirei esse elemento e o coloquei na anotação @OneToMany da entidade Aluno. Assim, sempre que um aluno é excluído do banco suas avaliações também são.
Parabéns pelas aulas, sua didática é muito boa e esclareceu muita coisa pra mim sobre o Spring!

Campos na tabela

Boa tarde Camila!!!
Estou replicando passo a passo seu projeto
e pintou uma duvida que não achei nos fontes.
Porque nos fontes esta "dataDeNascimento"
e no banco ficou "data_de_nascimento"

Abraços!!!

Inserir img

Estou montando um API de livros e gostaria de saber como adicionar a imagem, tenho testado algumas opções mas não estou resolvendo. Usando Spring boot, MySQL, jpa...

Problemas com projetos Springboot

Boa tarde, tudo bem, Camila?!
Meu computador não roda os projetos Springboot, durante os cursos nenhum funcionou, o mesmo aconteceu com o s
eu. No IntelliJ não consigo criar classes, não roda, todos os arquivos aparecem com seus nomes em vermelho e um relógio na frente. No cmd aparece um erro de plugin do maven que não consigo solução, já virei o Stackoverflow de cabeça para baixo, mas nada que responderam arrumou.
Alguma ideia para me ajudar?

erro.pdf

Postman Erro

Olá Camila! Tudo bem?
Não consigo passar informações no Postman como executado na aula.
Em criar aluno quando eu passo as informações em json no body o meu retorno é que a mídia não é compatível.
Tem como me ajudar?

Populando tabela

Olá Camila, tudo bom?
Quando estou cadastrando os alunos na tabela, ela está retornando "null", no campo dataDeNascimento.
{
"id": 7,
"nome": "Maria",
"cpf": "222.222,22-14",
"bairro": "Centro",
"dataDeNascimento": null
}

Por que está retornando assim? Na entity Aluno, esse campo esta certinho, dataDeNascimento está como LocalDate. Teria como me ajudar? Gratidão!!

Configuração do banco de dados

Olá Camila!!!
Mulher, me socorre! O problema não são suas aulas, vc é ótima, mas não consegui configurar o banco de dados, então, ainda não tenho a real noção de como está o projeto. Não sei se é algo com o Postgres...eu uso Windows. Ainda vou ter que corrigir alguns erros que estão aparecendo, mas resolvi subir logo o projeto no GitHub, para caso vc queira dar uma olhada. Desde já agradeço!

Erro de incompatibilidade

academia-digital/src/main/java/me/dio/academia/digital/service/impl/MatriculaServiceImpl.java

Line 30 in 0b7dfb5

return matriculaRepository.save(matricula);

Esta dando erro de incompatibilidade em meu codigo nessa linha.

Erro utilizando mysql

Oi Cami preciso de uma ajudinha para integrar o IntelliJ com o MySQL.
Eu mudei as configurações no pom.xml:

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
</dependency>

E mudei no arquivo application.yml:

server:
  port: 8080
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/academia?useTimezone=true&serverTimezone=UTC&useLegacyDate
    username: tami
    password: root
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: create-drop
    properties:
      hibernate.format_sql: true

Mas quando rodo a aplicação aparece essa mensagem de erro:

java.sql.SQLException: Access denied for user 'tami'@'localhost' (using password: YES)

Importar o projeto base

Oi, Cami tudo bem? não consegui achar o link para o dowload do projeto base, para poder da continuidade no projeto, se puder disponibilizar agradeço.

DataBase H2

Olá Camila, tudo bem com vc?

Uma dúvida sobre o banco de dados. Posso entregar o projeto usando o banco de dados H2?
Minha pergunta é devido a nível de estudos para outras pessoas, fica mais fácil sem precisar ter o PGAdmin. Caso não possa tudo bem, não tem problema.

Até breve.

Validaçao Projeto Final

Olá, espero que estejas bem.
Primeiro quero agradecer por suas aulas e sua história. Isso nos incentiva a permanecer no caminho. Obrigado!
Segundo, é que estou fechando o Bootcamp Carrefour com seu projeto sobre Academia (Springboot). Mas tem um erro que não consigo resolver
Poderia ajudar

PS C:\Users\55119\Desktop\Edson\DIO\Bootcamp\academia-digital\desafio-academia-digital> mvn boot-spring:run [INFO] Scanning for projects...
Downloading from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml
Downloading from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-metadata.xml
Downloaded from central: https://repo.maven.apache.org/maven2/org/apache/maven/plugins/maven-metadata.xml (14 kB at 13 kB/s)
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml (20 kB at 19 kB/s)
[INFO] Total time: 3.193 s
[INFO] Finished at: 2022-05-11T23:56:24-03:00
[INFO] ------------------------------------------------------------------------
[ERROR] No plugin found for prefix 'boot-spring' in the current project and in the plugin groups [org.apache.maven.plugins, org.codehaus.mojo] available from the repositories [local (C:\Users\55119.m2\repository), central (https://repo.maven.apache.org/maven2)] -> [Help 1]
Downloaded from central: https://repo.maven.apache.org/maven2/org/codehaus/mojo/maven-metadata.xml (20 kB at 20 kB/s)[INFO] ------------------------------------------------------------------------[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1.778 s
[INFO] Finished at: 2022-05-11T23:58:05-03:00
[INFO] ------------------------------------------------------------------------
[ERROR] No plugin found for prefix 'boot-spring' in the current project and in the plugin groups [org.apache.maven.plugins, org.codehaus.mojo] available from the repositories [local (C:\Users\55119.m2\repository), central (https://repo.maven.apache.org/maven2)] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/NoPluginFoundForPrefixException

Download das Collections

Olá Camila, tudo bem?

Ótimas aulas e conhecimento, parabéns.

Tem como eu fazer o download das Collections que você usou no Postman?

Grato
Abs

Usando Instant

Bom dia Camila, tudo bem? Posso dar uma sugestão? Utiliza Instant no caso de datas, a manipulação dessa classe é bem mais tranquila que a LocalDate, eu baixei o seu projeto (to fazendo o bootcamp Banco Pan da Dio) e fiz alguma alterações e usei essa classe, nos filtros de parâmetros data, pra não complicar, usei formato de data mais amigável, mas o mapeamento é tranquilo. Eu expandi um pouco os conceitos aprendidos, usei o modelmappper para fazer o mapeamento dos DTOs, criei novas queries JPQL (queria que a URL aceitasse múltiplos parâmetros de filtro e o código ligasse e desligasse os filtros de acordo).

Tive alguma dificuldade com entidades One2One principalmente em relação as queries de DTOs mais simples, pois ele insistia em fazer select das outras entidades não mapeadas no DTO (por uma questão de desempenho, não queria que ele fizesse isso), depois descobri que isso é inerente do JPA uma vez que ele não sabe se a entidade deve ou não retornar null para esses atributos, ele popula obrigatoriamente e só desliga os selects desnecessários com _optional_ = _false_. Esse artigo aqui explica bem o assunto:
https://thorben-janssen.com/hibernate-tip-lazy-loading-one-to-one/

O insert de entidades com relação OneToOne também tem pegadinha sendo que vc tem que fazer "de trás para frente"´. O link desse usuário no S.O. me ajudou a entender a mecânica do processo.
https://stackoverflow.com/a/75829592/11985623

Brinquei um pouco com Enums no JPA também, nesse caso o único problema que não consegui resolver é como desligar o filtro para um parâmetro que é mapeado como Enum, por exemplo, se for data e uso um filtro data_final e data_inicial é só botar como valores defaults datas com 200 anos para frente e 200 anos para trás que ele busca tudo. Mas enum não deixa acontecer, os valores tem que estar contidos dentro do domínio definido Enum. A minha solução foi meio malandropz, acabei fazendo overloading da chamada do método na camada repository e criei uma combinação de queries. Mas acredito que não seja a solução mais elegante, ainda pesquisando o assunto.

Também criei uma estrutura para lidar com os Exceptions de uma forma mais amigável para o front-end. Próximo passo seria implementar security com OAuth2/JWT e rotas habilitadas por role de usuário, mas fica para um próxima pois o bootcamp está terminando. De qualquer forma valeu o curso, vc é uma das melhores instrutoras deste Bootcamp.

Bom se vc quiser dar uma olhadinha no código, esta no meu repo no git aqui:

/rgiovann/dio-desafio-spring-jpa-academia

Problemas com Spring Framework

Boa noite pessoal.

Toda vez que vou subir a minha aplicação está dando esse erro, em qualquer porta que tento usar.

Já tentei algumas formas de resolver, mas não consegui.

Alguém poderia me ajudar?

mensagem de erro

Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.

Sat Aug 06 00:29:07 BRT 2022

There was an unexpected error (type=Not Found, status=404).

Dúvidas sobre as Interfaces na camada de Serviço

Oi Camila, tudo bem?
Na camada de serviço, eu vi que você criou as interfaces e depois fez a implementação delas.
Você fez isso apenas para demonstrar o uso do JavaDoc ou se esta é uma prática comum nas empresas de software?
Esse tipo de implementação traz alguma vantagem ao desenvolvimento, além da documentação?
Desde já agradeço o retorno. Gosto muito das suas aulas. Um abraço.

Validação Projeto Final

Olá!

Estou tentando realizar a validação do meu código, mas não estou conseguindo utilizar a anotação @Valid.

Segue o Código:

@PostMapping
public Aluno create(@Valid @requestbody AlunoForm form){
return service.create(form);
}

Quando utilizo o @Valid e tento realizar o POST, em aluno, ocorre um erro 500 no Postman.

Contudo, é só retirar o @Valid que o código roda normal e aceita o POST.

Acredito que seja um erro na configuração, mas, se alguém tiver alguma pista, agradeço demais.

obs: estou com a dependência strater validation no POM. e utilizando, no form, as anotações: @SiZe, @past e outros, mas nenhum funciona, exceto o Past. O Past roda o erro 400 no postman, mas o resto só o erro 500.

Estou codando no VS code.

Tomcat não roda ao dar o run

Ao rodar o projeto no intellij o tomcat não roda

segue os logs

"C:\Program Files\Java\zulu11.56.19-ca-jdk11.0.15-win_x64\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2022.1.1\lib\idea_rt.jar=49905:C:\Program Files\JetBrains\IntelliJ IDEA 2022.1.1\bin" -Dfile.encoding=UTF-8 -classpath "C:\Users\Danie.m2\repository\org\junit\platform\junit-platform-launcher\1.8.1\junit-platform-launcher-1.8.1.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2022.1.1\lib\idea_rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2022.1.1\plugins\junit\lib\junit5-rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2022.1.1\plugins\junit\lib\junit-rt.jar;C:\Users\Danie\Desktop\dioGit\dio-springData_Jpa_JAVA\academia-digital\target\test-classes;C:\Users\Danie\Desktop\dioGit\dio-springData_Jpa_JAVA\academia-digital\target\classes;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-data-jpa\2.6.1\spring-boot-starter-data-jpa-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-aop\2.6.1\spring-boot-starter-aop-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\spring-aop\5.3.13\spring-aop-5.3.13.jar;C:\Users\Danie.m2\repository\org\aspectj\aspectjweaver\1.9.7\aspectjweaver-1.9.7.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.6.1\spring-boot-starter-jdbc-2.6.1.jar;C:\Users\Danie.m2\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;C:\Users\Danie.m2\repository\org\springframework\spring-jdbc\5.3.13\spring-jdbc-5.3.13.jar;C:\Users\Danie.m2\repository\jakarta\transaction\jakarta.transaction-api\1.3.3\jakarta.transaction-api-1.3.3.jar;C:\Users\Danie.m2\repository\jakarta\persistence\jakarta.persistence-api\2.2.3\jakarta.persistence-api-2.2.3.jar;C:\Users\Danie.m2\repository\org\hibernate\hibernate-core\5.6.1.Final\hibernate-core-5.6.1.Final.jar;C:\Users\Danie.m2\repository\org\jboss\logging\jboss-logging\3.4.2.Final\jboss-logging-3.4.2.Final.jar;C:\Users\Danie.m2\repository\net\bytebuddy\byte-buddy\1.11.22\byte-buddy-1.11.22.jar;C:\Users\Danie.m2\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;C:\Users\Danie.m2\repository\org\jboss\jandex\2.2.3.Final\jandex-2.2.3.Final.jar;C:\Users\Danie.m2\repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;C:\Users\Danie.m2\repository\org\hibernate\common\hibernate-commons-annotations\5.1.2.Final\hibernate-commons-annotations-5.1.2.Final.jar;C:\Users\Danie.m2\repository\org\glassfish\jaxb\jaxb-runtime\2.3.5\jaxb-runtime-2.3.5.jar;C:\Users\Danie.m2\repository\org\glassfish\jaxb\txw2\2.3.5\txw2-2.3.5.jar;C:\Users\Danie.m2\repository\com\sun\istack\istack-commons-runtime\3.0.12\istack-commons-runtime-3.0.12.jar;C:\Users\Danie.m2\repository\com\sun\activation\jakarta.activation\1.2.2\jakarta.activation-1.2.2.jar;C:\Users\Danie.m2\repository\org\springframework\data\spring-data-jpa\2.6.0\spring-data-jpa-2.6.0.jar;C:\Users\Danie.m2\repository\org\springframework\data\spring-data-commons\2.6.0\spring-data-commons-2.6.0.jar;C:\Users\Danie.m2\repository\org\springframework\spring-orm\5.3.13\spring-orm-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-context\5.3.13\spring-context-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-tx\5.3.13\spring-tx-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-beans\5.3.13\spring-beans-5.3.13.jar;C:\Users\Danie.m2\repository\org\slf4j\slf4j-api\1.7.32\slf4j-api-1.7.32.jar;C:\Users\Danie.m2\repository\org\springframework\spring-aspects\5.3.13\spring-aspects-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-validation\2.6.1\spring-boot-starter-validation-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter\2.6.1\spring-boot-starter-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot\2.6.1\spring-boot-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.6.1\spring-boot-autoconfigure-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.6.1\spring-boot-starter-logging-2.6.1.jar;C:\Users\Danie.m2\repository\ch\qos\logback\logback-classic\1.2.7\logback-classic-1.2.7.jar;C:\Users\Danie.m2\repository\ch\qos\logback\logback-core\1.2.7\logback-core-1.2.7.jar;C:\Users\Danie.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.14.1\log4j-to-slf4j-2.14.1.jar;C:\Users\Danie.m2\repository\org\apache\logging\log4j\log4j-api\2.14.1\log4j-api-2.14.1.jar;C:\Users\Danie.m2\repository\org\slf4j\jul-to-slf4j\1.7.32\jul-to-slf4j-1.7.32.jar;C:\Users\Danie.m2\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Users\Danie.m2\repository\org\yaml\snakeyaml\1.29\snakeyaml-1.29.jar;C:\Users\Danie.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.55\tomcat-embed-el-9.0.55.jar;C:\Users\Danie.m2\repository\org\hibernate\validator\hibernate-validator\6.2.0.Final\hibernate-validator-6.2.0.Final.jar;C:\Users\Danie.m2\repository\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-web\2.6.1\spring-boot-starter-web-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-json\2.6.1\spring-boot-starter-json-2.6.1.jar;C:\Users\Danie.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.13.0\jackson-databind-2.13.0.jar;C:\Users\Danie.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.0\jackson-annotations-2.13.0.jar;C:\Users\Danie.m2\repository\com\fasterxml\jackson\core\jackson-core\2.13.0\jackson-core-2.13.0.jar;C:\Users\Danie.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.0\jackson-datatype-jdk8-2.13.0.jar;C:\Users\Danie.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.0\jackson-datatype-jsr310-2.13.0.jar;C:\Users\Danie.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.0\jackson-module-parameter-names-2.13.0.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.6.1\spring-boot-starter-tomcat-2.6.1.jar;C:\Users\Danie.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.55\tomcat-embed-core-9.0.55.jar;C:\Users\Danie.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.55\tomcat-embed-websocket-9.0.55.jar;C:\Users\Danie.m2\repository\org\springframework\spring-web\5.3.13\spring-web-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-webmvc\5.3.13\spring-webmvc-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-expression\5.3.13\spring-expression-5.3.13.jar;C:\Users\Danie.m2\repository\org\postgresql\postgresql\42.3.1\postgresql-42.3.1.jar;C:\Users\Danie.m2\repository\org\checkerframework\checker-qual\3.5.0\checker-qual-3.5.0.jar;C:\Users\Danie.m2\repository\org\projectlombok\lombok\1.18.22\lombok-1.18.22.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-starter-test\2.6.1\spring-boot-starter-test-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-test\2.6.1\spring-boot-test-2.6.1.jar;C:\Users\Danie.m2\repository\org\springframework\boot\spring-boot-test-autoconfigure\2.6.1\spring-boot-test-autoconfigure-2.6.1.jar;C:\Users\Danie.m2\repository\com\jayway\jsonpath\json-path\2.6.0\json-path-2.6.0.jar;C:\Users\Danie.m2\repository\net\minidev\json-smart\2.4.7\json-smart-2.4.7.jar;C:\Users\Danie.m2\repository\net\minidev\accessors-smart\2.4.7\accessors-smart-2.4.7.jar;C:\Users\Danie.m2\repository\org\ow2\asm\asm\9.1\asm-9.1.jar;C:\Users\Danie.m2\repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;C:\Users\Danie.m2\repository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;C:\Users\Danie.m2\repository\org\assertj\assertj-core\3.21.0\assertj-core-3.21.0.jar;C:\Users\Danie.m2\repository\org\hamcrest\hamcrest\2.2\hamcrest-2.2.jar;C:\Users\Danie.m2\repository\org\junit\jupiter\junit-jupiter\5.8.1\junit-jupiter-5.8.1.jar;C:\Users\Danie.m2\repository\org\junit\jupiter\junit-jupiter-api\5.8.1\junit-jupiter-api-5.8.1.jar;C:\Users\Danie.m2\repository\org\opentest4j\opentest4j\1.2.0\opentest4j-1.2.0.jar;C:\Users\Danie.m2\repository\org\junit\platform\junit-platform-commons\1.8.1\junit-platform-commons-1.8.1.jar;C:\Users\Danie.m2\repository\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar;C:\Users\Danie.m2\repository\org\junit\jupiter\junit-jupiter-params\5.8.1\junit-jupiter-params-5.8.1.jar;C:\Users\Danie.m2\repository\org\junit\jupiter\junit-jupiter-engine\5.8.1\junit-jupiter-engine-5.8.1.jar;C:\Users\Danie.m2\repository\org\junit\platform\junit-platform-engine\1.8.1\junit-platform-engine-1.8.1.jar;C:\Users\Danie.m2\repository\org\mockito\mockito-core\4.0.0\mockito-core-4.0.0.jar;C:\Users\Danie.m2\repository\net\bytebuddy\byte-buddy-agent\1.11.22\byte-buddy-agent-1.11.22.jar;C:\Users\Danie.m2\repository\org\objenesis\objenesis\3.2\objenesis-3.2.jar;C:\Users\Danie.m2\repository\org\mockito\mockito-junit-jupiter\4.0.0\mockito-junit-jupiter-4.0.0.jar;C:\Users\Danie.m2\repository\org\skyscreamer\jsonassert\1.5.0\jsonassert-1.5.0.jar;C:\Users\Danie.m2\repository\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;C:\Users\Danie.m2\repository\org\springframework\spring-core\5.3.13\spring-core-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-jcl\5.3.13\spring-jcl-5.3.13.jar;C:\Users\Danie.m2\repository\org\springframework\spring-test\5.3.13\spring-test-5.3.13.jar;C:\Users\Danie.m2\repository\org\xmlunit\xmlunit-core\2.8.3\xmlunit-core-2.8.3.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit5 @w@C:\Users\Danie\AppData\Local\Temp\idea_working_dirs_junit.tmp @C:\Users\Danie\AppData\Local\Temp\idea_junit.tmp -socket49904
21:09:00.306 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate]
21:09:00.340 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)]
21:09:00.452 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [me.dio.academia.digital.AcademiaDigitalApplicationTests] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper]
21:09:00.489 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [me.dio.academia.digital.AcademiaDigitalApplicationTests], using SpringBootContextLoader
21:09:00.502 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [me.dio.academia.digital.AcademiaDigitalApplicationTests]: class path resource [me/dio/academia/digital/AcademiaDigitalApplicationTests-context.xml] does not exist
21:09:00.504 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [me.dio.academia.digital.AcademiaDigitalApplicationTests]: class path resource [me/dio/academia/digital/AcademiaDigitalApplicationTestsContext.groovy] does not exist
21:09:00.504 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [me.dio.academia.digital.AcademiaDigitalApplicationTests]: no resource found for suffixes {-context.xml, Context.groovy}.
21:09:00.506 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [me.dio.academia.digital.AcademiaDigitalApplicationTests]: AcademiaDigitalApplicationTests does not declare any static, non-private, non-final, nested classes annotated with @configuration.
21:09:00.740 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [me.dio.academia.digital.AcademiaDigitalApplicationTests]
21:09:01.066 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [C:\Users\Danie\Desktop\dioGit\dio-springData_Jpa_JAVA\academia-digital\target\classes\me\dio\academia\digital\AcademiaDigitalApplication.class]
21:09:01.068 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration me.dio.academia.digital.AcademiaDigitalApplication for test class me.dio.academia.digital.AcademiaDigitalApplicationTests
21:09:01.483 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [me.dio.academia.digital.AcademiaDigitalApplicationTests]: using defaults.
21:09:01.484 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.event.ApplicationEventsTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.test.context.event.EventPublishingTestExecutionListener]
21:09:01.541 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@3382f8ae, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@60641ec8, org.springframework.test.context.event.ApplicationEventsTestExecutionListener@75f65e45, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@6eeade6c, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@4a891c97, org.springframework.test.context.support.DirtiesContextTestExecutionListener@a5bd950, org.springframework.test.context.transaction.TransactionalTestExecutionListener@4d18aa28, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@75390459, org.springframework.test.context.event.EventPublishingTestExecutionListener@7756c3cd, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@2313052e, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@2bd2b28e, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@16746061, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@57fd91c9, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@6cfcd46d, org.springframework.boot.test.autoconfigure.webservices.client.MockWebServiceServerTestExecutionListener@52045dbe]
21:09:01.552 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@4febb875 testClass = AcademiaDigitalApplicationTests, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@25e2a451 testClass = AcademiaDigitalApplicationTests, locations = '{}', classes = '{class me.dio.academia.digital.AcademiaDigitalApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@125290e5, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@616ac46a, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@1f75a668, org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@5e403b4a, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@1672fe87, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@1283bb96], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true]], class annotated with @DirtiesContext [false] with mode [null].
21:09:01.816 [main] DEBUG org.springframework.boot.ApplicationServletEnvironment - Activating profiles []
21:09:01.818 [main] DEBUG org.springframework.test.context.support.TestPropertySourceUtils - Adding inlined properties to environment: {spring.jmx.enabled=false, org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}

. ____ _ __ _ _
/\ / ' __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ' / ` | \ \ \
\/ )| |)| | | | | || (| | ) ) ) )
' || .__|| ||| |_, | / / / /
=========||==============|/=////
:: Spring Boot :: (v2.6.1)

2022-05-13 21:09:03.234 INFO 1224 --- [ main] m.d.a.d.AcademiaDigitalApplicationTests : Starting AcademiaDigitalApplicationTests using Java 11.0.15 on DESKTOP-5NR9Q7I with PID 1224 (started by Danie in C:\Users\Danie\Desktop\dioGit\dio-springData_Jpa_JAVA\academia-digital)
2022-05-13 21:09:03.240 INFO 1224 --- [ main] m.d.a.d.AcademiaDigitalApplicationTests : No active profile set, falling back to default profiles: default
2022-05-13 21:09:06.612 INFO 1224 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-05-13 21:09:06.819 INFO 1224 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 178 ms. Found 3 JPA repository interfaces.
2022-05-13 21:09:08.528 INFO 1224 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2022-05-13 21:09:08.705 INFO 1224 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.6.1.Final
2022-05-13 21:09:09.259 INFO 1224 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2022-05-13 21:09:10.159 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration boolean -> org.hibernate.type.BooleanType@3b435211
2022-05-13 21:09:10.159 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration boolean -> org.hibernate.type.BooleanType@3b435211
2022-05-13 21:09:10.160 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Boolean -> org.hibernate.type.BooleanType@3b435211
2022-05-13 21:09:10.163 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration numeric_boolean -> org.hibernate.type.NumericBooleanType@6b162ecc
2022-05-13 21:09:10.165 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration true_false -> org.hibernate.type.TrueFalseType@69ed5ea2
2022-05-13 21:09:10.166 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration yes_no -> org.hibernate.type.YesNoType@551be9f6
2022-05-13 21:09:10.170 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration byte -> org.hibernate.type.ByteType@3c28e5b6
2022-05-13 21:09:10.170 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration byte -> org.hibernate.type.ByteType@3c28e5b6
2022-05-13 21:09:10.170 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Byte -> org.hibernate.type.ByteType@3c28e5b6
2022-05-13 21:09:10.173 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration character -> org.hibernate.type.CharacterType@2dff7085
2022-05-13 21:09:10.173 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration char -> org.hibernate.type.CharacterType@2dff7085
2022-05-13 21:09:10.174 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Character -> org.hibernate.type.CharacterType@2dff7085
2022-05-13 21:09:10.179 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration short -> org.hibernate.type.ShortType@5db3d57c
2022-05-13 21:09:10.179 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration short -> org.hibernate.type.ShortType@5db3d57c
2022-05-13 21:09:10.180 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Short -> org.hibernate.type.ShortType@5db3d57c
2022-05-13 21:09:10.184 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration integer -> org.hibernate.type.IntegerType@65eb3597
2022-05-13 21:09:10.184 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration int -> org.hibernate.type.IntegerType@65eb3597
2022-05-13 21:09:10.184 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Integer -> org.hibernate.type.IntegerType@65eb3597
2022-05-13 21:09:10.188 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration long -> org.hibernate.type.LongType@5a14e60d
2022-05-13 21:09:10.188 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration long -> org.hibernate.type.LongType@5a14e60d
2022-05-13 21:09:10.189 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Long -> org.hibernate.type.LongType@5a14e60d
2022-05-13 21:09:10.192 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration float -> org.hibernate.type.FloatType@22d477c2
2022-05-13 21:09:10.192 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration float -> org.hibernate.type.FloatType@22d477c2
2022-05-13 21:09:10.193 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Float -> org.hibernate.type.FloatType@22d477c2
2022-05-13 21:09:10.197 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration double -> org.hibernate.type.DoubleType@6df4af5
2022-05-13 21:09:10.198 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration double -> org.hibernate.type.DoubleType@6df4af5
2022-05-13 21:09:10.199 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Double -> org.hibernate.type.DoubleType@6df4af5
2022-05-13 21:09:10.202 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration big_decimal -> org.hibernate.type.BigDecimalType@17c0274c
2022-05-13 21:09:10.202 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.math.BigDecimal -> org.hibernate.type.BigDecimalType@17c0274c
2022-05-13 21:09:10.205 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration big_integer -> org.hibernate.type.BigIntegerType@7e5efcab
2022-05-13 21:09:10.205 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.math.BigInteger -> org.hibernate.type.BigIntegerType@7e5efcab
2022-05-13 21:09:10.208 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration string -> org.hibernate.type.StringType@1efac5b9
2022-05-13 21:09:10.209 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.String -> org.hibernate.type.StringType@1efac5b9
2022-05-13 21:09:10.213 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration nstring -> org.hibernate.type.StringNVarcharType@8c0a23f
2022-05-13 21:09:10.216 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration ncharacter -> org.hibernate.type.CharacterNCharType@10f405ff
2022-05-13 21:09:10.220 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration url -> org.hibernate.type.UrlType@291a4791
2022-05-13 21:09:10.220 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.net.URL -> org.hibernate.type.UrlType@291a4791
2022-05-13 21:09:10.223 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Duration -> org.hibernate.type.DurationType@bb3ecfe
2022-05-13 21:09:10.223 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.Duration -> org.hibernate.type.DurationType@bb3ecfe
2022-05-13 21:09:10.226 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Instant -> org.hibernate.type.InstantType@582e9152
2022-05-13 21:09:10.227 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.Instant -> org.hibernate.type.InstantType@582e9152
2022-05-13 21:09:10.231 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalDateTime -> org.hibernate.type.LocalDateTimeType@60b5e80d
2022-05-13 21:09:10.231 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalDateTime -> org.hibernate.type.LocalDateTimeType@60b5e80d
2022-05-13 21:09:10.234 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalDate -> org.hibernate.type.LocalDateType@78e68401
2022-05-13 21:09:10.235 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalDate -> org.hibernate.type.LocalDateType@78e68401
2022-05-13 21:09:10.237 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration LocalTime -> org.hibernate.type.LocalTimeType@3312f4f4
2022-05-13 21:09:10.238 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.LocalTime -> org.hibernate.type.LocalTimeType@3312f4f4
2022-05-13 21:09:10.241 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@5c4cc644
2022-05-13 21:09:10.241 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.OffsetDateTime -> org.hibernate.type.OffsetDateTimeType@5c4cc644
2022-05-13 21:09:10.247 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration OffsetTime -> org.hibernate.type.OffsetTimeType@706f6d26
2022-05-13 21:09:10.249 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.OffsetTime -> org.hibernate.type.OffsetTimeType@706f6d26
2022-05-13 21:09:10.253 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@4aed311e
2022-05-13 21:09:10.254 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.time.ZonedDateTime -> org.hibernate.type.ZonedDateTimeType@4aed311e
2022-05-13 21:09:10.258 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration date -> org.hibernate.type.DateType@1e3f86d5
2022-05-13 21:09:10.258 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Date -> org.hibernate.type.DateType@1e3f86d5
2022-05-13 21:09:10.261 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration time -> org.hibernate.type.TimeType@5287ba5f
2022-05-13 21:09:10.262 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Time -> org.hibernate.type.TimeType@5287ba5f
2022-05-13 21:09:10.265 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration timestamp -> org.hibernate.type.TimestampType@4be490da
2022-05-13 21:09:10.265 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Timestamp -> org.hibernate.type.TimestampType@4be490da
2022-05-13 21:09:10.266 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Date -> org.hibernate.type.TimestampType@4be490da
2022-05-13 21:09:10.271 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration dbtimestamp -> org.hibernate.type.DbTimestampType@7a65c995
2022-05-13 21:09:10.274 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar -> org.hibernate.type.CalendarType@6424e613
2022-05-13 21:09:10.275 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Calendar -> org.hibernate.type.CalendarType@6424e613
2022-05-13 21:09:10.275 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.GregorianCalendar -> org.hibernate.type.CalendarType@6424e613
2022-05-13 21:09:10.278 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar_date -> org.hibernate.type.CalendarDateType@24a0c58b
2022-05-13 21:09:10.282 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration calendar_time -> org.hibernate.type.CalendarTimeType@4a62062a
2022-05-13 21:09:10.284 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration locale -> org.hibernate.type.LocaleType@2c9d90fc
2022-05-13 21:09:10.285 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Locale -> org.hibernate.type.LocaleType@2c9d90fc
2022-05-13 21:09:10.287 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration currency -> org.hibernate.type.CurrencyType@2bab618
2022-05-13 21:09:10.288 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.Currency -> org.hibernate.type.CurrencyType@2bab618
2022-05-13 21:09:10.290 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration timezone -> org.hibernate.type.TimeZoneType@6c9b44bf
2022-05-13 21:09:10.291 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.TimeZone -> org.hibernate.type.TimeZoneType@6c9b44bf
2022-05-13 21:09:10.294 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration class -> org.hibernate.type.ClassType@1e40fbb3
2022-05-13 21:09:10.294 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Class -> org.hibernate.type.ClassType@1e40fbb3
2022-05-13 21:09:10.297 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration uuid-binary -> org.hibernate.type.UUIDBinaryType@39023dbf
2022-05-13 21:09:10.298 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.UUID -> org.hibernate.type.UUIDBinaryType@39023dbf
2022-05-13 21:09:10.299 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration uuid-char -> org.hibernate.type.UUIDCharType@1ee5632d
2022-05-13 21:09:10.303 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration binary -> org.hibernate.type.BinaryType@634f58d2
2022-05-13 21:09:10.303 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration byte[] -> org.hibernate.type.BinaryType@634f58d2
2022-05-13 21:09:10.303 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [B -> org.hibernate.type.BinaryType@634f58d2
2022-05-13 21:09:10.306 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration wrapper-binary -> org.hibernate.type.WrapperBinaryType@281b2dfd
2022-05-13 21:09:10.306 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Byte[] -> org.hibernate.type.WrapperBinaryType@281b2dfd
2022-05-13 21:09:10.306 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [Ljava.lang.Byte; -> org.hibernate.type.WrapperBinaryType@281b2dfd
2022-05-13 21:09:10.311 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration row_version -> org.hibernate.type.RowVersionType@2db86a7c
2022-05-13 21:09:10.313 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration image -> org.hibernate.type.ImageType@391d1e33
2022-05-13 21:09:10.316 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration characters -> org.hibernate.type.CharArrayType@3fde2209
2022-05-13 21:09:10.316 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration char[] -> org.hibernate.type.CharArrayType@3fde2209
2022-05-13 21:09:10.316 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [C -> org.hibernate.type.CharArrayType@3fde2209
2022-05-13 21:09:10.319 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration wrapper-characters -> org.hibernate.type.CharacterArrayType@1e226bcd
2022-05-13 21:09:10.320 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration [Ljava.lang.Character; -> org.hibernate.type.CharacterArrayType@1e226bcd
2022-05-13 21:09:10.320 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration Character[] -> org.hibernate.type.CharacterArrayType@1e226bcd
2022-05-13 21:09:10.321 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration text -> org.hibernate.type.TextType@38732364
2022-05-13 21:09:10.323 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration ntext -> org.hibernate.type.NTextType@4ef18604
2022-05-13 21:09:10.328 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration blob -> org.hibernate.type.BlobType@4f1afe8f
2022-05-13 21:09:10.329 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Blob -> org.hibernate.type.BlobType@4f1afe8f
2022-05-13 21:09:10.331 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_blob -> org.hibernate.type.MaterializedBlobType@752b69e3
2022-05-13 21:09:10.335 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration clob -> org.hibernate.type.ClobType@65da01f4
2022-05-13 21:09:10.335 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.Clob -> org.hibernate.type.ClobType@65da01f4
2022-05-13 21:09:10.340 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration nclob -> org.hibernate.type.NClobType@637c840d
2022-05-13 21:09:10.340 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.sql.NClob -> org.hibernate.type.NClobType@637c840d
2022-05-13 21:09:10.341 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_clob -> org.hibernate.type.MaterializedClobType@7ccd611e
2022-05-13 21:09:10.343 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration materialized_nclob -> org.hibernate.type.MaterializedNClobType@640d604
2022-05-13 21:09:10.347 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration serializable -> org.hibernate.type.SerializableType@256bb5be
2022-05-13 21:09:10.358 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration object -> org.hibernate.type.ObjectType@11f23038
2022-05-13 21:09:10.359 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.lang.Object -> org.hibernate.type.ObjectType@11f23038
2022-05-13 21:09:10.361 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_date -> org.hibernate.type.AdaptedImmutableType@5c8d58ed
2022-05-13 21:09:10.362 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_time -> org.hibernate.type.AdaptedImmutableType@6a567f7b
2022-05-13 21:09:10.362 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_timestamp -> org.hibernate.type.AdaptedImmutableType@28be7fec
2022-05-13 21:09:10.363 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_dbtimestamp -> org.hibernate.type.AdaptedImmutableType@26f0141
2022-05-13 21:09:10.364 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_calendar -> org.hibernate.type.AdaptedImmutableType@34136bd1
2022-05-13 21:09:10.364 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_calendar_date -> org.hibernate.type.AdaptedImmutableType@6de7778f
2022-05-13 21:09:10.364 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_binary -> org.hibernate.type.AdaptedImmutableType@367d34c0
2022-05-13 21:09:10.364 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration imm_serializable -> org.hibernate.type.AdaptedImmutableType@4ce25e47
2022-05-13 21:09:10.657 INFO 1224 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2022-05-13 21:09:11.151 INFO 1224 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2022-05-13 21:09:11.286 INFO 1224 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL10Dialect
2022-05-13 21:09:11.436 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration pg-uuid -> org.hibernate.type.PostgresUUIDType@32e5af53
2022-05-13 21:09:11.438 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : Adding type registration java.util.UUID -> org.hibernate.type.PostgresUUIDType@32e5af53
2022-05-13 21:09:11.438 DEBUG 1224 --- [ main] org.hibernate.type.BasicTypeRegistry : HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@39023dbf
2022-05-13 21:09:11.447 DEBUG 1224 --- [ main] o.h.type.spi.TypeConfiguration$Scope : Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@1e191150] to MetadataBuildingContext [org.hibernate.boot.internal.MetadataBuildingContextRootImpl@2fbd390]
2022-05-13 21:09:12.569 DEBUG 1224 --- [ main] o.h.type.spi.TypeConfiguration$Scope : Scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration@1e191150] to SessionFactoryImpl [org.hibernate.internal.SessionFactoryImpl@61dd1c3d]
2022-05-13 21:09:14.135 INFO 1224 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-05-13 21:09:14.159 TRACE 1224 --- [ main] o.h.type.spi.TypeConfiguration$Scope : Handling #sessionFactoryCreated from [org.hibernate.internal.SessionFactoryImpl@61dd1c3d] for TypeConfiguration
2022-05-13 21:09:14.163 INFO 1224 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2022-05-13 21:09:16.267 WARN 1224 --- [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2022-05-13 21:09:18.312 INFO 1224 --- [ main] m.d.a.d.AcademiaDigitalApplicationTests : Started AcademiaDigitalApplicationTests in 16.49 seconds (JVM running for 22.324)
2022-05-13 21:09:18.829 INFO 1224 --- [ionShutdownHook] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2022-05-13 21:09:18.830 TRACE 1224 --- [ionShutdownHook] o.h.type.spi.TypeConfiguration$Scope : Handling #sessionFactoryClosed from [org.hibernate.internal.SessionFactoryImpl@61dd1c3d] for TypeConfiguration
2022-05-13 21:09:18.830 DEBUG 1224 --- [ionShutdownHook] o.h.type.spi.TypeConfiguration$Scope : Un-scoping TypeConfiguration [org.hibernate.type.spi.TypeConfiguration$Scope@19248e50] from SessionFactory [org.hibernate.internal.SessionFactoryImpl@61dd1c3d]
2022-05-13 21:09:18.835 INFO 1224 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2022-05-13 21:09:18.855 INFO 1224 --- [ionShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.

Process finished with exit code 0

lombok

Oi Cami! td bem?

Achei tão legal diminuir o tamanho do código com o lombok! mas aqui fica dando como se tivesse erro nas classes do service, apesar de rodar normalmente. To usando o java 17.

erro não cria minhas tabelas

Olá, agradeço Camila sua orientação referente a class aluno, consegui compilar, mas após seguir e verificar se o foram criado as tabelas
tb_aluno, tb_avaliações, tb_matriculas elas não constm no BD, a pasta academia foi criada, mas suas tabelas não.
estive verificando que nas class constam esses sublinhado e marcados de escuros na criação, conforme foto anexa. Voçê conseguiria me ajudar novamente.

essas mesma restrição acontece nas class avaliações e matriculas.

Postman

Oi Camila, tudo bem?

Olha, adoro as suas aulas! Acho vc e Felipe Aguiar os melhores instrutores da DIO!

Agora eu empaquei numa dificuldade no seu video "CROODs Parte 1", da aula "Conhecendo Spring Data JPA na prática com Java".

Já no final do video você mostra que preparou um Postman com os métodos configurados para popular as tabelas do banco de dados.

O problema é que essa ferramenta não foi apresentada e não entendi se a gente deve usar ela ou não.

O que preciso fazer?

• Configurar nosso próprio Postman com os métodos (como)?
• Conectar com a sua coleção no Postman (não consegui encontrar)?
• Seguir sem usar o Postman?

Agradeço se puder esclarecer.

Onde vejo as aulas?

Boa noite. Sou aluno DIO GLOBAL e gostaria de assistir as suas aulas referentes a esse projeto. Você poderia me indicar onde encontro?
Grato.

JSON parse error

Olá, quando eu tento rodar o código e fazer uma requisição para criar um novo aluno no Postman, aparece a seguinte mensagem:
JSON parse error: Text '07/07/2000' could not be parsed at index 10]

Eu tentei de várias formas descobrir porque da esses erros e até colocando essas anotações acima da variável dataNascimento pra ver se a serialização e deserialização funcionariam, mas o erro persiste:

@Column(name = "data_nascimento")
@JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "dd/MM/yyyy")
@JsonDeserialize(using = LocalDateDeserializer.class)
@JsonSerialize(using = LocalDateSerializer.class)
private LocalDate dataNascimento

Classes diretamente sendo importadas do pacote infra.jackson
Você poderia me ajudar?

Configuração do Banco de Dados - DIO

Bom dia, tudo bem?
Pois bem, estou fazendo o projeto pela Dio (Bootcamp Web Developer do Carrefour), fiz o dowload do PostgreSQL, como manda o site oficial e afins, seguindo as suas aulas, na configuração de banco de dados e na criação do mesmo, fiz de acordo com os seus comandos, porém, claro, alterei o usuário e a senha, pois bem, ao criar, diz que o meu usuário não tem "role", como faço para consertar isso? Mesmo colocando o "cami" como usuário e o "root" como senha, não dá certo.

Aguardo.

Segue anexo class aluno

Boa tarde,
Obg pela atenção, segue anexo