스프링 데이터 jpa 통합테스트 오류

Question

스프링 데이터 jpa의 통합테스트 - 회원가입 부분을 돌리는 부분에서 private final MemberRepository memberRepository;이 부분에서 자동 주입을 할 수 없습니다. 'MemberRepository' 타입의 bean이 두 개 이상 있습니다.라는 오류가 떠 memorymemberrepository에 쓰인 @Repository를 지워 private final MemberRepository memberRepository;이 부분의 빨간 줄은 없앴는데 테스트는 안 돌아가서 질문 남깁니다 무슨 오류일까요? 해결방법도 알려주세요,, SpringConfig MemberServiceIntegrationTest SpringDataJpaMemberRepsitory 아래는 테스트 실행시 나오는 에러 메시지입니다 java.lang.NullPointerException: Cannot invoke "org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(java.sql.SQLException, String)" because the return value of "org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.sqlExceptionHelper()" is null at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork( JdbcIsolationDelegate.java:116 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata( JdbcEnvironmentInitiator.java:290 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService( JdbcEnvironmentInitiator.java:123 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService( JdbcEnvironmentInitiator.java:77 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService( StandardServiceRegistryImpl.java:130 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService( AbstractServiceRegistryImpl.java:263 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService( AbstractServiceRegistryImpl.java:238 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService( AbstractServiceRegistryImpl.java:215 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.model.relational.Database.( Database.java:45 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase( InFlightMetadataCollectorImpl.java:221 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.( InFlightMetadataCollectorImpl.java:189 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete( MetadataBuildingProcess.java:171 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata( EntityManagerFactoryBuilderImpl.java:1431 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build ( EntityManagerFactoryBuilderImpl.java:1502 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] 2024-06-21T18:39:08.309+09:00 ERROR 43820 --- [hello-spring] [ Test worker] j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) 2024-06-21T18:39:08.310+09:00 WARN 43820 --- [hello-spring] [ Test worker] o.s.w.c.s.GenericWebApplicationContext : 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]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) 2024-06-21T18:39:08.324+09:00 INFO 43820 --- [hello-spring] [ Test worker] .s.b.a.l.ConditionEvaluationReportLogger : Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. 2024-06-21T18:39:08.339+09:00 ERROR 43820 --- [hello-spring] [ Test worker] o.s.boot.SpringApplication : Application run failed

OMG · Answer

안녕하세요. 엄혜원님, 공식 서포터즈 OMG입니다. application.properties 에서 h2가 실행중인 상태에서 확인이 필요하며,   h2 관련 설정을 application.properties 에 잘 적용하셨을까요? url과 username, password를 h2를 콘솔에서 실행했을 때 입력한 id, 비밀번호(별도 수정하였다면) 통일시켜서 확인해주세요. application.properties spring.datasource.url=jdbc:h2:tcp://localhost/~/test spring.datasource.driver-class-name=org.h2.Driver spring.datasource.username=sa spring.datasource.password= 감사합니다.

enaak · Answer

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService( AbstractServiceRegistryImpl.java:276 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService( AbstractServiceRegistryImpl.java:238 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService( AbstractServiceRegistryImpl.java:215 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.model.relational.Database.( Database.java:45 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase( InFlightMetadataCollectorImpl.java:221 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.( InFlightMetadataCollectorImpl.java:189 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete( MetadataBuildingProcess.java:171 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata( EntityManagerFactoryBuilderImpl.java:1431 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build ( EntityManagerFactoryBuilderImpl.java:1502 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] Caused by: org.hibernate.HibernateException: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect( DialectFactoryImpl.java:191 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect( DialectFactoryImpl.java:87 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentWithDefaults( JdbcEnvironmentInitiator.java:152 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata( JdbcEnvironmentInitiator.java:362 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService( JdbcEnvironmentInitiator.java:123 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService( JdbcEnvironmentInitiator.java:77 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService( StandardServiceRegistryImpl.java:130 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService( AbstractServiceRegistryImpl.java:263 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] 2024-06-21T18:39:08.349+09:00 WARN 43820 --- [hello-spring] [ Test worker] o.s.test.context.TestContextManager : Caught exception while allowing TestExecutionListener [org.springframework.test.context.web.ServletTestExecutionListener] to prepare test instance [hello.hello_spring.service.MemberServiceIntegrationTest@166ce247] java.lang.IllegalStateException: Failed to load ApplicationContext for [WebMergedContextConfiguration@7d64a960 testClass = hello.hello_spring.service.MemberServiceIntegrationTest, locations = [], classes = [hello.hello_spring.HelloSpringApplication], contextInitializerClasses = [], activeProfiles = [], propertySourceDescriptors = [], propertySourceProperties = ["org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true"], contextCustomizers = [org.springframework.boot.test.autoconfigure.actuate.observability.ObservabilityContextCustomizerFactory$DisableObservabilityContextCustomizer@1f, org.springframework.boot.test.autoconfigure.properties .PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizer@2eee3069, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@13d9b21f, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@2654635, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@46268f08, org.springframework.boot.test.context.SpringBootTestAnnotation@96f46d84], resourceBasePath = "src/main/webapp", contextLoader = org.springframework.boot.test.context.SpringBootContextLoader, parent = null] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' for common cases or 'hibernate.dialect' when a custom Dialect implementation must be provided) at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService( AbstractServiceRegistryImpl.java:276 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService( AbstractServiceRegistryImpl.java:238 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService( AbstractServiceRegistryImpl.java:215 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.model.relational.Database.( Database.java:45 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase( InFlightMetadataCollectorImpl.java:221 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.( InFlightMetadataCollectorImpl.java:189 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete( MetadataBuildingProcess.java:171 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata( EntityManagerFactoryBuilderImpl.java:1431 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build ( EntityManagerFactoryBuilderImpl.java:1502 ) ~[ hibernate-core-6.5.2.Final .jar: 6.5.2.Final ]