-
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement '*'. It's likely that neither a Result Type nor a Result Map was specifi..5. 그 외 공부/5.1 ERROR 2023. 10. 13. 10:05
Test 코드를 작성하던 중 해당 에러코드가 나왔다
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement '*'. It's likely that neither a Result Type nor a Result Map was specified.
(에러코드 블라블라.....)
Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement '*.saveInfo'. It's likely that neither a Result Type nor a Result Map was specified.
<select id="saveInfo" statementType="CALLABLE" parameterType="com.project.concertView.domain.dao.member.SaveMember"> {call INSERT_ALL( #{name},#{loginId}, #{address}, #{email}, #{password}, now(),#{birth},#{phoneNumber},#{detailAddress}) } </select>
해당 쿼리에서 resultType을 추가해주니 해결됐다.
<select id="saveInfo" statementType="CALLABLE" parameterType="com.project.concertView.domain.dao.member.SaveMember" resultType="java.util.HashMap"> {call INSERT_ALL( #{name},#{loginId}, #{address}, #{email}, #{password}, now(),#{birth},#{phoneNumber},#{detailAddress}) } </select>
'5. 그 외 공부 > 5.1 ERROR' 카테고리의 다른 글