500 에러 :: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement

There was an unexpected error (type=Internal Server Error, status=500).

nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.calmstagram.user.DAO.UserDAO.selectUserByLoginId'. It's likely that neither a Result Type nor a Result Map was specified.

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.calmstagram.user.DAO.UserDAO.selectUserByLoginId'. It's likely that neither a Result Type nor a Result Map was specified.

​

​

ㅁ원인

-> Mapper, DAO return값이랑 resultType이 안 맞음.

int로 return해야 하는데

 

		SELECT
			`id` 
			,`loginId`
			,`password`
			,`name`
			,`email`
			,`createdAt`
			,`updatedAt`
		FROM `user`
		WHERE 
			`loginId` = #{loginId};

==> 테이블로 리턴

​

​

*수정

		SELECT
			count(1)
		FROM `user`
		WHERE 
			`loginId` = #{loginId};