[보글 리펙토링] 발생한 에러

1. Parameter 0 of constructor in com.javaex.dao.BookdetailDao required a bean of type 'org.apache.ibatis.session.SqlSession' that could not be found.

• xml 파일 경로 지정

spring:
  datasource:
    classpath:/mappers/**/*.xml

• 디펜던시 변경
  implementation 'org.mybatis:mybatis:3.5.11'
  implementation 'org.mybatis:mybatis-spring:2.0.7'

implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.2.2'

---

2022-11-30 18:17:24.813 ERROR 6919 --- [nio-8088-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for bookdetail.getbookVo
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for bookdetail.getbookVo] with root cause

java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for bookdetail.getbookVo

:mapper id가 다를 경우

• mapper파일(MyBatis의 쿼리문을 등록한 XML 파일)에 select id=''.. 에 id와 mapper파일에 직접 접근하는 java파일(DAO나 service)에 적어놓은 id값이 다른 경우

2. Parameter와 bean의 필드명이 틀린 경우
3. mapper파일(MyBatis의 쿼리문을 등록한 XML 파일)에에 정의된 네임스페이스(namespace)와
   mapper파일에 직접 접근하는 java파일(DAO나 service)에서 호출하는 네임스페이스(namespace)가 다를 경우
4. MyBatis config파일에 mapper가 정의가 되어 있지 않거나 Spelling이 틀린 경우
5. mapper에 정의된 namespace 명칭이 같은 Application 내에 중복될 경우

---

3. org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.javaex.dao.BookdetailDao.getbookVo

• https://madplay.github.io/post/mybatis-invalid-bound-statement-not-found-error

---

4. 쿼리 에러
   :MySQL Every derived table must have its own alias

• https://wakestand.tistory.com/507
  : 서브쿼리에 Alias를 주지 않았을 경우 발생하는 에러인데

🖍️ 오라클의 경우에는 서브쿼리에 Alias를 주지 않아도 정상적으로 동작하지만
MySQL의 경우에는 무조건 에러

---

5. No setter found for the keyProperty 'playlistNo' in com.javaex.dto.main.AddPlayListRequest.

• AddPlayListRequest에 playlistNo 필드 생성 해결

<insert id="addNewPlaylist" parameterType="com.javaex.dto.main.AddPlayListRequest" useGeneratedKeys="true">
        <selectKey keyProperty="playlistNo" resultType="Long" order="BEFORE">
            SELECT LAST_INSERT_ID()
        </selectKey>

        <![CDATA[
			insert into playlist
			values(#{playlistNo}, #{userNo}, now(), #{playlistName}, #{emoNo})
		]]>
    </insert>

---

6. Error updating database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'seq_review_user_no.nextval' in 'field list'

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'seq_review_user_no.nextval' in 'field list'] with root cause

---

7. org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.javaex.dao.PlaylistFolderDao.playlistCover

• 해결 : xml mapper dao 지정

mapper namespace="com.javaex.dao.PlaylistFolderDao">

---

8. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'rownum' in 'field list'
   ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'rownum' in 'field list'] with root cause

• oracle -> mysql rownum 쿼리 문법이 맞지 않아서 발생

---

9. Cannot determine value type from string '서윤이'

• 타입 일치 에러, DTO에 email 필드 생성하지 않음

---

10. cannot deserialize from object value
    (no delegate- or property-based creator)

• POST 방식은 GET 방식과 달리 Body에 데이터를 담아야 한다 이때 DTO 기본 생성자가 없어서 발생한 에러

---

11. java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter

• 디펜던시 추가
  

implementation 'javax.xml.bind:jaxb-api:2.1'

---

12. Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause

• 쿼리에 null값이 들어간 경우 발생
• jwt 설정 하지 않았었음

package com.javaex.config;

