springboot + mybatis 페이징처리 오류

Question

springboot + mybatis 페이징처리controller@GetMapping("/post/listForm/{userId}")public String list(@PathVariable Integer userId, @RequestParam(name="page", required = false) Integer page, Model model, @RequestParam(name="keyword", required = false) String keyword) {User principal = (User) session.getAttribute("principal");if (page == null) {page = 0;}Integer startNum = page * 5;if (keyword == null || keyword.isEmpty()) {PagingRespDto paging = postRepository.paging(page, userId, null);paging.makeBlockInfo();model.addAttribute("postCount", postRepository.postCount(userId, null)); // 전체게시글 개수model.addAttribute("paging", paging); // 페이징model.addAttribute("postList",postRepository.findAllPost(userId,null, startNum));model.addAttribute("categoryList", categoryRepository.findByUserId(userId));model.addAttribute("user", userRepository.findById(userId));if (principal != null) {model.addAttribute("userImg", userRepository.findById(principal.getUserId()));}}if (principal != null) {List postList = postRepository.findAllPost(principal.getUserId(), keyword,startNum);model.addAttribute("postList", postList); // 블로그 전체게시글PagingRespDto paging = postRepository.paging(page, userId, keyword);paging.makeBlockInfoByPostAll(keyword);model.addAttribute("postCount", postRepository.postCount(userId, keyword)); // 전체게시글 개수model.addAttribute("paging", paging); // 페이징model.addAttribute("categoryList", categoryRepository.findByUserId(userId)); // 사이드바 카테고리 이동 => 공통model.addAttribute("user", userRepository.findById(userId));model.addAttribute("userImg", userRepository.findById(principal.getUserId()));}else {List postList = postRepository.findAllPost(userId, keyword,startNum);model.addAttribute("postList", postList); // 블로그 전체게시글PagingRespDto paging = postRepository.paging(page, userId, keyword);paging.makeBlockInfoByPostAll(keyword);model.addAttribute("postCount", postRepository.postCount(userId, keyword)); // 전체게시글 개수model.addAttribute("paging", paging); // 페이징model.addAttribute("categoryList", categoryRepository.findByUserId(userId)); // 사이드바 카테고리 이동 => 공통}return "/post/listForm";}xmlrepositorypublic PagingRespDto paging(@Param("page") Integer page, @Param("userId") Integer userId, @Param("keyword") String keyword);PagingRespDtopackage shop.mtcoding.tstory.dto.paging;import lombok.Getter;import lombok.Setter;@Setter@Getterpublic class PagingRespDto {private Integer blockCount; // 상수 한페이지에 페이지 넘수 개수(5) 1-5, 6-10private Integer currentBlock;private Integer startPageNum;private Integer lastPageNum;private Integer totalCount;private Integer totalPage;private Integer currentPage;private boolean isLast;private boolean isFirst;private String keyword;public void makeBlockInfo() {this.blockCount = 5;this.currentBlock = currentPage / blockCount;this.startPageNum = 1 + blockCount * currentBlock; // 1this.lastPageNum = 5 + blockCount * currentBlock; // 5if (totalPage < lastPageNum) {this.lastPageNum = totalPage;}}public void makeBlockInfoByPostAll(String keyword) {this.keyword = keyword;this.blockCount = 5;this.currentBlock = currentPage / blockCount;this.startPageNum = 1 + blockCount * currentBlock; // 1this.lastPageNum = 5 + blockCount * currentBlock; // 5if (totalPage < lastPageNum) {this.lastPageNum = totalPage;}}public void makeBlockInfoByCategoryPostAll(String keyword) {this.keyword = keyword;this.blockCount = 5;this.currentBlock = currentPage / blockCount;this.startPageNum = 1 + blockCount * currentBlock; // 1this.lastPageNum = 5 + blockCount * currentBlock; // 5if (totalPage < lastPageNum) {this.lastPageNum = totalPage;}}}인데 왜 There was an unexpected error (type=Internal Server Error, status=500).### Error querying database. Cause: org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214] ### The error may exist in file [C:\Users\shim5\OneDrive\바탕 화면\Springboot-Mybatis-Final-Tstory\bin\main\mapper\post.xml] ### The error may involve shop.mtcoding.tstory.model.post.PostRepository.paging ### The error occurred while executing a query ### SQL: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p ### Cause: org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214] ; uncategorized SQLException; SQL state [HY004]; error code [50004]; Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214]; nested exception is org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214]org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214] ### The error may exist in file [C:\Users\shim5\OneDrive\바탕 화면\Springboot-Mybatis-Final-Tstory\bin\main\mapper\post.xml] ### The error may involve shop.mtcoding.tstory.model.post.PostRepository.paging ### The error occurred while executing a query ### SQL: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p ### Cause: org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214] ; uncategorized SQLException; SQL state [HY004]; error code [50004]; Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214]; nested exception is org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "CURRENTPAGE"; SQL statement: SELECT p.totalCount, p.totalPage, p.currentPage, (CASE currentPage WHEN 0 THEN 1 ELSE 0 END) AS first, (CASE currentPage WHEN totalPage-1 THEN 1 ELSE 0 END) AS last FROM ( SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage, 0 AS first, 0 AS last FROM post_tb WHERE user_id = ? ) p [50004-214]스프링부트를 독학하고 있습니다페이징 처리 중 이런 오류가 발생합니다오류 수정 방법 알려 주실 수 있을까요?

xml개발자 · Answer

오류 내용만 보면 CURRENTPAGE 포맷을 확인해야할 것 같네요.db 내 CURRENTPAGE와 java에서 형식을 같이 확인해보세요.

리락쿠마 · Answer

쿼리에서는 userId를 뽑고 있는데 model.addAttribute() 할때는 user로 하고 있어서 값이 안뽑힐꺼에요.paging도 마찬가지 입니다.model.addAttribute의 key값을 설정할때 동일한 이름으로 key값 설정해보세요.key값 맞추지 않으면 스프링에서 자동으로 맵핑 안될거에요

springboot + mybatis 페이징처리 오류

2개의 답변

Q&A 목록