====== H2 Database ======
  * http://www.h2database.com/
  * [[database:embedded_database|Embedded Database]]
  * [[http://www.h2database.com/html/cheatSheet.html|H2 Database Engine cheatsheet]]

===== DB 초기화시 실행 =====
<code>
jdbc:h2:mem:test;INIT=create schema if not exists test\;runscript from '~/sql/init.sql
</code>

===== Trace =====
  * 로깅 대신 Trace라고 부름
  * 로거 2 종류
    * TRACE_LEVEL_SYSTEM_OUT : System.out
    * TRACE_LEVEL_FILE : 파일로 저장
    * 0 : OFF
    * 1 : ERROR
    * 2 : INFO
    * 3 : DEBUG
  * ''TRACE_LEVEL_FILE=4'' : [[java:slf4j|Slf4j]] 사용해서 로깅. 모든 설정은 Slf4j 구현체를 따름.

<code>
jdbc:h2:~/test;TRACE_LEVEL_FILE=3;TRACE_LEVEL_SYSTEM_OUT=3
</code>

===== 참조 =====
  * [[https://www.baeldung.com/h2-embedded-db-data-storage|Where Does H2's Embedded Database Store The Data? | Baeldung]]