I have been trying to figure out a error for the past few day unsuccessfully so now I am turning to you all for help. I am calling a stored procedure on iSeries V5 (DB2) database with 4 VARCHAR parameters which are mode=IN and 1 INT parameter which is mode=INOUT.
Here is the error message:
--- The error occurred while applying a parameter map.
--- Check the SearchCriteria.resourceTypesParms.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Data type mismatch.
Here is the parameterMap, resultMap and procedure statement I used:
The error message seems very specific pointing to the INOUT parm in the parameterMap, but I am not sure why this is causing an error. The iBatis jars that I am currently using are: ibatis-common-2_20040820.jar and ibatis-sqlmap-2_20040820.jar. Any help as to what might be causing this error is greatly appreciated. Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been trying to figure out a error for the past few day unsuccessfully so now I am turning to you all for help. I am calling a stored procedure on iSeries V5 (DB2) database with 4 VARCHAR parameters which are mode=IN and 1 INT parameter which is mode=INOUT.
Here is the error message:
--- The error occurred while applying a parameter map.
--- Check the SearchCriteria.resourceTypesParms.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Data type mismatch.
Here is the parameterMap, resultMap and procedure statement I used:
<parameterMap id="resourceTypesParms" class="com.mbh.esln.LifeMgmt.domain.IPParms" >
<parameter property="caseNumber" jdbcType="CHAR" javaType="java.lang.String" mode="IN" />
<parameter property="callNumber" jdbcType="CHAR" javaType="java.lang.String" mode="IN" />
<parameter property="callSequence" jdbcType="CHAR" javaType="java.lang.String" mode="IN" />
<parameter property="callGroup" jdbcType="CHAR" javaType="java.lang.String" mode="IN" />
<parameter property="rc" jdbcType="INT" javaType="int" mode="INOUT" />
</parameterMap>
<resultMap id="resourceTypesResults" class="com.mbh.esln.LifeMgmt.domain.ResourceTypes">
<result property="providerType" column="spProviderType" columnIndex="1" />
<result property="providerDesc" column="spProviderDesc" columnIndex="2" />
<result property="resourceType" column="spResourceType" columnIndex="3" />
<result property="resourceDesc" column="spResourceDesc" columnIndex="4" />
</resultMap>
<procedure id="getResourceTypes" parameterMap="resourceTypesParms" resultMap="resourceTypesResults">
{call spGetLifeMgmtResourceSelections (?, ?, ?, ?, ?)}
</procedure>
The error message seems very specific pointing to the INOUT parm in the parameterMap, but I am not sure why this is causing an error. The iBatis jars that I am currently using are: ibatis-common-2_20040820.jar and ibatis-sqlmap-2_20040820.jar. Any help as to what might be causing this error is greatly appreciated. Thank you.