MyBatis - how to define array in mybatis xml mapper file

Question

I would like to define array of string in mybatis mapper and pass it as argument for java static method. It's possible?

I don't think there's an out of the box TypeHandler for it (I may be wrong). However, it should be pretty straightforward to write one for arrays. See mybatis.org/mybatis-3/configuration.html#typeHandlers. Essentialy, you just need to create a class that extends mybatis.org/mybatis-3/apidocs/org/apache/ibatis/type/… and then tell MyBatis which column(s) should use it (while reading and storing data). — The Impaler
– The Impaler, Commented Dec 2, 2021 at 17:41
Maybe there is an out of the box Array Type Handler, but I haven't tried it. See mybatis.org/mybatis-3/apidocs/org/apache/ibatis/type/… — The Impaler
– The Impaler, Commented Dec 2, 2021 at 17:42
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. — Community
– Community Bot, Commented Dec 7, 2021 at 13:33

Dawid Pawlak · Accepted Answer · 2021-12-06 14:32:50Z

0

Found one solution, I can define array in 'bind' tag and then pass it to method as argument:

        <bind name='exampleArray' value='{"one", "two", "three"}'/>
        ${@com.example.MybatisUtil@generate(exampleArray)}

answered Dec 6, 2021 at 14:32

Dawid Pawlak

12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1