File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes jdbctype for enum in parameterMap's parameter in IBATIS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "jdbctype for enum in parameterMap Watch "jdbctype for enum in parameterMap New topic

jdbctype for enum in parameterMap's parameter in IBATIS

vishnu neerukattu

Joined: Aug 16, 2007
Posts: 15
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"/>

<procedure id="test" parameterMap="addParameters">
{call temp.sp_SET_values(?,?,?,?,?,?)}
Dhananjay Patkar

Joined: Aug 12, 2008
Posts: 8
Hi Vishnu,
You need to provide a type handler in case of custom types such as enums
You need to write a class which will implement
and provide implementation for
public Object getResult(ResultGetter getter)throws SQLException
public void setParameter(ParameterSetter setter, Object parameter)throws SQLException

Here's a simple example of a boolean handler that uses "Yes" and "No":
I agree. Here's the link:
subject: jdbctype for enum in parameterMap's parameter in IBATIS