인프런 영문 브랜드 로고
인프런 영문 브랜드 로고

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

sunpil86님의 프로필 이미지
sunpil86

작성한 질문수

스프링 입문 - 코드로 배우는 스프링 부트, 웹 MVC, DB 접근 기술

스프링 통합 테스트에서 에러가 발생합니다

해결된 질문

작성

·

513

0

https://www.inflearn.com/questions/734751/java-lang-illegalstateexception-failed-to-load-applicationcontext-%EC%98%A4%EB%A5%98-%EC%A7%88%EB%AC%B8%EB%93%9C%EB%A6%BD%EB%8B%88%EB%8B%A4

위 링크에서 공식 서포터즈 David님이 properties에 spring.datasource.username:과 spring.datasource.password:를 추가하라고 조언해주셨는데 새로운 에러가 발생하였습니다...
구글링한 결과 java.lang.NumberFormatException: For input string: "spring"는 잘못된 형변환으로 자료형 불일치일 경우 발생하는 에러라는데 강사님 코드와 제 코드를 비교해봐도 어디가 잘못된건지 잘 모르겠습니다
현재 회원가입 테스트와 중복 회원 예외 테스트 둘다 같은 에러가 뜨는 것으로 보이는데 아래에 제가 작성한 코드와 에러를 첨부하였습니다

https://drive.google.com/file/d/1PWlxQRc22JKmjN8X8jfaJp7zdP3Fssfh/view?usp=sharing

 

2023-01-09 12:06:54.744 INFO 5900 --- [ Test worker] o.s.t.c.transaction.TransactionContext : Began transaction (1) for test context [DefaultTestContext@5a12c728 testClass = MemberServiceIntegrationTest, testInstance = hello.hellospring.service.MemberServiceIntegrationTest@18ff1520, testMethod = 중복_회원_예외@MemberServiceIntegrationTest, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@79ab3a71 testClass = MemberServiceIntegrationTest, locations = '{}', classes = '{class hello.hellospring.HelloSpringApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@2fea7088, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@13e3c1c7, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@5b40ceb, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@36546a22, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@636e8cc, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@bb9e6dc], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]; transaction manager [org.springframework.orm.jpa.JpaTransactionManager@34f48d1]; rollback [true]

2023-01-09 12:06:54.952 INFO 5900 --- [ Test worker] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test: [DefaultTestContext@5a12c728 testClass = MemberServiceIntegrationTest, testInstance = hello.hellospring.service.MemberServiceIntegrationTest@18ff1520, testMethod = 중복_회원_예외@MemberServiceIntegrationTest, testException = org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select * from member where id = ?]; Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-214]; nested exception is org.h2.jdbc.JdbcSQLDataException: Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)

at org.h2.message.DbException.get(DbException.java:194)

at org.h2.value.Value.convertTo(Value.java:875)

at org.h2.value.Value.convertTo(Value.java:737)

at org.h2.mvstore.db.MVPrimaryIndex.getKey(MVPrimaryIndex.java:395)

at org.h2.mvstore.db.MVDelegateIndex.find(MVDelegateIndex.java:87)

at org.h2.index.BaseIndex.find(BaseIndex.java:148)

at org.h2.index.IndexCursor.find(IndexCursor.java:163)

at org.h2.table.TableFilter.next(TableFilter.java:498)

at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1843)

at org.h2.result.LazyResult.hasNext(LazyResult.java:101)

at org.h2.result.LazyResult.next(LazyResult.java:60)

at org.h2.command.dml.Select.queryFlat(Select.java:737)

at org.h2.command.dml.Select.queryWithoutCache(Select.java:844)

at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:201)

at org.h2.command.dml.Query.query(Query.java:489)

at org.h2.command.dml.Query.query(Query.java:451)

at org.h2.command.CommandContainer.query(CommandContainer.java:285)

at org.h2.command.Command.executeQuery(Command.java:195)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:343)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:183)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by: java.lang.NumberFormatException: For input string: "spring"

at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.base/java.lang.Long.parseLong(Long.java:692)

at java.base/java.lang.Long.parseLong(Long.java:817)

at org.h2.value.Value.convertToLong(Value.java:1011)

at org.h2.value.Value.convertTo(Value.java:808)

... 19 more

, mergedContextConfiguration = [WebMergedContextConfiguration@79ab3a71 testClass = MemberServiceIntegrationTest, locations = '{}', classes = '{class hello.hellospring.HelloSpringApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@2fea7088, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@13e3c1c7, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@5b40ceb, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@36546a22, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@636e8cc, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@bb9e6dc], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]]

PreparedStatementCallback; SQL [select * from member where id = ?]; Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-214]; nested exception is org.h2.jdbc.JdbcSQLDataException: Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)

