xml中
<parameterMap id="cardPayCredit" class="map" >
<parameter property="userName" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="courseId" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="organId" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="cardNum" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="cardPasswd" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="payState" jdbcType="number" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
<procedure id="cardPayCredit" parameterMap="cardPayCredit" resultClass="java.lang.Integer">
<![CDATA[
{call ncme_cardPayCredit(?, ?, ?, ?, ?)}
]]>
</procedure>
从oracle中返回integer类型,但是报org.springframework.jdbc.UncategorizedSQLException: (SqlMapClientTemplate): encountered SQLException [
--- The error occurred in com/haoyisheng/ncme/dao/ibatis/maps/PayCredit.xml.
--- The error occurred while executing query procedure.
--- Check the {call ncme_cardPayCredit(?, ?, ?, ?, ?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: 无效的列类型]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/haoyisheng/ncme/dao/ibatis/maps/PayCredit.xml.
--- The error occurred while executing query procedure.
--- Check the {call ncme_cardPayCredit(?, ?, ?, ?, ?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: 无效的列类型请问resultClass该写成什么类型???
<parameterMap id="cardPayCredit" class="map" >
<parameter property="userName" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="courseId" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="organId" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="cardNum" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="cardPasswd" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN"/>
<parameter property="payState" jdbcType="number" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
<procedure id="cardPayCredit" parameterMap="cardPayCredit" resultClass="java.lang.Integer">
<![CDATA[
{call ncme_cardPayCredit(?, ?, ?, ?, ?)}
]]>
</procedure>
从oracle中返回integer类型,但是报org.springframework.jdbc.UncategorizedSQLException: (SqlMapClientTemplate): encountered SQLException [
--- The error occurred in com/haoyisheng/ncme/dao/ibatis/maps/PayCredit.xml.
--- The error occurred while executing query procedure.
--- Check the {call ncme_cardPayCredit(?, ?, ?, ?, ?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: 无效的列类型]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/haoyisheng/ncme/dao/ibatis/maps/PayCredit.xml.
--- The error occurred while executing query procedure.
--- Check the {call ncme_cardPayCredit(?, ?, ?, ?, ?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: 无效的列类型请问resultClass该写成什么类型???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货