【mybatis】 org.apache.ibatis.builder.BuilderException

迷南。 2022-04-25 10:14 180阅读 0赞

mybatis异常

Caused by: org.apache.ibatis.builder.BuilderException: Improper inline parameter map format.  Should be: #{propName,attr1=val1,attr2=val2}
      at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.parseParameterMapping(SqlSourceBuilder.java:144)
      at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:78)
      at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:73)
      at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:47)
      at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:54)
      at org.apache.ibatis.builder.xml.dynamic.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:40)
      at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:241)
      at org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:61)
      at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:36)
      at org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:42)
      at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:348)
      at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:43)
      at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
      at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
      at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
      at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
      ... 70 more

mapper中的参数有问题

本实例异常原因：jdbcType=VARCHAR  等号两边加空格了

解决方法：

d.batch\_code = \#\{batchCode,jdbcType=VARCHAR\}，其中jdbcType=VARCHAR等号两边不能加空格