[Spring Boot] Could not obtain connection to query metadata 오류

나의 yml

spring:
  h2:
    console:
      enabled: true
  jpa:
    generate-ddl: true
    hibernate:
      ddl-auto: create-drop
    database: H2
    show-sql: true
    open-in-view: false
    properties:
      hibernate:
        dialect: org.hibernate.dialect.MYSQL5InnoDBDialect
        query.in_clause_parameter_padding: true
    

 

구글링 후

spring:
  h2:
    console:
      enabled: true
  jpa:
    generate-ddl: true
    hibernate:
      ddl-auto: create-drop
    database: H2
    show-sql: true
    open-in-view: false
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
        query.in_clause_parameter_padding: true

 

dialect 부분만 변경

 

 

해결!