mysql 数据库连接超过 8 小时失效的解决方案

使用mysql数据库遇到的问题，后台打印错误信息如下：

org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [ SELECT  lessonNo,lessonStart,lessonEnd,answerCount,studentNumber,allCount,correctRate,averageTime  FROM  studycase_answer_class  WHERE  schoolId =? and classCode=?  and teaEmail=? ]; Communications link failure

The last packet successfully received from the server was 101,594 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 101,594 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98)
	at org.springframework.jdbc.support.AbstractFallbackS