import com.javaex.dto.user.UserDto;
import com.javaex.service.UserService;
import com.javaex.util.JwtUtil;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.http.HttpHeaders;
import org.springframework.security.authentication.UsernamePasswordAuthenticationToken;
import org.springframework.security.core.authority.SimpleGrantedAuthority;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.security.web.authentication.WebAuthenticationDetailsSource;
import org.springframework.web.filter.OncePerRequestFilter;

import javax.servlet.FilterChain;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

@Slf4j
@RequiredArgsConstructor
public class JwtTokenFilter extends OncePerRequestFilter {//입장할 때 마다(요청할 떄마다) 매번 불특정한 사람들이 요청 티켓을가지고 체크

    private final String secretKey;
    private final UserService userService;

    @Override
    protected void doFilterInternal(HttpServletRequest request, HttpServletResponse response, FilterChain filterChain) throws ServletException, IOException {
        //권한을 주거나 주지 않는다 ( 입장 ex) 티켓 확인)
        //개찰구 역할
        //현재는 모두 닫혀 있습니다

        final String authorizationHeader = request.getHeader(HttpHeaders.AUTHORIZATION);
        log.info("authorizationHeader:{}", authorizationHeader);

        if (authorizationHeader == null || !authorizationHeader.startsWith("Bearer ")) {
            filterChain.doFilter(request, response);
            return;
        }

        //토큰만 분리해야한다
        String token;
        try {
            token = authorizationHeader.split(" ")[1];
        } catch (Exception e) {//요청시 token이 없으면
            log.error("token 추출에 실패 했습니다");
            filterChain.doFilter(request, response);
            return;
        }

        //JWTTokenUtil.
        if (JwtUtil.isExpired(token, secretKey)) {
            filterChain.doFilter(request, response);
            return;
        }

        // Token에서 userName 꺼내기
        String userName = JwtUtil.getUserEmail(token, secretKey);
        log.info("username:{}", userName);

        //userDetail 가져오기
        UserDto user = userService.findByUsername(userName);
        log.info("userEmail:{}", user.getEmail());

        //문 열어주기, role 바인딩
        UsernamePasswordAuthenticationToken authenticationToken = new UsernamePasswordAuthenticationToken(user.getEmail(), null, List.of(new SimpleGrantedAuthority(user.getEmail()))); //권한을 여러개 줄 수 있다
        authenticationToken.setDetails(new WebAuthenticationDetailsSource().buildDetails(request));
        SecurityContextHolder.getContext().setAuthentication(authenticationToken);//권한 부여 (이 문을 통과할 수 있다는 것)
        filterChain.doFilter(request, response);

    }
}

package com.javaex.config;

import com.javaex.service.UserService;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.http.HttpMethod;
import org.springframework.security.config.annotation.web.builders.HttpSecurity;
import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
import org.springframework.security.config.http.SessionCreationPolicy;
import org.springframework.security.web.SecurityFilterChain;
import org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter;

@EnableWebSecurity
@Configuration
@RequiredArgsConstructor
public class SecurityConfig {

    private final UserService userService;
    @Value("${jwt.token.secret}")
    private String secretKey;
    @Bean
    public SecurityFilterChain securityFilterChain(HttpSecurity httpSecurity) throws Exception {
        return httpSecurity
                .httpBasic().disable()
                .csrf().disable()
                .cors().and()
                .authorizeRequests()
                .antMatchers("/boggle/user/join", "/boggle/user/login").permitAll() // join, login은 언제나 가능
                .antMatchers("/boggle/review/**").permitAll()
                .antMatchers(HttpMethod.POST, "/api/v1/**").authenticated()//문 만들기(인증된 사용자의 접근 허용)
                .and()
                .sessionManagement()
                .sessionCreationPolicy(SessionCreationPolicy.STATELESS) // jwt사용하는 경우 씀 -> 프런트에서 처리
                .and()
                .addFilterBefore(new JwtTokenFilter(secretKey, userService), UsernamePasswordAuthenticationFilter.class) //UserNamePasswordAuthenticationFilter적용하기 전에 JWTTokenFilter를 적용 하라는 뜻 입니다.
                //로그인을 한 다음에 받은 토큰
                .build();
    }
}