at org.h2.message.DbException.get(DbException.java:194)

at org.h2.value.Value.convertTo(Value.java:875)

at org.h2.value.Value.convertTo(Value.java:737)

at org.h2.mvstore.db.MVPrimaryIndex.getKey(MVPrimaryIndex.java:395)

at org.h2.mvstore.db.MVDelegateIndex.find(MVDelegateIndex.java:87)

at org.h2.index.BaseIndex.find(BaseIndex.java:148)

at org.h2.index.IndexCursor.find(IndexCursor.java:163)

at org.h2.table.TableFilter.next(TableFilter.java:498)

at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1843)

at org.h2.result.LazyResult.hasNext(LazyResult.java:101)

at org.h2.result.LazyResult.next(LazyResult.java:60)

at org.h2.command.dml.Select.queryFlat(Select.java:737)

at org.h2.command.dml.Select.queryWithoutCache(Select.java:844)

at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:201)

at org.h2.command.dml.Query.query(Query.java:489)

at org.h2.command.dml.Query.query(Query.java:451)

at org.h2.command.CommandContainer.query(CommandContainer.java:285)

at org.h2.command.Command.executeQuery(Command.java:195)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:343)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:183)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by: java.lang.NumberFormatException: For input string: "spring"

at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.base/java.lang.Long.parseLong(Long.java:692)

at java.base/java.lang.Long.parseLong(Long.java:817)

at org.h2.value.Value.convertToLong(Value.java:1011)

at org.h2.value.Value.convertTo(Value.java:808)

... 19 more

org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select * from member where id = ?]; Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-214]; nested exception is org.h2.jdbc.JdbcSQLDataException: Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)

at org.h2.message.DbException.get(DbException.java:194)

at org.h2.value.Value.convertTo(Value.java:875)

at org.h2.value.Value.convertTo(Value.java:737)

at org.h2.mvstore.db.MVPrimaryIndex.getKey(MVPrimaryIndex.java:395)

at org.h2.mvstore.db.MVDelegateIndex.find(MVDelegateIndex.java:87)

at org.h2.index.BaseIndex.find(BaseIndex.java:148)

at org.h2.index.IndexCursor.find(IndexCursor.java:163)

at org.h2.table.TableFilter.next(TableFilter.java:498)

at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1843)

at org.h2.result.LazyResult.hasNext(LazyResult.java:101)

at org.h2.result.LazyResult.next(LazyResult.java:60)

at org.h2.command.dml.Select.queryFlat(Select.java:737)

at org.h2.command.dml.Select.queryWithoutCache(Select.java:844)

at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:201)

at org.h2.command.dml.Query.query(Query.java:489)

at org.h2.command.dml.Query.query(Query.java:451)

at org.h2.command.CommandContainer.query(CommandContainer.java:285)

at org.h2.command.Command.executeQuery(Command.java:195)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:343)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:183)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by: java.lang.NumberFormatException: For input string: "spring"

at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.base/java.lang.Long.parseLong(Long.java:692)

at java.base/java.lang.Long.parseLong(Long.java:817)

at org.h2.value.Value.convertToLong(Value.java:1011)

at org.h2.value.Value.convertTo(Value.java:808)

... 19 more

at app//org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:251)

at app//org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)

at app//org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)

at app//org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667)

at app//org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)

at app//org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744)

at app//org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)

at app//org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:815)

at app//hello.hellospring.repository.JdbcTemplateMemberRepository.findByName(JdbcTemplateMemberRepository.java:52)

at app//hello.hellospring.service.MemberService.validateDuplicateMember(MemberService.java:31)

at app//hello.hellospring.service.MemberService.join(MemberService.java:25)

at app//hello.hellospring.service.MemberServiceIntegrationTest.중복_회원_예외(MemberServiceIntegrationTest.java:47)

at java.base@11/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base@11/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base@11/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base@11/java.lang.reflect.Method.invoke(Method.java:566)

at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)

at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)

at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)

at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)

at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)

at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)

at app//org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)

at app//org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)

at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)

at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)

at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)

at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)

at app//org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)

at app//org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)

at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:214)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:210)

at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)

at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:66)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)

at app//org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

at java.base@11/java.util.ArrayList.forEach(ArrayList.java:1540)

at app//org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)

at app//org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

at java.base@11/java.util.ArrayList.forEach(ArrayList.java:1540)

at app//org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:41)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:155)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)

at app//org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)

at app//org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

at app//org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:35)

at app//org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)

at app//org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:54)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:107)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67)

at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52)

at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:114)

at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:86)

