Hibernate/JPA DB Schema Generation Best Practices

by

  1. It’s always recommended to generate the schema manually, preferably by a tool supporting database schema revisions, such as the great Liquibase. Generating the schema from the entities is great in theory, but were fragile in practice and causes lots of problems in the long run(trust me on this).

  2. In productions it’s always best to have manually generated and review the schema.

  3. You make an update to an entity and create a matching update script(revision) to update your database schema to reflect the entity change. You can create a custom solution(I’ve written a few) or use something more popular like liquibase(it even supports schema changes rollbacks). If you’re using a build tool such as maven or ant – it’s recommend to plug the db schema update util into the build process so that fresh builds stay in sync with the schema.

More Related Contents:

  1. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  2. Difference between FetchType LAZY and EAGER in Java Persistence API?
  3. How to map an entity field whose name is a reserved word in JPA
  4. Why is Hibernate Open Session in View considered a bad practice?
  5. What’s the difference between JPA and Hibernate? [closed]
  6. How to convert a Hibernate proxy to a real entity object
  7. What is the solution for the N+1 issue in JPA and Hibernate?
  8. JPA CascadeType.ALL does not delete orphans
  9. Wrong ordering in generated table in jpa
  10. Configure hibernate (using JPA) to store Y/N for type Boolean instead of 0/1
  11. what is @JoinColumn and how it is used in Hibernate
  12. In which case do you use the JPA @JoinTable annotation?
  13. How can I get the session object if I have the entity-manager?
  14. No Dialect mapping for JDBC type: 1111
  15. Hibernate one-to-one: getId() without fetching entire object
  16. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  17. Hibernate: Where do insertable = false, updatable = false belong in composite primary key constellations involving foreign keys?
  18. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  19. Have JPA/Hibernate to replicate the “ON DELETE SET NULL” functionality
  20. Doing an “IN” query with Hibernate
  21. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  22. @Id @GeneratedValue but set own ID value
  23. Difference between save and saveAndFlush in Spring data jpa
  24. Inherited abstract class with JPA (+Hibernate)
  25. The onFlushDirty Hibernate Interceptor method is never called
  26. spring data jpa @query and pageable
  27. org.hibernate.MappingException: Could not determine type for: java.util.Set [duplicate]
  28. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  29. Why hibernate generates insert and update for OneToMany mapping
  30. How to map one class with multiple tables in Hibernate/javax.persistance?

Leave a Comment