数据库交互部分报异常信息:
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、修改超时限定时间