Quartz集群数据库连接失效

最新推荐文章于 2023-08-05 21:43:12 发布

hoaven

最新推荐文章于 2023-08-05 21:43:12 发布

阅读量2.7k

点赞数 1

分类专栏： J2EE 文章标签： quartz c3p0 数据库连接失效

本文链接：https://blog.csdn.net/hehuanchun0311/article/details/80591929

版权

本文介绍了Quartz集群中遇到的c3p0数据库连接失效问题，分析了MySQL服务器8小时自动断开空闲连接的机制，以及C3P0连接池在提供失效连接时引发的异常。解决方案是通过设置C3P0的最大空闲时间为60秒，避免使用已过期的数据库连接。

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

一、问题描述

[2018-6-5 13:57:11] [WARN ] [com.mchange.v2.c3p0.impl.NewPooledConnection:425] - [c3p0] A PooledConnection that has already signalled a Connection error is still in use!

[2018-6-5 13:57:11] [WARN ] [com.mchange.v2.c3p0.impl.NewPooledConnection:426] - [c3p0] Another error has occurred [ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. ] which will not be reported to listeners!
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Con