admin管理员组文章数量:1618705
现象: mybatis Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
解决:
方法一:登陆mysql:
show global variables like 'wait_timeout';
show global variables like 'interactive_timeout';
set global wait_timeout=864000;
set global interactive_timeout=864000;
方法二:mybatis settings设置:
<settings> <setting name="cacheEnabled" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="multipleResultSetsEnabled" value="true"/> <setting name="useColumnLabel" value="true"/> <setting name="useGeneratedKeys" value="false"/> <setting name="autoMappingBehavior" value="PARTIAL"/> <setting name="autoMappingUnknownColumnBehavior" value="WARNING"/> <setting name="defaultExecutorType" value="SIMPLE"/> <setting name="defaultStatementTimeout" value="864000"/> <setting name="defaultFetchSize" value="50"/> <setting name="safeRowBoundsEnabled" value="false"/> <setting name="mapUnderscoreToCamelCase" value="false"/> <setting name="localCacheScope" value="SESSION"/> <setting name="jdbcTypeForNull" value="OTHER"/> <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/> </settings>
本文标签: MyBatismysqlCommunicationsfailureLINK
版权声明:本文标题:mysql mybatis连接超时 Communications link failure 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/xitong/1728785361a1173256.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论