mybatis异常:Improper inline parameter map format. Should be: #{propName,attr1=val1,attr2=val2}问题分析及解决
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Improper inline parameter map format. Should be: #{propName,attr1=val1,attr2=val2}
<insert id="insertXXOrder" parameterType="yyOrder">
insert into XX_ORDER(
。。。,
MX_NOTIFY_URL
)
values(
。。。,
#{mxNotifyUrl,jdbcType = VARCHAR}
)
分析:
mybatis规范写法:“#{propName,attr1=val1,attr2=val2}”,“=”号左右两边均无空格
因此:
“#{mxNotifyUrl,jdbcType = VARCHAR}”正确写法:“#{mxNotifyUrl,jdbcType=VARCHAR}”