silen 2012-03-15 13:48
浏览 3558
已采纳

SQL state [null]; error code [0]; Connection has already been closed.; nested ex

程序应该是没问题的,本地服务器及测试服务起 都没有这个错误,但上生产后就抛这么个异常。。。大虾们帮看看吧

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.COMCODE as COMCODE24_0_, this_.EDITIONNO as EDITIONNO24_0_, this_.RISKCODE as RISKCODE24_0_, this_.ABATETIME as ABATETIME24_0_, this_.EFFECTIVETIME as EFFECTIV5_24_0_, this_.INSERTTIMEFORHIS as INSERTTI6_24_0_, this_.ISOPERVIEWDATA as ISOPERVI7_24_0_, this_.OPERATETIMEFORHIS as OPERATET8_24_0_, this_.REMARK as REMARK24_0_ from PRPFEDITION this_ where (this_.COMCODE=? and this_.EDITIONNO=? and this_.RISKCODE=?)]; SQL state [null]; error code [0]; Connection has already been closed.; nested exception is java.sql.SQLException: Connection has already been closed.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at ins.framework.dao.EntityDaoHibernate.find(EntityDaoHibernate.java:752)
at ins.framework.dao.EntityDaoHibernate.findUnique(EntityDaoHibernate.java:938)
at ins.framework.dao.GenericDaoHibernate.findUnique(GenericDaoHibernate.java:125)
at com.sinosoft.fixation.common.service.spring.CommonSimulaterServiceSpringImpl.getEffectivetime(CommonSimulaterServiceSpringImpl.java:105)
at com.sinosoft.fixation.common.service.spring.CommonSimulaterServiceSpringImpl$$FastClassByCGLIB$$170b1bf2.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at ins.framework.log.RunTimeLogAdvice.invoke(RunTimeLogAdvice.java:29)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.sinosoft.fixation.common.service.spring.CommonSimulaterServiceSpringImpl$$EnhancerByCGLIB$$8ebc708c.getEffectivetime()
at com.sinosoft.quotation.business.service.spring.PremiumCalculateServiceSpringImpl.compFixationReqInfo(PremiumCalculateServiceSpringImpl.java:2265)
at com.sinosoft.quotation.business.service.spring.PremiumCalculateServiceSpringImpl.getFixAllPreferential(PremiumCalculateServiceSpringImpl.java:2146)
at com.sinosoft.quotation.business.service.spring.PremiumCalculateServiceSpringImpl$$FastClassByCGLIB$$f1fcec57.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at ins.framework.log.RunTimeLogAdvice.invoke(RunTimeLogAdvice.java:29)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.sinosoft.quotation.business.service.spring.PremiumCalculateServiceSpringImpl$$EnhancerByCGLIB$$38663e4f.getFixAllPreferential()
at com.sinosoft.quotation.simulater.service.spring.SimulaterServiceSpringImpl.StartSimulater(SimulaterServiceSpringImpl.java:618)
at com.sinosoft.quotation.simulater.service.spring.SimulaterServiceSpringImpl$$FastClassByCGLIB$$92f9b17a.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at ins.framework.log.RunTimeLogAdvice.invoke(RunTimeLogAdvice.java:29)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.sinosoft.quotation.simulater.service.spring.SimulaterServiceSpringImpl$$EnhancerByCGLIB$$d11c8b90.StartSimulater()
at com.sinosoft.quotation.simulater.service.spring.TimeTaskDispatch.executeInternal(TimeTaskDispatch.java:66)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.sql.SQLException: Connection has already been closed.
at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:56)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:87)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:495)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at ins.framework.dao.EntityDaoHibernate$8.doInHibernate(EntityDaoHibernate.java:761)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 50 more

  • 写回答

2条回答 默认 最新

  • guazixing 2012-03-15 14:30
    关注

    问题在这里:
    Connection has already been closed.; nested exception is java.sql.SQLException: Connection has already been closed.

    连接被关闭,至于关闭的原因,是不是你手动关闭了连接?还是事物提前结束了?查查吧。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?
  • ¥15 乘性高斯噪声在深度学习网络中的应用
  • ¥15 运筹学排序问题中的在线排序
  • ¥15 关于docker部署flink集成hadoop的yarn,请教个问题 flink启动yarn-session.sh连不上hadoop,这个整了好几天一直不行,求帮忙看一下怎么解决
  • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