mysql 比较隐秘的问题

2017-11-13 13:47:27:DEBUG DubboServerHandler-192.168.30.114:20990-thread-5 com.yryz.qshop.modules.indexconfig.dao.IndexTypeDao.queryIndexTypes - <== Total: 10
2017-11-13 13:47:33:DEBUG DubboServerHandler-192.168.30.114:20990-thread-6 com.yryz.qshop.modules.indexconfig.dao.IndexTypeDao.queryIndexTypes_COUNT - ==> Preparing: SELECT count(*) FROM qshop_index_type WHERE 1 = 1 AND config_name = ?
2017-11-13 13:47:33:DEBUG RMI TCP Connection(127.0.0.1:2181) org.apache.zookeeper.ClientCnxn - Got ping response for sessionid: 0x15fa4a9c56f0010 after 0ms
2017-11-13 13:47:33:ERROR DubboServerHandler-192.168.30.114:20990-thread-6 com.yryz.qshop.modules.indexconfig.service.IndexTypeService - 查询IndexType列表信息失败!,indexTypeDto:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='configName', mode=IN, javaType=class java.lang.String, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).

乍一看 没问题 。把注掉的部分去掉就不报错了。

原文地址:https://www.cnblogs.com/austinspark-jessylu/p/7826059.html