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

2021-01-14 22:31:29.644 ERROR 74220 --- [nio-8080-exec-8] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.IllegalStateException: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "MEMBER" not found; SQL statement:
select * from MEMBER [42102-200]] with root cause

오류 부분은 하단과 같습니다!
	at tutorial.tutorialspring.repository.JdbcMemberRepository.findAll(JdbcMemberRepository.java:72) ~[classes/:na]
	at tutorial.tutorialspring.service.MemberService.findMembers(MemberService.java:38) ~[classes/:na]
	at tutorial.tutorialspring.controller.MemberController.list(MemberController.java:39) ~[classes/:na]

JdbcMemberRepository 부분을 그대로 복사 붙여넣기했는데 왜 이런 오류가 나는지 잘 모르겠어요 ..

import javax.sql.DataSource;

@Configuration
public class SpringConfig {

    private DataSource dataSource;

    @Autowired
    public SpringConfig(DataSource dataSource){
        this.dataSource = dataSource;
    }

    @Bean
    public MemberService memberService(){
        return new MemberService(memberRepository());
    }

    @Bean
    public MemberRepository memberRepository(){
        return new JdbcMemberRepository(dataSource);
    }
}

SpringConfig 부분도 강의 내용과 동일합니다!

연결 은 잘 된 것 같은데, SyntaxError가 왜 나는걸까요..?

H2에 select * from MEMBER 쿼리문을 똑같이 보내면 잘 적용되지만, Spring에서는 안되네요.. ㅠ