在tomcat的catalin.out 中遇到以下错误
以上的judgetypet为其中一个方法的id值
00:40:00,020 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Elapsed period: Mon Dec 24 14:30:00 CST 2018 00:40:00,021 |-INFO in c.q.l.co.rolling.helper.RenameUtil - Renaming file [/opt/apache-tomcat-bg/logs/log.log] to [/opt/apache-tomcat-bg/logs/log2018-12-24.log] 00:40:00,021 |-INFO in c.q.l.core.rolling.helper.TimeBasedArchiveRemover - first clean up after appender initialization 00:40:00,022 |-INFO in c.q.l.core.rolling.helper.TimeBasedArchiveRemover - periodsElapsed = 64 com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/unisk/timertask/dao/TimerTaskDao.xml. --- The error occurred while applying a parameter map. --- Check the judgetypet-InlineParameterMap. --- Check the statement (query failed). --- Cause: com.mysql.jdbc.CommunicationsException: The last communications with the server was 7200 seconds ago, which is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
在ibatis的mapper.xml中的sql语句结尾的分号删掉以后就好了
其实还有另一种解决方案 参照 https://blog.csdn.net/chinesesword/article/details/51917496
让mysql驱动开启批量执行sql的开关。
怎么开启呢？在拼装mysql链接的url时，为其加上allowMultiQueries参数，设置为true，如下：
jdbc.jdbcUrl=jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true