Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: 原创

Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect INTEGER value: 'FR'

拼接字符串 MySQL 写成 Oracle 的形式了。

Oracle 

<isNotEmpty property="channel" prepend="and">
TICKET_TYPE like '%'||#channel#||'%'
</isNotEmpty>

MySQL 

<isNotEmpty property="bankNum" prepend="and">
TICKET_NUMBER like concat('%', #bankNum#, '%')
</isNotEmpty>