org.apache.ibatis.binding.BindingException: Mapper method 'com.XXXXX' attempted toreturn null from a method with a primitive return type (int).
<select id="selectPageviews" resultType="java.lang.Integer" >
select sum( yc_hobby_pageviews )
from SCOTT.yc_hobby_course
where
yc_hobby_course_user_id=#{yc_hobby_course_user_id}
</select>
oracle 的解决方式 改为
<select id="selectPageviews" resultType="java.lang.Integer" >
select NVL(sum( yc_hobby_pageviews ),0)
from SCOTT.yc_hobby_course
where
yc_hobby_course_user_id=#{yc_hobby_course_user_id}
</select>
mysql 的解决方式为 select IFFULL(sum(yc_hobby_pageviews ),0) from ....
sqlserver 的解决方式 select ISNULL(sum(yc_hobby_pageviews ),0) ...
所有数据库 可以
select COALESCE(sum(yc_hobby_pageviews ),0) ...