dean丶Li 2022-01-16 15:56 采纳率: 0%
浏览 232

用myabtis查询list结果集时报错InvocationTargetException : null

mybatis在执行查询返回list集合的时候报错，数据库是mysql， 每次都能重现，特别诡异
问题代码块


  private List<CallTransTask> getCallTransTask() {
        return queryTransTaskMapper.queryUndoneTranTasks();
    }

public interface QueryTransTaskMapper {

    List<CallTransTask> queryUndoneTranTasks();
}


<mapper namespace="com.fenqile.oa.telemarketing.dao.QueryTransTaskMapper">
  <resultMap id="BaseResultMap" type="com.fenqile.oa.telemarketing.model.CallTransTask">
    <result column="Ftask_no" jdbcType="VARCHAR" property="ftaskNo" />
    <result column="Fcallback_json" jdbcType="VARCHAR" property="fcallbackJson" />
  </resultMap>
  <select id="queryUndoneTranTasks" resultType="com.fenqile.oa.telemarketing.model.CallTransTask">
    select IFNULL(Ftask_no, '') as Ftask_no,IFNULL(Fcallback_json, '') as Fcallback_json
    from t_call_trans_task
    where 1=1
      and Fis_finished = 1
      and Fis_callback = 1
      and Fis_write2db = 0
      and Fuse_flag = 1
      and Fcreate_time > date_add(now(), interval -6 day)
  </select>
运行结果及报错内容
2022-01-16 15:43:29.252|25060|xxx||ERROR|com.fenqile.oa.common.plugin.SqlInterceptor|intercept|47|UID=,SESSIONID=,ENV=,SET=|SqlInterceptor intercept exception: {}|xxx:server_oa_gateway->xxx:25250:com.fenqile.oa.telemarketing.service.CallTransTaskService:1.0.0#getCallTransResult
java.lang.reflect.InvocationTargetException: null
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
    at com.fenqile.oa.common.plugin.SqlInterceptor.intercept(SqlInterceptor.java:45)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
    at com.sun.proxy.$Proxy68.query(Unknown Source)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.transform.MySqlSessionTemplate$SqlSessionInterceptor.invoke(MySqlSessionTemplate.java:399)
    at com.sun.proxy.$Proxy38.selectList(Unknown Source)
    at com.fenqile.dao.transform.MySqlSessionTemplate.selectList(MySqlSessionTemplate.java:232)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:122)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.datasource.mapper.MapperInterceptor.invoke(MapperInterceptor.java:54)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.datasource.mapper.TraceInterceptor.invoke(TraceInterceptor.java:28)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl.getCallTransTask(CallTransTaskServiceImpl.java:425)
    at com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl.getCallTransResult(CallTransTaskServiceImpl.java:101)
    at com.alibaba.dubbo.common.bytecode.Wrapper7.invokeMethod(Wrapper7.java)
    at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47)
    at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:79)
    at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:57)
    at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:63)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:79)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.limit.AbstractLimitAdapter.threadLimitCheck(AbstractLimitAdapter.java:106)
    at com.alibaba.dubbo.rpc.filter.ExecuteLimitFilter.invoke(ExecuteLimitFilter.java:44)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderAuthFilter.invoke(ProviderAuthFilter.java:22)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.AbstractGateWayFilter.invoke(AbstractGateWayFilter.java:30)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.AbstractTraceFilter.invoke(AbstractTraceFilter.java:94)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.monitor.support.FsofMonitorFilter.invoke(FsofMonitorFilter.java:78)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderGenericFilter.invoke(ProviderGenericFilter.java:141)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderContextFilter.invoke(ProviderContextFilter.java:161)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:40)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:96)
    at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:164)
    at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:270)
    at com.alibaba.dubbo.remoting.exchange.support.DecodeHandler.received(DecodeHandler.java:54)
    at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:153)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Unknown thread id: 1127272
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
    at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:729)
    at com.mysql.jdbc.StatementImpl$CancelTask$1.run(StatementImpl.java:118)
