Mybatis异常-关于建立连接connection异常的专题
1 获取连接超时
GetConnectionTimeoutException
wait millis 60000, active 0, maxActive 66, creating 1, createElapseMillis 955689
ExceptionHandler-Caused-by:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: \n### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 6000, active 4, maxActive 60, runningSqlCount 2
一般是服务端线程池配置小,或者应用侧有大SQL导致线程租塞。
2 连接丢失
Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure\n\nThe last packet successfully received from the server was 21 milliseconds ago. The last packet sent successfully to the server was 21 milliseconds ago
应用侧配置取连接前验证有效性。
3 密码错误
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@‘