---

13. org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'nickname' from result set. Cause: java.sql.SQLDataException: Cannot determine value type from string '서윤이'

14. org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'email' from result set.

• @NoArgsConstructor 추가 했음

---

15. InternalAuthenticationServiceException: A granted authority textual representation is required

• 테스트 아이디 생성 당시 권한은 입력하지 않고 회원 내용만 입력함. 권한을 확인할 수 없어서 로그인이 되지 않음
  DB에 권한 입력해줌

16. 👉 Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause

• https://hodolman.com/38

• @AuthenticationPrincipal User user로 받던 것을 삭제하고 하위 코드로 변경
  

• 📌https://sillutt.tistory.com/entry/Spring-Security-AuthenticationPrincipal%EA%B3%BC-ArgumentResolver

17. java.lang.ClassCastException: class java.lang.Long cannot be cast to class java.lang.Integer (java.lang.Long and java.lang.Integer are in module java.base of loader 'bootstrap')

JPA는 count return 값이 Long, mybatis는 int이다
Long으로 xml 파일에 resultType을 Long으로 지정해줘서 타입이 맞지 않아서 일어난 에러

---

18. org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'securityConfig' defined in file [/Users/seoyun/boggle-refactoring/boggle-bookproject-refactoring/out/production/classes/com/javaex/config/SecurityConfig.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userService' defined in file [/Users/seoyun/boggle-refactoring/boggle-bookproject-refactoring/out/production/classes/com/javaex/service/UserService.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userDao' defined in file [/Users/seoyun/boggle-refactoring/boggle-bookproject-refactoring/out/production/classes/com/javaex/dao/UserDao.class]: Cannot resolve reference to bean 'sqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSessionTemplate' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Unsatisfied dependency expressed through method 'sqlSessionTemplate' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [/Users/seoyun/boggle-refactoring/boggle-bookproject-refactoring/out/production/resources/mybatis/mysqlmappers/mybook-mysql.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [/Users/seoyun/boggle-refactoring/boggle-bookproject-refactoring/out/production/resources/mybatis/mysqlmappers/mybook-mysql.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'reviewNoAndUserNo'. Cause: java.lang.ClassNotFoundException: Cannot find class: reviewNoAndUserNo

• xml resultMap 사용시 result 타입을
  resultType이 아닌 resultMap으로 지정해줘야하는데 resultType으로 해놔서 찾지 못함

<resultMap id="reviewNoAndUserNo" type="map">
		<result property="userNo" column="user_no"/>
		<result property="reviewNo" column="review_no"/>
</resultMap>

<!-- reviewByUser -->
<select id="reviewByUser" resultMap="reviewNoAndUserNo" parameterType="Long">
		<![CDATA[
        select user_no   userNo,
               review_no reviewNo
        from review
        where review_no = #{reviewNo}
        ]]>
</select>

---

19. Error querying database. Cause: java.lang.IndexOutOfBoundsException: Index 4 out of bounds for length 4

• @NoArgsConstructor 추가

@Getter
@AllArgsConstructor
@NoArgsConstructor

---

20. Duplicate entry for key 'PRIMARY'

• https://codinghero.tistory.com/24
  이건 말 그대로 내가 Insert 나 Update하기 위한 값이 Primary 값이라 동일한 값으로 쿼리문을 실행 할 수 없다는 의미입니다.

• keyProperty="reviewUserNo" -> keyProperty="review_user_no"
  테이블 컬럼명과 맞춰줘야한다

<insert id="reviewLike" parameterType="map">
		<selectKey keyProperty="review_user_no" resultType="Long" order="BEFORE">
			SELECT LAST_INSERT_ID()
		</selectKey>
		<![CDATA[
        insert into review_user
        values (#{reviewUserNo}, #{userNo}, #{reviewNo}, now())
        ]]>
	</insert>

---

21. The alias 'LikePlayListDto' is already mapped to the value 'com.javaex.dto.playlist.LikePlaylistDto'.