[๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค] H2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค์น˜ํ•˜๊ธฐ

2023. 2. 24. 14:14ยทDevelop/DB

 

H2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

 

๊ฐœ๋ฐœ์ด๋‚˜ ํ…Œ์ŠคํŠธ ์šฉ๋„๋กœ ๊ฐ€๋ณ๊ณ  ํŽธ๋ฆฌํ•œ DB, ์›น ํ™”๋ฉด ์ œ๊ณต

 

 

 

๋‹ค์šด๋กœ๋“œ 

https://www.h2database.com/html/main.html

 

H2 Database Engine

H2 Database Engine Welcome to H2, the Java SQL database. The main features of H2 are: Very fast, open source, JDBC API Embedded and server modes; in-memory databases Browser based Console application Small footprint: around 2.5 MB jar file size     Supp

www.h2database.com

 

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํŒŒ์ผ ์ƒ์„ฑ ๋ฐฉ๋ฒ•

 

http://localhost:8082/

 

 

jdbc:h2:~/name  (์ตœ์†Œ ํ•œ๋ฒˆ)

 

~/name.mv.db ํŒŒ์ผ ์ƒ์„ฑ ํ™•์ธ

 


์ดํ›„ ๋ถ€ํ„ฐ๋Š”
jdbc:h2:tcp://localhost/~/name ์ด๋ ‡๊ฒŒ ์ ‘์†

 

 

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋ฒ„ ์‹คํ–‰ํ•˜๊ธฐ 

 

 

 

h2/bin ์œ„์น˜์— ๊ฐ€์„œ 

 

./h2.sh 

 

 

์„ฑ๊ณต 

 

 

 

 

application.yml ์„ค์ •ํŒŒ์ผ 

spring:
  datasource:
    url: jdbc:h2:tcp://localhost/~/name
    username: sa
    password:
    driver-class-name: org.h2.Driver

  jpa:
    hibernate:
      ddl-auto: create
    properties:
      hibernate:
        #show_sql: true
        format_sql: true

logging.level:
  org.hibernate.SQL: debug
# org.hibernate.type: trace #์Šคํ”„๋ง ๋ถ€ํŠธ 2.x, hibernate5
# org.hibernate.orm.jdbc.bind: trace #์Šคํ”„๋ง ๋ถ€ํŠธ 3.x, hibernate6

 

 

 

 

 

 

 

 

Database ์ƒ์„ฑ

 

h2 console์„ ์‹คํ–‰ ํ›„ 

 

 

 

create a new database... ๋ฅผ ํด๋ฆญ

 

 

 

 

์ฃผ์˜ํ•  ์ ์€ Database path ์— ์ฒ˜์Œ์—๋Š” ./ ์œผ๋กœ ์‹œ์ž‘ํ•˜๋Š”๋ฐ,

 

ํ•ด๋‹น ๋ถ€๋ถ„์„ ~/ ์œผ๋กœ ์ˆ˜์ • ํ•˜๊ณ  ๋‚˜์„œ ๋’ค์— Database ์ด๋ฆ„์„ ์ง€์ •ํ•ด์ค€๋‹ค.



 

 

ํ™ˆ ๋””๋ ‰ํ† ๋ฆฌ์— ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํŒŒ์ผ ์ƒ์„ฑ 

 

 

 

JDBC URL ์€ jdbc:h2:tcp://localhost/~/ + ์•ž์„œ ๋งŒ๋“  Database ์ด๋ฆ„ ์„ ํ•ฉ์นœ ๋ฌธ์ž์—ด์„ ์ž‘์„ฑํ•œ๋‹ค.

 

 

 

 

์ •์ƒ์ ์œผ๋กœ ์ƒ์„ฑํ•œ DataBase์— ์ ‘์†๋œ ํ™”๋ฉด

์ €์ž‘์žํ‘œ์‹œ (์ƒˆ์ฐฝ์—ด๋ฆผ)

'Develop > DB' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

[RDBMS Modeling ๊ธฐ์ดˆ] 5. ๊ด€๊ณ„(Relation) - ์—ฐ์Šต๋ฌธ์ œ  (0) 2023.03.01
[RDBMS Modeling ๊ธฐ์ดˆ] 4. ๊ด€๊ณ„(Relation) - M:N ๊ด€๊ณ„  (0) 2023.02.28
[RDBMS Modeling ๊ธฐ์ดˆ] 3. ๊ด€๊ณ„(Relation) - 1:M ๊ด€๊ณ„  (0) 2023.02.27
[RDBMS Modeling ๊ธฐ์ดˆ] 2. Primary Key ์„ค๊ณ„  (0) 2023.02.26
[RDBMS Modeling ๊ธฐ์ดˆ] 1. ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค  (0) 2023.02.24
'Develop/DB' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€
  • [RDBMS Modeling ๊ธฐ์ดˆ] 4. ๊ด€๊ณ„(Relation) - M:N ๊ด€๊ณ„
  • [RDBMS Modeling ๊ธฐ์ดˆ] 3. ๊ด€๊ณ„(Relation) - 1:M ๊ด€๊ณ„
  • [RDBMS Modeling ๊ธฐ์ดˆ] 2. Primary Key ์„ค๊ณ„
  • [RDBMS Modeling ๊ธฐ์ดˆ] 1. ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค
hello_u
hello_u
  • hello_u
    ๐Ÿ˜œ
    hello_u
  • ์ „์ฒด
    ์˜ค๋Š˜
    ์–ด์ œ
    • ๐Ÿ˜œ (345)
      • Hardware (2)
        • BMC (2)
      • Spring (109)
        • Spring ์ž…๋ฌธ (20)
        • Spring ๊ธฐ๋ณธ (27)
        • Spring MVC (18)
        • Spring DB (22)
        • Spring JPA ๊ธฐ๋ณธ (16)
        • Spring JPA ํ™œ์šฉ (6)
      • Develop (27)
        • DB (8)
        • JAVA (4)
        • Web (2)
        • Python (7)
        • OSS (2)
        • Git (2)
        • API (2)
      • Algorithm (155)
        • CodeUp ๊ธฐ์ดˆ (44)
        • ํŒŒ์ด์ฌ ์ฝ”๋”ฉํ…Œ์ŠคํŠธ (64)
        • ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค (4)
        • SWEA (30)
        • Softeer (10)
        • BOJ (2)
      • CS (9)
        • ์ปดํ“จํ„ฐ์ผ๋ฐ˜ (3)
        • ์šด์˜์ฒด์ œ (3)
        • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค (0)
        • ์ •๋ณดํ†ต์‹  (1)
        • ์ž๋ฃŒ๊ตฌ์กฐ (1)
        • ์†Œํ”„ํŠธ์›จ์–ด ๊ณตํ•™ (1)
        • ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด (0)
        • ์ตœ์‹  ๋””์ง€ํ„ธ, ์ผ๋ฐ˜์ƒ์‹ (0)
      • ์ž๊ฒฉ์ฆ (41)
        • ์ •๋ณด๋ณด์•ˆ๊ธฐ์‚ฌ (9)
        • ์ •๋ณด์ฒ˜๋ฆฌ๊ธฐ์‚ฌ (22)
        • ๋ฆฌ๋ˆ…์Šค๋งˆ์Šคํ„ฐ 1๊ธ‰ (3)
        • SQLD (7)
  • hELLOยท Designed By์ •์ƒ์šฐ.v4.10.3
hello_u
[๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค] H2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค์น˜ํ•˜๊ธฐ
์ƒ๋‹จ์œผ๋กœ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”