[Mybatis] A query was run and no Result Maps were found for the Mapped Statement

Mybatis Enum Typehandler 관련해서 예제를 작성해보다가 오류 발견

아래는 메시지 내용

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 'com.sample.mybatis.mapper.MyBatisSampleMapper.getBoardAll'.  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 'com.sample.mybatis.mapper.MyBatisSampleMapper.getBoardAll'.  It's likely that neither a Result Type nor a Result Map was specified.
	....
	... 72 more

중요한 메시지는 

A query was run and no Result Maps were found for the Mapped Statement 'com.sample.mybatis.mapper.MyBatisSampleMapper.getBoardAll'.  It's likely that neither a Result Type nor a Result Map was specified.
...
A query was run and no Result Maps were found for the Mapped Statement 'com.sample.mybatis.mapper.MyBatisSampleMapper.getBoardAll'.  It's likely that neither a Result Type nor a Result Map was specified.
....
... 72 more

 

스프링 프레임워크를 포함한 잘 만들어진 프레임워크들은 오류 메시지 내용 자체가 너무 친절하다.

발번역 해보자면 쿼리가 실행되었지만 Result Type이나 Result Map이 지정되지 않았을 거라고 한다.

따라가서 봤더니 실제로 그렇게 되어있음.

<select id="getBoardAll">
    SELECT BNO
         , TITLE
         , CONTENT
         , REGDATE
         , BTYPE
    FROM BOARD_TBL
</select>

해결

<select id="getBoardAll" resultType 또는 resultMap 작성>
    SELECT BNO
         , TITLE
         , CONTENT
         , REGDATE
         , BTYPE
    FROM BOARD_TBL
</select>