SpringBoot에서 H2 DB 관리자 UI 접속하기

SpringBoot에서 H2를 사용할 경우 구동시에 DB상태를 보고 싶었다.

가령 php my admin처럼 말이다. 찾아보니 이게 있는데 생각보다 간단하고 신기하다.

Ref에 있는 해외 글에서 방법을 찾았다.

1. Maven, Gradle 추가

Maven : 

<dependency>

    <groupId>com.h2database</groupId>

    <artifactId>h2</artifactId>

</dependency>

Gradle

compile("com.h2database:h2")

2. H2 Servlet 추가

import org.h2.server.web.WebServlet;

import org.springframework.boot.context.embedded.ServletRegistrationBean;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

@Configuration

public class WebConfiguration {

    @Bean

    ServletRegistrationBean h2servletRegistration(){

        ServletRegistrationBean registrationBean = new ServletRegistrationBean( new WebServlet());

        registrationBean.addUrlMappings("/console/*");

        return registrationBean;

    }

}

3. SecurityConfiguration 추가

import org.springframework.context.annotation.Configuration;

import org.springframework.security.config.annotation.web.builders.HttpSecurity;

import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;

@Configuration

public class SecurityConfiguration extends WebSecurityConfigurerAdapter {

    @Override

    protected void configure(HttpSecurity httpSecurity) throws Exception {

        httpSecurity.authorizeRequests().antMatchers("/").permitAll().and()

                .authorizeRequests().antMatchers("/console/**").permitAll();

        httpSecurity.csrf().disable();

        httpSecurity.headers().frameOptions().disable();

    }

}

4. 구동 및 접속

http://localhost:8080/console/

Reference

[1] Spring guru (https://springframework.guru/using-the-h2-database-console-in-spring-boot-with-spring-security/)