Exception occured|
org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException; SQL state [null]; error code [0]; statement is closed; nested exception is java.sql.SQLException: statement is closed
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1414)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1077)
at com.mycim.server.prp.dao.impl.WorkFlowExcuteDAOImpl.createExecutionRrnFastByVersion(WorkFlowExcuteDAOImpl.java:33)
at com.mycim.server.prp.dao.impl.WorkFlowExcuteDAOImpl$$FastClassBySpringCGLIB$$510583f6.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.mycim.server.prp.dao.impl.WorkFlowExcuteDAOImpl$$EnhancerBySpringCGLIB$$64c058e8.createExecutionRrnFastByVersion(<generated>)
at com.mycim.server.prp.manager.impl.WorkFlowExcuteManagerImpl.createExecutionRrnFastByVersion(WorkFlowExcuteManagerImpl.java:53)
at com.mycim.server.prp.manager.impl.WorkFlowExcuteManagerImpl$$FastClassBySpringCGLIB$$21e26f96.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.mycim.server.prp.manager.impl.WorkFlowExcuteManagerImpl$$EnhancerBySpringCGLIB$$c743a88d.createExecutionRrnFastByVersion(<generated>)
at com.mycim.server.wip.manager.impl.WipWorkflowQueryManagerImpl.createExecutionRrnFastByVersion(WipWorkflowQueryManagerImpl.java:741)
at com.mycim.server.wip.manager.impl.WipWorkflowQueryManagerImpl.getStepsInfoByVersion(WipWorkflowQueryManagerImpl.java:79)
at com.mycim.server.wip.manager.impl.WipWorkflowQueryManagerImpl$$FastClassBySpringCGLIB$$dc883070.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.mycim.server.wip.manager.impl.WipWorkflowQueryManagerImpl$$EnhancerBySpringCGLIB$$9f3f435b.getStepsInfoByVersion(<generated>)
at com.mycim.server.wip.service.WipWorkflowQueryServiceImpl.getStepsInfoByVersion(WipWorkflowQueryServiceImpl.java:37)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.alipay.sofa.rpc.filter.ProviderInvoker.invoke(ProviderInvoker.java:77)
at com.mycim.framework.cloud.filter.provider.LoggingFilter.invoke(LoggingFilter.java:24)
at com.alipay.sofa.rpc.filter.FilterInvoker.invoke(FilterInvoker.java:96)
at com.alipay.sofa.rpc.filter.sofatracer.ProviderTracerFilter.invoke(ProviderTracerFilter.java:74)
at com.alipay.sofa.rpc.filter.FilterInvoker.invoke(FilterInvoker.java:96)
at com.alipay.sofa.rpc.filter.ProviderBaggageFilter.invoke(ProviderBaggageFilter.java:45)
at com.alipay.sofa.rpc.filter.FilterInvoker.invoke(FilterInvoker.java:96)
at com.alipay.sofa.rpc.filter.RpcServiceContextFilter.invoke(RpcServiceContextFilter.java:62)
at com.alipay.sofa.rpc.filter.FilterInvoker.invoke(FilterInvoker.java:96)
at com.alipay.sofa.rpc.filter.ProviderExceptionFilter.invoke(ProviderExceptionFilter.java:37)
at com.alipay.sofa.rpc.filter.FilterInvoker.invoke(FilterInvoker.java:96)
at com.alipay.sofa.rpc.filter.FilterChain.invoke(FilterChain.java:262)
at com.alipay.sofa.rpc.server.ProviderProxyInvoker.invoke(ProviderProxyInvoker.java:65)
at com.alipay.sofa.rpc.server.bolt.BoltServerProcessor.doInvoke(BoltServerProcessor.java:226)
at com.alipay.sofa.rpc.server.bolt.BoltServerProcessor.handleRequest(BoltServerProcessor.java:171)
at com.alipay.sofa.rpc.server.bolt.BoltServerProcessor.handleRequest(BoltServerProcessor.java:61)
at com.alipay.remoting.rpc.protocol.RpcRequestProcessor.dispatchToUserProcessor(RpcRequestProcessor.java:218)
at com.alipay.remoting.rpc.protocol.RpcRequestProcessor.doProcess(RpcRequestProcessor.java:145)
at com.alipay.remoting.rpc.protocol.RpcRequestProcessor$ProcessTask.run(RpcRequestProcessor.java:371)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: statement is closed
at com.alibaba.druid.pool.DruidPooledStatement.checkOpen(DruidPooledStatement.java:182)
at com.alibaba.druid.pool.DruidPooledStatement.getWarnings(DruidPooledStatement.java:594)
at org.springframework.jdbc.core.JdbcTemplate.handleWarnings(JdbcTemplate.java:1379)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1063)
... 57 common frames omitted
操作数据时，调用的Statement对象关闭了，检查一下代码，逻辑有点问题。
代码里面有一个错误的sql语句并且在你执行这个之前被执行过 重启或许会可以但是没解决根本