2024-08-01 11:07:42 tandt | java.lang.NullPointerException: Cannot invoke “org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(java.sql.SQLException, String)” because the return value of “org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.sqlExceptionHelper()” is null
…
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.697Z ERROR 1 — [tandtrest] [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Communications link failure
2024-08-01 11:07:43 tandt |
2024-08-01 11:07:43 tandt | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.706Z ERROR 1 — [tandtrest] [ main] j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection for DDL execution [Communications link failure
2024-08-01 11:07:43 tandt |
2024-08-01 11:07:43 tandt | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.] [n/a]
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.708Z ERROR 1 — [tandtrest] [ main] o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name ‘jwtAuthenticationFilter’ defined in URL [jar:nested:/app/tandtrest-1.0.0.jar/!BOOT-INF/classes/!/t4sev2/tandtrest/config/JwtAuthenticationFilter.class]: Unsatisfied dependency expressed through constructor parameter 1: Error creating bean with name ‘appConfig’ defined in URL [jar:nested:/app/tandtrest-1.0.0.jar/!BOOT-INF/classes/!/t4sev2/tandtrest/config/AppConfig.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name ‘userRepository’ defined in t4sev2.tandtrest.repo.UserRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Cannot resolve reference to bean ‘jpaSharedEM_entityManagerFactory’ while setting bean property ‘entityManager’
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.737Z INFO 1 — [tandtrest] [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.742Z WARN 1 — [tandtrest] [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization – cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.755Z INFO 1 — [tandtrest] [ main] .s.b.a.l.ConditionEvaluationReportLogger :
2024-08-01 11:07:43 tandt |
2024-08-01 11:07:43 tandt | Error starting ApplicationContext. To display the condition evaluation report re-run your application with ‘debug’ enabled.
2024-08-01 11:07:43 tandt | 2024-08-01T04:07:43.775Z ERROR 1 — [tandtrest] [ main] o.s.boot.SpringApplication : Application run failed
2024-08-01 11:07:43 tandt |
2024-08-01 11:07:43 tandt | org.springframework.context.ApplicationContextException: Unable to start web server
2024-08-01 11:07:43 tandt | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:165) ~[spring-boot-3.2.5.jar!/:3.2.5]
2024-08-01 11:07:43 tandt | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:618) ~[spring-context-6.1.6.jar!/:6.1.6]
2024-08-01 11:07:43 tandt | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.2.5.jar!/:3.2.5]
2024-08-01 11:07:43 tandt | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-3.2.5.jar!/:3.2.5]
2024-08-01 11:07:43 tandt | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) ~[spring-boot-3.2.5.jar!/:3.2.5]
2024-08-01 11:07:43 tandt | at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) ~[spring-boot-3.2.5.jar!/:3.2.5]
2024-08-01 11:07:43 tandt | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-3.2.5.jar!/:3.2.5]
2024-08-01 11:07:43 tandt | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-3.2.5.jar!/:3.2.5]
…
2024-08-01 11:07:43 tandt | Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
…
2024-08-01 11:07:43 tandt | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:805) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
2024-08-01 11:07:43 tandt | … 152 common frames omitted
2024-08-01 11:07:43 tandt | Caused by: java.net.ConnectException: Connection refused
2024-08-01 11:07:43 tandt | at java.base/sun.nio.ch.Net.connect0(Native Method) ~[na:na]
2024-08-01 11:07:43 tandt | at java.base/sun.nio.ch.Net.connect(Net.java:589) ~[na:na]
2024-08-01 11:07:43 tandt | at java.base/sun.nio.ch.Net.connect(Net.java:578) ~[na:na]
2024-08-01 11:07:43 tandt | at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:583) ~[na:na]
2024-08-01 11:07:43 tandt | at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) ~[na:na]
2024-08-01 11:07:43 tandt | at java.base/java.net.Socket.connect(Socket.java:751) ~[na:na]
2024-08-01 11:07:43 tandt | at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
2024-08-01 11:07:43 tandt | at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:62) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
2024-08-01 11:07:43 tandt | … 155 common frames omitted
2024-08-01 11:07:43 tandt |
1970-01-01 07:00:00 tandt exited with code 1

*docker-compose.yml

version: ‘3.8’
services:
tandtdb:
image: mysql:latest
container_name: tandtdb
ports:
– “3306:3306”
networks:
– network-backend
environment:
– MYSQL_DATABASE=tandt
– MYSQL_ROOT_PASSWORD=uR65xvVH1y4FkrxPCqJX1s
volumes:
– tandtdb:/var/lib/mysql

tandtrest:
build:
context: .
dockerfile: Dockerfile
image: tandtrest:1.0.0
container_name: tandt
ports:
– “8080:8080”
networks:
– network-backend
environment:
– SPRING_DATASOURCE_URL=jdbc:mysql://tandtdb:3306/tandt
– MYSQL_USERNAME=root
– MYSQL_PASSWORD=uR65xvVH1y4FkrxPCqJX1s
depends_on:
– tandtdb

networks:
network-backend:
volumes:
tandtdb:

*application.properties

spring.application.name = tandtrest

server.port = 8088

spring.datasource.url = ${SPRING_DATASOURCE_URL:jdbc:mysql://localhost:3306/tandt}
spring.driver.class.name = com.mysql.cj.jdbc.Driver
spring.datasource.username = ${MYSQL_USERNAME:root}
spring.datasource.password = ${MYSQL_PASSWORD:uR65xvVH1y4FkrxPCqJX1s}
spring.jpa.hibernate.ddl-auto = update
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL8Dialect

spring.application.security.jwt.secret-key = 404E635266556A586E3272357538782F413F4428472B4B6250645367566B5970
spring.application.security.jwt.expiration = 86400000
spring.application.security.jwt.refresh-token.expiration = 604800000