mysql 比较隐秘的问题

最新推荐文章于 2024-07-24 13:38:39 发布

weixin_34055910

最新推荐文章于 2024-07-24 13:38:39 发布

阅读量96

点赞数

文章标签：数据库 java 大数据

本文记录了一次使用Dubbo框架进行服务调用时出现的异常情况及其排查过程。具体表现为在查询IndexType列表信息时抛出了MyBatisSystemException异常，通过逐步分析找到了导致问题的原因并解决了该异常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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).