페이징 처리중인데 오류 원인과 해결방법 좀 알려주세요.......

Question

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()));}}return "/post/listForm";}repositorypublic PagingRespDto paging(@Param("page") Integer page, @Param("userId") Integer userId, @Param("keyword") String keyword);xml오류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 lastFROM (SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage,0 AS first, 0 AS lastFROM post_tbWHERE 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.pagingThe 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 lastFROM (SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage,0 AS first, 0 AS lastFROM post_tbWHERE 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 lastFROM (SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage,0 AS first, 0 AS lastFROM post_tbWHERE 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 lastFROM (SELECT COUNT() AS totalCount, CEILING(COUNT()/5) AS totalPage, ? AS currentPage,0 AS first, 0 AS lastFROM post_tbWHERE user_id = ?) p [50004-214]at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:93)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)여기서 왜 #{page}와 #{userId}의 값이 ? 로 표시 되는 오류가 발생하는지 모르겠습니다.;....해결방법과 오류의 원인 알려주세요 ㅜㅜ

하태연 · Answer

일단.. page와 userId 값이 제대로 들어오고 Query 실행하기 전까지 제대로 세팅되어 있는지 디버깅 먼저 하셔야 할 것 같습니다.<select id="paging" resultType="shop.mtcoding.tstory.dto.paging.PagingRespDto" parameterType="java.lang.Integer">그나저나 이 부분을 보니까 parameterType 부분이 잘못된 것 같습니다. page와 userId 값이 파라미터로 들어온 건데 Integer로만 하면 값이 제대로 안 들어올 것 같네요.

페이징 처리중인데 오류 원인과 해결방법 좀 알려주세요.......

1개의 답변

Q&A 목록