Spring整合MyBatis时异常处理

阳光穿透心脏的1/2处 2022-10-25 01:23 331阅读 0赞

## 1. java.lang.NoClassDefFoundError: org/springframework/dao/support/DaoSupport ##

> 解决方式：添加spring-tx依赖，注意版本要一致，否则出现异常  
> **Caused by: java.lang.IllegalStateException: No persistence exception translators found in bean factory. Cannot perform exception translation**

<dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>4.3.14.RELEASE</version>
    </dependency>

## 2. org.springframework.beans.MethodInvocationException: Property ‘dataSource’ threw exception; nested exception is java.lang.NoClassDefFoundError: org/springframework/jdbc/datasource/TransactionAwareDataSourceProxy ##

> 解决方式：添加spring-jdbc依赖

<dependency>
    	<groupId>org.springframework</groupId>
    	<artifactId>spring-jdbc</artifactId>
    	<version>4.3.14.RELEASE</version>
    </dependency>

## 3. Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near ‘;serverTimezone=CTT’. ##

> 解决方式：检查数据库连接url的格式

// 正确格式
    jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=CTT

## 4. Method com/mchange/v2/c3p0/impl/NewProxyPreparedStatement.isClosed()Z is abstract ##

我的c3p0数据库连接池依赖为：  
![在这里插入图片描述][20210201093939973.png]  
**解决方式**：将依赖包改为

<dependency>
        <groupId>com.mchange</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.5.2</version>
    </dependency>

## 总结 ##

项目运行不起来，第一时间确实很慌，尤其是被大量看不懂的英文日志刷屏时，因此找准错误信息很重要，以我现在的经验来说，有两种方式：

1.  从报错开始位置找
2.  从报错结束位置找

然后**仔细阅读并大胆猜测**，推断报错原因

[20210201093939973.png]: /images/20221024/ad6c5c7020604e0cb30ffb8a862a941f.png