Options for Database Intialization

DDL = Data Definition Lang DML = Data Manipulation Lang

Hibernate

• Allows the database to be created from the JPA in memory
• Hibernate property is set by the Spring property spring.jpa.hibernate.ddl-auto
• Options are:
  • none - Hibernate does nothing
  • validate - Fail if there is a table or column missing
  • update - Automatically update database model by running ddl statements.*
  • create - Create tables everytime*
  • create-drop - Same as above except the table is dropped on termination*

*Use with cuation, not reccomended for all production systems

• Spring Boot will use create-drop for embedded databases (hsql, h2, derby) or none otherwise
• Data can be loaded from import.sql
  • Must be on the root of class path
  • Only executed if set to create or create-drop

Spring JDBC

• Spring DataSource initializer via Spring Boot will by default load schema.sql and data.sql from the root of the classpath
• Spring Boot will also load from schema-${platform}
• May conflict with Hibernate's DDL Auto property
  • Should use none or validate