nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping

错误描述

2019-10-18 15:46:00.827 [http-nio-9011-exec-16] ERROR net.chenlin.dp.common.exception.RRExceptionHandler - 全局异常捕获：[nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=‘allocationNum’, mode=IN, javaType=class java.lang.Integer, jdbcType=null, numericScale=null, resultMapId=‘null’, jdbcTypeName=‘null’, expression=‘null’}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer @net.chenlin.dp.modules.device.service.impl.Pub2GBluetoothServiceImpl.addForeOpenNew(Pub2GBluetoothServiceImpl.java:787)], 请求URL：[POST][/api/restuetooth/deviceForeNew/open]

原因是mapper接口里的方法传入的参数类型市String

而xml文件中的sql的parameterType类型是Integer


把它们的类型改成一样的就行了