How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?

by

Ah, right after I posted this question a section of the spring data docs caught my eye:

73.5 Configure JPA properties In addition all properties in
spring.jpa.properties.* are passed through as normal JPA properties
(with the prefix stripped) when the local EntityManagerFactory is
created.

So, to answer my own question: prefix the javax.persistence properties with spring.jpa.properties:

spring.jpa.properties.javax.persistence.schema-generation.create-source=metadata
spring.jpa.properties.javax.persistence.schema-generation.scripts.action=create
spring.jpa.properties.javax.persistence.schema-generation.scripts.create-target=create.sql

After doing this, the schema file was generated automatically in the project root.

More Related Contents:

  1. How to use Spring managed Hibernate interceptors in Spring Boot?
  2. How to do bulk (multi row) inserts with JpaRepository?
  3. Disable all Database related auto configuration in Spring Boot
  4. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  5. Spring Data JPA – Pass column name and value as parameters
  6. Spring Data JDBC / Spring Data JPA vs Hibernate
  7. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  8. How to properly use findBySomeOtherId not findById in Spring data jpa?
  9. How to maintain bi-directional relationships with Spring Data REST and JPA?
  10. How to access in memory h2 database of one spring boot application from another spring boot application
  11. Spring Data optional parameter in query method
  12. Hibernate field naming issue with Spring Boot (naming strategy)
  13. Filtering data with Spring boot CrudRepository
  14. JPA Uppercase table names
  15. Can’t Autowire @Repository annotated interface in Spring Boot
  16. Configure Jackson to omit lazy-loading attributes in Spring Boot
  17. Delete Not Working with JpaRepository
  18. Spring Boot + JPA2 + Hibernate – enable second level cache
  19. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  20. Apparent connection leak detected with Hikari CP
  21. Missing CrudRepository#findOne method
  22. Best way of handling entities inheritance in Spring Data JPA
  23. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  24. Hibernate: one-to-one lazy loading, optional = false
  25. Spring Data JPA: Query by Example?
  26. How is Hibernate deciding order of update/insert/delete
  27. Configure Multiple MongoDB repositories with Spring Data Mongo
  28. How to work with PGpoint for Geolocation using PostgreSQL?
  29. Hibernate hbm2ddl.auto, possible values, and what they do
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment