How to handle Like operator in MyBatis when a bind variable is null

Question

Problem with the following code when bind variable is NULL:

<bind name="recipientName" value="'%'+recipientName+'%'"/>

How to handle Like operator in MyBatis when a bind variable is null?

@pau Sorry i didn't get your question, Here the problem is if recipientName is null then mybatis is throwing an exception saying, cannot concat %,null. — akreddy.21, Nov 22 '16 at 08:35
Ok, then could you add the error trace?, it would help to see what is happening — Pau, Nov 22 '16 at 08:37
@pau i got solution for this ,i posted it below . Thanks for your help. — akreddy.21, Nov 22 '16 at 09:03

score 0 · Answer 1 · answered Nov 22 '16 at 09:02

0

    <if test = "recipientName != null">
       <bind name="recipientName" value="'%'+recipientName+'%'"/>
    </if> resolved the issue.

answered Nov 22 '16 at 09:02

akreddy.21

4

While this code snippet may solve the question, [including an explanation](//meta.stackexchange.com/questions/114762/explaining-entirely-code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. Please also try not to crowd your code with explanatory comments, this reduces the readability of both the code and the explanations! – kayess Nov 22 '16 at 10:40

1 Answers1