c3p0错误NestedServletException

整合ssm框架时报错 java.lang.AbstractMethodError:Method com/mchange/v2/c3p0/impl/NewProxyResultSet.isClosed

导致 500 内部服务器错误, c3p0 连接池错误

运行环境:

IntelliJ IDEA 2021.2.3 (Ultimate Edition)
Build #IU-212.5457.46, built on October 12, 2021
Runtime version: 11.0.12+7-b1504.40 amd64

解决方法

控制台报错:

Snipaste_2021-11-10_15-07-56

Snipaste_2021-11-10_15-08-16

问题根源在maven依赖导入的jar包版本

问题有几种可能:

  1. 试试更改c3p0依赖版本

改之前的版本

image-20211110225704141

更改为一下版本:

1
2
3
4
5
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
  1. 如果还出问题, 可能是mybatis的版本冲突

image-20211110225925763

试试更改为 3.4.5 版本:

1
2
3
4
5
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
  1. 如果还有问题, 试试更改spring-jdbc 的版本为4.3.20.RELEASE
1
2
3
4
5
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.20.RELEASE</version>
</dependency>
Author: klenq
Link: https://klenq.github.io/2021/11/10/c3p0错误NestedServletException/
Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.