learnspringboot-jooq

Spring Boot Project using Kotlin and JOOQ.

Enabling H2(In Memory DB) in your application

application.yml

spring:
  profiles:
    active: dev
  datasource:
    url: jdbc:h2:mem:testdb
    driver-class-name: org.h2.Driver
    data-username: sa
  jpa:
    database: h2
    database-platform: org.hibernate.dialect.H2Dialect
  h2:
    console:
      enabled: true

build.gradle

runtimeOnly("com.h2database:h2"

H2-Console URL

http://localhost:8080/h2-console

Enable Flyway

• Add the below in the build.gradle file.

implementation("org.flywaydb:flyway-core:5.2.4")

• Add the following directory to the src/main/resources/db/migration

• Create the file using like below and make sure you have the number followed by __ for flyway to migrate it to you.

V1__CREATE_EMPLOYEE.sql