spring boot) application.properties 에서 application.yaml로 바꾸면 에러가 납니다

Question

겪고있는 문제기존의 application.properties 삭제 후(혹은 내용 수정 후)application.yaml로 바꾸면 에러가 납니다Intellij 로 실행시 오류Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set powershell 로 실행시 오류2022-12-27 15:45:56.952 ERROR 10292 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] 2022-12-27 15:45:56.954 WARN 10292 --- [ restartedMain] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] 2022-12-27 15:45:56.957 INFO 10292 --- [ restartedMain] o.apache.catalina.core.StandardService : Stopping service [Tomcat] 2022-12-27 15:45:56.967 INFO 10292 --- [ restartedMain] ConditionEvaluationReportLoggingListener : Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2022-12-27 15:45:56.987 ERROR 10292 --- [ restartedMain] o.s.boot.SpringApplication : Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] 문제 의심 파일application.properties (정상실행)#configuration spring.jpa.hibernate.ddl-auto&#61;update spring.datasource.url&#61;jdbc:mysql://localhost:3306/test1 spring.datasource.username&#61;root spring.datasource.password&#61;0000 spring.datasource.driver-class-name&#61;com.mysql.cj.jdbc.Driverapplication.yaml (오류 발생)spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/test1 username: root password: 0000 jpa: hibernate: ddl-auto: update사용중인 build.gradleplugins { id 'java' id 'org.springframework.boot' version '2.7.8-SNAPSHOT' id 'io.spring.dependency-management' version '1.0.15.RELEASE' } group &#61; 'com.example' version &#61; '0.0.1-SNAPSHOT' sourceCompatibility &#61; '11' configurations { compileOnly { extendsFrom annotationProcessor } } repositories { mavenCentral() maven { url 'https://repo.spring.io/milestone' } maven { url 'https://repo.spring.io/snapshot' } } dependencies { implementation 'org.springframework.boot:spring-boot-starter-data-jdbc' implementation 'org.springframework.boot:spring-boot-starter-data-jpa' implementation 'org.springframework.boot:spring-boot-starter-oauth2-client' implementation 'org.springframework.boot:spring-boot-starter-security' implementation 'org.springframework.boot:spring-boot-starter-web' compileOnly 'org.projectlombok:lombok' developmentOnly 'org.springframework.boot:spring-boot-devtools' runtimeOnly 'com.mysql:mysql-connector-j' annotationProcessor 'org.projectlombok:lombok' testImplementation 'org.springframework.boot:spring-boot-starter-test' testImplementation 'org.springframework.security:spring-security-test' } tasks.named('test') { useJUnitPlatform() } 기존의 프로젝트의 .properties 를 .yaml 로 바꾸려고 시도하였고위와 같은 에러가 났습니다프로젝트 문제인가 싶어서 start.spring.io 를 통해서 새 프로젝트를 만든뒤 실험해봐도여전히 같은 문제였습니다좌절과 실패에도 포기하지 않았습니다중요한건 꺾이지 않는 마음지난주에 계속 구글링 해가며 여러 방법을 찾아보고 실험해봤지만 실패했습니다...제 멍충한 머리로 할 수 있는건 다 해봤습니다.. 흑... ㅠㅠ선배님들 도와주십쇼... ㅠㅠ

리리리릿 · Accepted Answer

https://www.baeldung.com/spring-boot-yaml-vs-properties파일형식은 YAML이 맞지만, 파일확장자는 yml로 해주셔야 할 것 같습니다.

adduci · Answer

에러 메세지 내려보면 다른 이유가 있을텐데요

kiel · Answer

IntelliJ 오류를 보면Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not sethibernate.dialect 가 없다고 나오네요.https://velog.io/&#64;gloom/Spring-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EC%97%B0%EB%8F%99-%EC%8B%9C-Access-to-DialectResolutionInfo-cannot-be-null-when-hibernate.dialect-not-set-%EC%98%A4%EB%A5%98어느 DB 문법을 쓰는지 hibernate 에 지정이 되어야 한다는 오류입니다.근데, 이 문제 properties냐 yaml 이냐 문제가 아니라 어느 쪽이든 났어야 할 것 같은데 이상하네요.

spring boot) application.properties 에서 application.yaml로 바꾸면 에러가 납니다

3개의 답변

#yml 목록