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


    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>

        <settings cacheModelsEnabled="false" enhancementEnabled="true" lazyLoadingEnabled="false" errorTracingEnabled="true" maxRequests="32"

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


    个人配置供参考:

        <!-- basic set -->
        <settings>
          <setting name="cacheEnabled" value="true"/>
          <setting name="lazyLoadingEnabled" value="true"/>
          <setting name="multipleResultSetsEnabled" value="true"/>
          <setting name="useColumnLabel" value="true"/>
          <setting name="useGeneratedKeys" value="false"/>
          <setting name="autoMappingBehavior" value="PARTIAL"/>
          <setting name="defaultExecutorType" value="SIMPLE"/>
          <setting name="defaultStatementTimeout" value="25"/>
          <setting name="safeRowBoundsEnabled" value="false"/>
          <setting name="mapUnderscoreToCamelCase" value="false"/>
          <setting name="localCacheScope" value="SESSION"/>
          <setting name="jdbcTypeForNull" value="OTHER"/>
          <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
          <setting name="logImpl" value="LOG4J"/>
          <setting name="callSettersOnNulls" value="true"/> 
        </settings>
    我驰骋天下,守你盛世繁华
  • 相关阅读:
    字符串String
    冒泡排序、二分查找法
    数组习题
    数组
    附加习题
    编写Java程序,应用for循环打印菱形、三角形
    JAVA的语法基础4
    3.20 每日一题题解
    3.19 每日一题题解
    3.18 每日一题题解
  • 原文地址:https://www.cnblogs.com/lotuses/p/9999808.html
Copyright © 2020-2023  润新知