MySQLNonTransientConnectionException: No operations allowed

最新推荐文章于 2025-09-18 15:44:54 发布

最新推荐文章于 2025-09-18 15:44:54 发布 · 460 阅读

文章标签：

#java #数据库

JAVA 专栏收录该内容

49 篇文章

订阅专栏

本文探讨了在使用c3p0连接池时遇到“No operations allowed after connection closed.”异常的原因及解决方案，通过调整unreturnedConnectionTimeout参数可以有效避免该问题。

最近在调试会发现“ No operations allowed after connection closed.”的异常，经研究是c3p0连接池参数设置问题，只需要提高参数unreturnedConnectionTimeout的值就行了

写道

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:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1232)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1225)

unreturnedConnectionTimeout 定义如下

写道

unreturnedConnectionTimeout defines a limit (in seconds) to how long a Connection may remain checked out. If set to a nozero value, unreturned, checked-out Connections that exceed this limit will be summarily destroyed, and then replaced in the pool. Obviously, you must take care to set this parameter to a value large enough that all intended operations on checked out Connections have time to complete. You can use this parameter to merely workaround unreliable client apps that fail to close() Connections.