The last packet successfully received from the server was 10,060 milliseconds ago. The last packet_from the server was 10,006 milliseconds ago. the l

作者：寸_铁 | 2024-08-22 04:17:50

踩

from the server was 10,006 milliseconds ago. the last packet sent successful

分页查询时，分页到14000000条数据往后，就开始报错

因为查询超时

在连接mysql配置文件后面重新设置超时间即可

jdbc_url = jdbc:mysql://192.168.1.110:3306/eswa?characterEncoding=utf8&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&connectTimeout=1000&socketTimeout=30000

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/寸_铁/article/detail/1014663