Springboot JPA : Unknown database 'springsecuritysystem'; Unable to build Hibernate SessionFactory;

Question

I am new to JPA and Springboot. I checked and tried solutions from several posts here, however, could not really solve my issue.

When I try to use JPA to connect with my mysql database, it throws Unknown Database 'springsecurity'. I verified my username and password for the db.

I am using mysqlworkbench as rdbms.

application.properties :

spring.datasource.url=jdbc:mysql://localhost:3306/springsecuritysystem
spring.datasource.username=root
spring.datasource.password=password
spring.jpa.hibernate.ddl-auto=update
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

Error thrown :

2021-11-11 23:39:21.993  WARN 72026 --- [           main] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1049, SQLState: 42000
2021-11-11 23:39:21.993 ERROR 72026 --- [           main] o.h.engine.jdbc.spi.SqlExceptionHelper   : Unknown database 'springsecuritysystem'
2021-11-11 23:39:21.999 ERROR 72026 --- [           main] j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to open JDBC Connection for DDL execution
2021-11-11 23:39:22.000  WARN 72026 --- [           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 javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to open JDBC Connection for DDL execution
2021-11-11 23:39:22.001  INFO 72026 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]

Tutorial followed : https://github.com/koushikkothagal/spring-security-jpa

have you created the database/schema (springsecuritysystem)? no -> stackoverflow.com/q/5515745/592355 — xerx593
– xerx593, Commented Nov 11, 2021 at 23:54
I did not create it explicitly thinking springframework will create it by itself, like it does for apache derby. Does it mean, spring doesn't create it for mysql ? — rattlehead
– rattlehead, Commented Nov 12, 2021 at 1:36
cool (you got it)! :-) i deleted the comment because thought it was outdated/wrong ;D;D here the links: stackoverflow.com/a/54336968/592355 , and docs.spring.io/spring-boot/docs/current/reference/html/… — xerx593
– xerx593, Commented Nov 12, 2021 at 1:51

Gowtham Varadharaj · Accepted Answer · 2023-03-09 16:35:50Z

1

Try edit this application.properties:

spring.datasource.url = jdbc:mysql://localhost:3306/springsecuritysystem?createDatabaseIfNotExist=true

There is no existing "springsecuritysystem" schema on mySQL. ?createDatabaseIfNotExist=true this command help's to check if its not exist then it will create a new schema on mySQL

answered Mar 9, 2023 at 16:35

Gowtham Varadharaj

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Springboot JPA : Unknown database 'springsecuritysystem'; Unable to build Hibernate SessionFactory;

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related