인프런 커뮤니티 질문&답변

안녕하세요 도움 좀 구하겠습니다.^^

왠만하면 질문을 안하려고 했는데, 도저히 해결이 안되서 질문 올려드려요^^

테스트 db(메모리 db) 강의 이후부터 H2 실제 DB로 붙지 않고 계속 메모리 DB로만 붙는데.

(JpashopApplication 로 테스트가 아니라 실제 main 경로에 있는 소스 컴파일 함에도 불구하고)

여러가지 시도해보다가 도움을 구해봅니다.

main/java/jpabook/jpashop/application.yml

spring:
  datasource:
    url: jdbc:h2:tcp://localhost/c:\project\spring\jpashop\db\jpashop;
    username: sa
    password:
    driver-class-name: org.h2.Driver

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

logging:
  level:
    org.hibernate.SQL: debug
    org.hibernate.type: trace 

test/resources/application.yml

spring:
  datasource:
    url: jdbc:h2:mem:test
    username: sa
    password:
    driver-class-name: org.h2.Driver

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

logging:
  level:
    org.hibernate.SQL: debug
    org.hibernate.type: trace

log

  .   ____          _            __ _ _

 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \

( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \

 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )

  '  |____| .__|_| |_|_| |_\__, | / / / /

 =========|_|==============|___/=/_/_/_/

 :: Spring Boot ::                (v2.4.0)

2020-12-26 19:33:38.857  INFO 6064 --- [  restartedMain] jpabook.jpashop.JpashopApplication       : Starting JpashopApplication using Java 11.0.9 on DESKTOP-P2DOCCS with PID 6064 (C:\project\spring\jpashop\out\production\classes started by book in C:\project\spring\jpashop)

2020-12-26 19:33:38.862  INFO 6064 --- [  restartedMain] jpabook.jpashop.JpashopApplication       : No active profile set, falling back to default profiles: default

2020-12-26 19:33:38.929  INFO 6064 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable

2020-12-26 19:33:38.929  INFO 6064 --- [  restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'

2020-12-26 19:33:39.931  INFO 6064 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode.

2020-12-26 19:33:39.962  INFO 6064 --- [  restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19 ms. Found 0 JPA repository interfaces.

2020-12-26 19:33:40.699  INFO 6064 --- [  restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)

2020-12-26 19:33:40.712  INFO 6064 --- [  restartedMain] o.apache.catalina.core.StandardService   : Starting service [Tomcat]

2020-12-26 19:33:40.712  INFO 6064 --- [  restartedMain] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.39]

2020-12-26 19:33:40.858  INFO 6064 --- [  restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext

2020-12-26 19:33:40.858  INFO 6064 --- [  restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1927 ms

2020-12-26 19:33:41.010  INFO 6064 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...

2020-12-26 19:33:41.159  INFO 6064 --- [  restartedMain] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.

2020-12-26 19:33:41.169  INFO 6064 --- [  restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration    : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:86291ee3-40ea-4319-9124-9d3bf6838987'