Unable to get spring boot to automatically create database schema

by

There are several possible causes:

  1. Your entity classes are in the same or in a sub-package relative one where you have you class with @EnableAutoConfiguration. If not then your spring app does not see them and hence will not create anything in db

  2. Check your config, it seems that you are using some hibernate specific options, try to replace them with:

    spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.hibernate.ddl-auto=update
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=test
spring.datasource.password=

**note that the manual loading of the driver class is unnecessary because it’s automatically registered, so don’t bother yourself with it

  1. Your application.properties must be in src/main/resources folder.

If you did not specify dialect correctly it might try to default to bundled together with boot in-memory database and (as it was with me) I could see that it tries to connect to local HSQL (see console output) instance and fail at updating the schema.

More Related Contents:

  1. How can I log SQL statements in Spring Boot?
  2. Spring Boot – Handle to Hibernate SessionFactory
  3. No Dialect mapping for JDBC type: 1111
  4. No serializer found for class org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor
  5. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  6. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  7. How to use Spring Boot with MySQL database and JPA?
  8. How to setup Hibernate to read/write to different datasources?
  9. What is the proper way to re-attach detached objects in Hibernate?
  10. Using Hibernate’s ScrollableResults to slowly read 90 million records
  11. Spring Boot Multiple Datasource
  12. Annotation @Transactional. How to rollback?
  13. How to set up default schema name in JPA configuration?
  14. How do I tell Spring Boot which main class to use for the executable jar?
  15. Spring Boot Actuator application won’t start on Ubuntu VPS
  16. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  17. Spring Boot with redirecting with single page angular2
  18. Spring, Hibernate, Blob lazy loading
  19. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  20. Difference between save and saveAndFlush in Spring data jpa
  21. The onFlushDirty Hibernate Interceptor method is never called
  22. How do I run a spring boot executable jar in a Production environment?
  23. spring data jpa @query and pageable
  24. How do I create beans programmatically in Spring Boot?
  25. Spring Boot access static resources missing scr/main/resources
  26. bootstrap.yml configuration not processed anymore with Spring Cloud 2020.0
  27. How to modify request body before reaching controller in spring boot
  28. Spring Boot – Reading Text File using ResourceLoader
  29. hibernate two tables per one entity
  30. Array with UserType in Hibernate and PostgreSQL –> MappingException

Leave a Comment