关于Mybatis 使用MySql存储过程的问题

Question

mybatis 通过xml方式使用mysql的存储过程,在本地测试的时候一切正常,但是放到服务器上执行的sql语句就变了
在本地测试的时候执行的是

 {call p_mishi_selectFavoriteList(?)} 

在服务器上就变成了

 select count(0) from ({call p_mishi_selectFavoriteList(?)}) tmp_count

请问各位大神知道是什么问题么?

一下是配置

 <select id="selectFavoriteList" parameterType="java.lang.Long" resultMap="mapForFavoriteList" statementType="CALLABLE">
<![CDATA[{call p_mishi_selectFavoriteList(#{userid,jdbcType=BIGINT,mode=IN})}]]>
</select>
<resultMap type="com.mishi.app.model.Favorite" id="mapForFavoriteList">
   <id column="favorite_id" jdbcType="BIGINT" property="id" />
    <result column="favorite_addTime" jdbcType="TIMESTAMP" property="addtime" />
    <result column="favorite_deleteStatus" jdbcType="BIT" property="deletestatus" />
    <result column="type" jdbcType="INTEGER" property="type" />
    <result column="goods_id" jdbcType="BIGINT" property="goodsId" />
    <result column="store_id" jdbcType="BIGINT" property="storeId" />
    <result column="user_id" jdbcType="BIGINT" property="userId" />
</resultMap>

调用:

 List<Favorite> favList = favoriteMapper.selectFavoriteList(userId);

Answer 1

http://blog.csdn.net/bao19901210/article/details/50602343