2022-01-16 15:43:29.267|25060|xxx||ERROR|com.fenqile.dao.datasource.mapper.MapperInterceptor|invoke|58|UID=,SESSIONID=,ENV=pre,SET=gz_ydjd_idc|execute sql failed, current dbkey is ServiceDB|xxx:server_oa_gateway->xxx:25250:com.fenqile.oa.telemarketing.service.CallTransTaskService:1.0.0#getCallTransResult
2022-01-16 15:43:29.272|25060|xxx||ERROR|com.fenqile.dao.datasource.mapper.MapperInterceptor|invoke|59|UID=,SESSIONID=,ENV=pre,SET=gz_ydjd_idc|execute sql failed,|xxx:server_oa_gateway->xxx:25250:com.fenqile.oa.telemarketing.service.CallTransTaskService:1.0.0#getCallTransResult
java.lang.reflect.InvocationTargetException: null
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.datasource.mapper.MapperInterceptor.invoke(MapperInterceptor.java:54)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.datasource.mapper.TraceInterceptor.invoke(TraceInterceptor.java:28)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl.getCallTransTask(CallTransTaskServiceImpl.java:425)
    at com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl.getCallTransResult(CallTransTaskServiceImpl.java:101)
    at com.alibaba.dubbo.common.bytecode.Wrapper7.invokeMethod(Wrapper7.java)
    at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47)
    at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:79)
    at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:57)
    at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:63)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:79)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.limit.AbstractLimitAdapter.threadLimitCheck(AbstractLimitAdapter.java:106)
    at com.alibaba.dubbo.rpc.filter.ExecuteLimitFilter.invoke(ExecuteLimitFilter.java:44)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderAuthFilter.invoke(ProviderAuthFilter.java:22)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.AbstractGateWayFilter.invoke(AbstractGateWayFilter.java:30)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.AbstractTraceFilter.invoke(AbstractTraceFilter.java:94)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.monitor.support.FsofMonitorFilter.invoke(FsofMonitorFilter.java:78)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderGenericFilter.invoke(ProviderGenericFilter.java:141)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderContextFilter.invoke(ProviderContextFilter.java:161)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:40)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:96)
    at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:164)
    at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:270)
    at com.alibaba.dubbo.remoting.exchange.support.DecodeHandler.received(DecodeHandler.java:54)
    at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:153)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException: null
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:125)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    ... 49 common frames omitted
2022-01-16 15:43:29.276|25060|xxx||ERROR|com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl|getCallTransResult|114|UID=,SESSIONID=,ENV=pre,SET=gz_ydjd_idc| getCallTransResult {} |xxx:server_oa_gateway->xxx:25250:com.fenqile.oa.telemarketing.service.CallTransTaskService:1.0.0#getCallTransResult
java.lang.NullPointerException: null
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:125)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.datasource.mapper.MapperInterceptor.invoke(MapperInterceptor.java:54)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.fenqile.dao.datasource.mapper.TraceInterceptor.invoke(TraceInterceptor.java:28)
    at com.sun.proxy.$Proxy50.queryUndoneTranTasks(Unknown Source)
    at com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl.getCallTransTask(CallTransTaskServiceImpl.java:425)
    at com.fenqile.oa.telemarketing.call.trans.CallTransTaskServiceImpl.getCallTransResult(CallTransTaskServiceImpl.java:101)
    at com.alibaba.dubbo.common.bytecode.Wrapper7.invokeMethod(Wrapper7.java)
    at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47)
    at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:79)
    at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:57)
    at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:63)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:79)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.limit.AbstractLimitAdapter.threadLimitCheck(AbstractLimitAdapter.java:106)
    at com.alibaba.dubbo.rpc.filter.ExecuteLimitFilter.invoke(ExecuteLimitFilter.java:44)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderAuthFilter.invoke(ProviderAuthFilter.java:22)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.AbstractGateWayFilter.invoke(AbstractGateWayFilter.java:30)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.AbstractTraceFilter.invoke(AbstractTraceFilter.java:94)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.monitor.support.FsofMonitorFilter.invoke(FsofMonitorFilter.java:78)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderGenericFilter.invoke(ProviderGenericFilter.java:141)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ProviderContextFilter.invoke(ProviderContextFilter.java:161)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:40)
    at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:101)
    at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:96)
    at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:164)
    at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:270)
    at com.alibaba.dubbo.remoting.exchange.support.DecodeHandler.received(DecodeHandler.java:54)
    at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:153)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
我的解答思路和尝试过的方法

已经尝试过很多办法，这个问题困扰了几天了
1、重新写了实体和mapper，即使只返回几行数据，一行数据只有两列还是报错
2、sql中用IFNULL做了处理
3、结果集在其他工具中排除了有值为null的情况
4、sql语句加上执行条件 主键> x and 主键 < y 偶尔能执行成功
5、改项目中其他查询执行正常，就这一行有问题

我想要达到的结果

希望大家帮我分析分析原因，想办法解决他

  • 写回答

2条回答 默认 最新

  • 钰娘娘 2022-01-16 16:37
    关注

    用：

    <![CDATA[ ]]>

    <mapper namespace="com.fenqile.oa.telemarketing.dao.QueryTransTaskMapper">
  <resultMap id="BaseResultMap" type="com.fenqile.oa.telemarketing.model.CallTransTask">
    <result column="Ftask_no" jdbcType="VARCHAR" property="ftaskNo" />
    <result column="Fcallback_json" jdbcType="VARCHAR" property="fcallbackJson" />
  </resultMap>
  <select id="queryUndoneTranTasks" resultType="com.fenqile.oa.telemarketing.model.CallTransTask">
    select IFNULL(Ftask_no, '') as Ftask_no,IFNULL(Fcallback_json, '') as Fcallback_json
    from t_call_trans_task
    where 1=1
      and Fis_finished = 1
      and Fis_callback = 1
      and Fis_write2db = 0
      and Fuse_flag = 1
     <![CDATA[  and Fcreate_time > date_add(now(), interval -6 day)]]>
  </select>
    评论

报告相同问题？

问题事件

  • 创建了问题 1月16日

悬赏问题

  • ¥15 我想用51单片机和数码管做一个从0开始的计数表 我写了一串代码 但是放到单片机里面数码管只闪烁一下然后熄灭
  • ¥20 系统工程中，状态空间模型中状态方程的应用。请猛男来完整讲一下下面所有问题
  • ¥15 我想在WPF的Model Code中获取ViewModel Code中的一个参数
  • ¥15 arcgis处理土地利用道路 建筑 林地分类
  • ¥20 使用visual studio 工具用C++语音，调用openslsx库读取excel文件的sheet问题
  • ¥100 寻会做云闪付tn转h5支付链接的技术
  • ¥15 DockerSwarm跨节点无法访问问题
  • ¥15 使用dify通过OpenAI 的API keys添加OpenAI模型时报了“Connection Error”错误
  • ¥40 想找个软件，但我不知道怎么找到它，我甚至不知道有没有
  • ¥15 怎么把60秒的视频时长改成显示0秒？且视频内容没有任何变化的正常播放？目的是为了解决一些平台对视频时长的要求，最好有自动处理的工具！