How to insert data in to H2 database during Spring Boot Application startup

H2 Database Initialization in Spring Boot.md

1. Create schema.sql file src/main/resources directory. This file contains all DDL statements
2. Create data.sql file in src/main/resources directory. This file contains all DML statements(insert,update statements)
3. Create the application.yml file with following config

spring:
  datasource:
    url: jdbc:h2:mem:db
    username: admin
    password: admin
    initialization-mode: always
    data: classpath:data.sql
    schema: classpath:schema.sql

  jpa:
    hibernate:
      ddl-auto: none

  h2:
    console:
      enabled: true
server:
  port: 8081

4. In application.yml file make sure you set the following

• spring.datasource.initialization-mode=always
• spring.datasource.schema=classpath:schema.sql
• spring.datasource.data=classpath:data.sql
• And spring.jpa.hibernate.ddl-auto=none