wood burning stoves
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: http://aspose.com/file-tools
subject: jdbctype for enum in parameterMap's parameter in IBATIS
It's not a secret anymore!