关于java.sql.SQLException: Query execution was interrupted异常的原因

来源：互联网发布：阿里云总部在哪里编辑：程序博客网时间：2024/06/04 19:34

数据库交互部分报异常信息：

Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [70100]; error code [1317];
--- The error occurred in cn/xxt/report/dao/impl/UnitStuNew.xml.
--- The error occurred while applying a parameter map.
--- Check the unit_stu_new.insertAuto-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: Query execution was interrupted; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in cn/xxt/report/dao/impl/UnitStuNew.xml.
--- The error occurred while applying a parameter map.
--- Check the unit_stu_new.insertAuto-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: Query execution was interrupted

原因一般在于tomcat连接池配置限定了超时时间：maxWait="10000"

解决办法：

1、优化数据库交互语句，提高数据库访问效率

2、修改超时限定时间