EnumTypeHandler problem mybatis v3.5.11

[Brian Hurley]

I'm trying to implement ENUMs  rather than passing them as a string to mybatis using the EnymTypeHandler

Here is my ENUM

public enum UserStatus {

  ACTIVE,

  INACTIVE,

  DELETE

}

MODEL file has UserStatus defined as ‘status’

private UserStatus status = null;

In my userMapper.xml

RESULT MAP…

<result property="status" column="status" typeHandler="org.apache.ibatis.type.EnumTypeHandler"/>

INSERT…

 #{status, typeHandler=org.apache.ibatis.type.EnumTypeHandler},

UPDATE…

status = #{status, typeHandler=org.apache.ibatis.type.EnumTypeHandler},

I get error that argument type mismatch.   The database fields have the String values of ‘ACTIVE’ || ‘INACTIVE’ etc.

Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: Could not set property 'status' of 'class com.elsevier.topicpages.model.User' with value 'ACTIVE' Cause: java.lang.IllegalArgumentException: argum

ent type mismatch

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)

at jdk.proxy2/jdk.proxy2.$Proxy65.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)

What am I missing on this?   Do I need to implement a specific EnumTypeHandler for UserStatus?

[Iwao AVE!]

Hello Brian,

EnumTypeHandler is different from the normal type handlers and it requires a special configuration.

The simple rule is:

- Do not specify `typeHanlder`

- Specify `javaType` instead.

So, it should look like this:

RESULT MAP…
<result property="status" column="status" javaType="x.y.UserStatus" />

INSERT…
 #{status,javaType=x.y.UserStatus},

UPDATE…
status = #{status,javaType=x.y.UserStatus},

In some cases, it works with or without `javaType`.

And in other cases, it works even if `typeHandler` is specified, but it should always work if you follow the above rule.

If you have any difficulty, please create a small demo project and share it on your GitHub repository.

Here are some project templates.

https://github.com/harawata/mybatis-issues

Regards,

Iwao

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/46cc00c8-d18e-46d7-9291-abc280c6f8d5n%40googlegroups.com.

[Brian Hurley]

Thanks Iwao for the response.  However, I've tried what you suggested and still have issues.   I've make a mybatis-issues project ( I didn't know what gh-# to make it so I called it gh-enum). I can change this if you want.

If you have time please look at https://github.com/brhurley/mybatis-issues/tree/master/gh-enum

Thanks
Brian

[Iwao AVE!]

It was just a few mistakes, it seems.

I have pushed the correction. Please check the commit log.

// Iwao

To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/bff3cf67-d868-4667-b11e-9810d443a4a6n%40googlegroups.com.

[Brian Hurley]

Thank you that fixed the problem!

Brian

To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/CA%2Buep2Qf8-snVmRSmq_%2BMyJ%3DrJO7Gt9XrbN_vRhRQGK1yKvd8Q%40mail.gmail.com.