You can't perform a prepareStatement operation after the connection has been clo

最新推荐文章于 2023-04-28 11:01:45 发布

最新推荐文章于 2023-04-28 11:01:45 发布 · 972 阅读

文章标签：

#Java #quartz #SQL #SUN

spring 专栏收录该内容

1 篇文章

订阅专栏

本文深入探讨了在Java应用中使用反射机制调用方法时，因数据库连接已被关闭而导致的异常问题。重点分析了异常堆栈信息，并解释了配置问题导致重复加载调度配置文件和初始化调度计划的机制，最终引发数据库连接关闭的根本原因。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)
... 126 more
Caused by: java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed
at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
at $java.sql.Connection$$EnhancerByProxool$$d70c7c6b.prepareStatement(<generated>)
... 130 more

是因为配置问题,重复加载调度配置文件,在配置文件中配置有初始化调度的设置,所以每次加载配置文件的时候,导致都会重新去初始化调度计划,从而引起连接被关闭的问题.