스프링 부트에 H2 DB 적용하기

build.gradle 설정

depandency에 작성

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter'
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'

    developmentOnly 'org.springframework.boot:spring-boot-devtools'

    compileOnly 'org.projectlombok:lombok:1.18.16'
    annotationProcessor 'org.projectlombok:lombok:1.18.16'

    testCompileOnly 'org.projectlombok:lombok:1.18.16'
    testAnnotationProcessor 'org.projectlombok:lombok:1.18.16'

    compile  'com.h2database:h2'
}

application.yml 설정

spring:
  h2:
    console:
      enabled: true
    port: 9092
  profiles:
    active: local
  datasource:
    hikari:
      jdbc-url: jdbc:h2:./data/testdb
      driver-class-name: org.h2.Driver
      username: sa
      password:
  jpa:
    hibernate:
      ddl-auto: update
    properties:
      hibernate:
        format_sql: true

h2config 클래스 작성

@Log
@Configuration
@Profile("local")
public class H2ServerConfiguration {

    @Value("${spring.h2.port}")
    String port;

    @Bean
    @ConfigurationProperties("spring.datasource.hikari")
    public DataSource dataSource() throws SQLException {

        log.info("port: "+port);
        Server.createTcpServer("-tcp", "-tcpAllowOthers", "-tcpPort", port).start();

        return new com.zaxxer.hikari.HikariDataSource();
    }
}

h2 DB 연동 확인하면 설정이 완료된다.