065. Database Initialization - dkkahm/study-springfamework5 GitHub Wiki

Spring's DataSource initializer

  • resources/schema.sql
  • resources/data.sql

May conflict with Hibernate's DDL Auto property

  • Should use setting of 'none' or 'validate'

Spring's DataSource initializer with Platform

  • select platform in application.property
// application-default.properties
spring.datasource.platform=h2

// application-dev.properties
spring.datasource.platform=mysql

// application-prod.properties
spring.datasource.platform=mysql
  • platform specific initializer
// schema-h2.sql
// schema-mysql.sql

// data-h2.sql
// data-mysql.sql