MySQL连接时出现2105错误_MySQL异常：Caused by: com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cance...

Caused by: com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2303)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)

at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)

at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)

解决方法

设置defaultStatementTimeout="60"

在sqlmap.xml中设置，表示60s

sqlMapConfig>

maxSessions="10" maxTransactions="5" useStatementNamespaces="true" defaultStatementTimeout="60" />