Mybatis异常-关于建立连接connection异常的专题

最新推荐文章于 2024-04-17 10:02:21 发布

loongshawn

最新推荐文章于 2024-04-17 10:02:21 发布

阅读量2.2k

点赞数

分类专栏：笔记

本文链接：https://blog.csdn.net/loongshawn/article/details/120884518

版权

本文详细分析了Mybatis在建立数据库连接时可能遇到的多种异常，包括获取连接超时、连接丢失、密码错误、驱动未加载、用户名密码错误、连接泄露、配置错误、连接重置、配置错误、连接拒绝和操作不允许等，提供了针对性的解决建议和排查步骤。

摘要由CSDN通过智能技术生成

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 '@‘