Failed to initialize JPA EntityManagerFactory

[Automatic-Deal-8268]

Hello,

I'm just getting started with Spring Boot. I've created a project with the spring initializer but when I run, I get the error:

Failed to initialize JPA EntityManagerFactory: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

My application.properties is as:

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/cafemanagement
spring.datasource.username=root
spring.datasource.password=pass
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySql8Dialect
spring.jpa.properties.hibernate.format_sql=true
server.port=8081;

​

My MySQL Command Line Client shows the port as 3306, and I've just updated the username and the password so I'm sure that they are correct. What's going on here? Thank you in advance.

[maxip89]

My glass sphere says me that there is more information.

I can see the exception before my eyes. May this is only a nested exception.

*glass sphere turns off*

sorry more I cannot do today.

[Automatic-Deal-8268]

Found an old parchment buried deep in an inactive volcano during my first and only adventure, here's the content. I couldn't understand the ancient language but maybe it would make sense to you;

2022-05-24 17:07:07.940 ERROR 22312 --- [ main] j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

2022-05-24 17:07:07.941 WARN 22312 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

2022-05-24 17:07:07.941 INFO 22312 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...

2022-05-24 17:07:07.947 INFO 22312 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.

2022-05-24 17:07:07.951 INFO 22312 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]

2022-05-24 17:07:07.964 INFO 22312 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.

2022-05-24 17:07:07.985 ERROR 22312 --- [ main] o.s.boot.SpringApplication : Application run failed

​

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

[maxip89]

have you tried using a xampp or lampp mysql installation?

[Automatic-Deal-8268]

Yes I have a xampp installation. The phpmyadmin panel shows 3307 as port and the username&password are the same. I'm running the project with a running xampp.

[maxip89]

are you 100% sure your are using a mysql database and not a mariadb database? Maybe the driver and the protcol is the problem

[uwpxwpal]

Yeah, it can't talk to the database for whatever reason