[Spring] H2 database 설정하기

<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>

의존성을 추가

 

#h2 db 설정
spring.datasource.url=jdbc:h2:~/test;
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.H2Dialect

설정을 추가

 

localhost:8080/h2-console 접속을 하면된다.

 

추가적으로 기본적인 값을 넣고싶으면 

spring.jpa.defer-datasource-initialization=true
spring.sql.init.mode=always
spring.sql.init.data-locations=classpath:sample/data.sql

설정을 추가하고 data.sql에 쿼리문을 작성하여 넣으면된다.

 

insert into "MEMBER"
(id, account, contact, name, password, reg_dt)
values
(1, 'test1', '01012345678', '테스트1', 'password', now());

insert into "MEMBER"
(id, account, contact, name, password, reg_dt)
values
(2, 'test2', '01067891234', '테스트2', 'password', now());