at org.junit.platform.launcher.core.DefaultLauncherSession$DelegatingLauncher.execute(DefaultLauncherSession.java:86)

at org.junit.platform.launcher.core.SessionPerRequestLauncher.execute(SessionPerRequestLauncher.java:53)

at org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.processAllTestClasses(JUnitPlatformTestClassProcessor.java:99)

at org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.access$000(JUnitPlatformTestClassProcessor.java:79)

at org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor.stop(JUnitPlatformTestClassProcessor.java:75)

at org.gradle.api.internal.tasks.testing.SuiteTestClassProcessor.stop(SuiteTestClassProcessor.java:62)

at java.base@11/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base@11/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base@11/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base@11/java.lang.reflect.Method.invoke(Method.java:566)

at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36)

at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)

at org.gradle.internal.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:33)

at org.gradle.internal.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:94)

at com.sun.proxy.$Proxy2.stop(Unknown Source)

at org.gradle.api.internal.tasks.testing.worker.TestWorker$3.run(TestWorker.java:193)

at org.gradle.api.internal.tasks.testing.worker.TestWorker.executeAndMaintainThreadName(TestWorker.java:129)

at org.gradle.api.internal.tasks.testing.worker.TestWorker.execute(TestWorker.java:100)

at org.gradle.api.internal.tasks.testing.worker.TestWorker.execute(TestWorker.java:60)

at org.gradle.process.internal.worker.child.ActionExecutionWorker.execute(ActionExecutionWorker.java:56)

at org.gradle.process.internal.worker.child.SystemApplicationClassLoaderWorker.call(SystemApplicationClassLoaderWorker.java:113)

at org.gradle.process.internal.worker.child.SystemApplicationClassLoaderWorker.call(SystemApplicationClassLoaderWorker.java:65)

at app//worker.org.gradle.process.internal.worker.GradleWorkerMain.run(GradleWorkerMain.java:69)

at app//worker.org.gradle.process.internal.worker.GradleWorkerMain.main(GradleWorkerMain.java:74)

Caused by: org.h2.jdbc.JdbcSQLDataException: Data conversion error converting "spring"; SQL statement:

select * from member where id = ? [22018-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)

at org.h2.message.DbException.get(DbException.java:194)

at org.h2.value.Value.convertTo(Value.java:875)

at org.h2.value.Value.convertTo(Value.java:737)

at org.h2.mvstore.db.MVPrimaryIndex.getKey(MVPrimaryIndex.java:395)

at org.h2.mvstore.db.MVDelegateIndex.find(MVDelegateIndex.java:87)

at org.h2.index.BaseIndex.find(BaseIndex.java:148)

at org.h2.index.IndexCursor.find(IndexCursor.java:163)

at org.h2.table.TableFilter.next(TableFilter.java:498)

at org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1843)

at org.h2.result.LazyResult.hasNext(LazyResult.java:101)

at org.h2.result.LazyResult.next(LazyResult.java:60)

at org.h2.command.dml.Select.queryFlat(Select.java:737)

at org.h2.command.dml.Select.queryWithoutCache(Select.java:844)

at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:201)

at org.h2.command.dml.Query.query(Query.java:489)

at org.h2.command.dml.Query.query(Query.java:451)

at org.h2.command.CommandContainer.query(CommandContainer.java:285)

at org.h2.command.Command.executeQuery(Command.java:195)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:343)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:183)

at java.base/java.lang.Thread.run(Thread.java:834)

Caused by: java.lang.NumberFormatException: For input string: "spring"

at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.base/java.lang.Long.parseLong(Long.java:692)

at java.base/java.lang.Long.parseLong(Long.java:817)

at org.h2.value.Value.convertToLong(Value.java:1011)

at org.h2.value.Value.convertTo(Value.java:808)

... 19 more

at app//org.h2.message.DbException.getJdbcSQLException(DbException.java:506)

at app//org.h2.engine.SessionRemote.readException(SessionRemote.java:637)

at app//org.h2.engine.SessionRemote.done(SessionRemote.java:606)

at app//org.h2.command.CommandRemote.executeQuery(CommandRemote.java:171)

at app//org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:128)

at app//com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)

at app//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)

at app//org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722)

at app//org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651)

... 93 more

 


답변 1

1

안녕하세요. sunpil86님, 공식 서포터즈 David입니다.

findByName에 해당하는 쿼리는 where절 조건이 name이 되어야 하는데 id로 되어 있습니다.

where id = ? 가 아니라 where name = ? 이 되어야 합니다.

image

감사합니다.

sunpil86님의 프로필 이미지
sunpil86
질문자

정말 감사합니다! ㅠㅠ

sunpil86님의 프로필 이미지
sunpil86

작성한 질문수

질문하기