| Author |
Error in updating a table in mysql using IBATIS
|
vishnu neerukattu
Greenhorn
Joined: Aug 16, 2007
Posts: 15
|
|
Hi, I am trying to update a table in mysql using ibatis and I have to update an enum value and I have given jdbctype for that property as varchar. when I am executing in I am getting an error as below.can someone help me in this regard. Please find the code below here strModRole is declared as enum in the procedure. <parameterMap id="addParameters" class="java.util.Map" > <parameter property="strDrs" jdbcType="FLOAT" javaType="java.lang.Float" mode="IN"/> <parameter property="strUts" jdbcType="FLOAT" javaType="java.lang.Float" mode="IN"/> <parameter property="strRout" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> <parameter property="strSer" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> <parameter property="strModId" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> <parameter property="strModRole" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> </parameterMap> <procedure id="test" parameterMap="addParameters"> {call temp.sp_SET_values(?,?,?,?,?,?)} The error is as below Cause: java.sql.SQLException: Data truncated for column 'in_mod_role' at row 1> com.ibatis.common.jdbc.exception.NestedSQLException:
|
 |
 |
|
|
subject: Error in updating a table in mysql using IBATIS
|
|
|