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

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
guazixing 2012-03-15 14:30
关注
问题在这里：
Connection has already been closed.; nested exception is java.sql.SQLException: Connection has already been closed.

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

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

SQL state [null]; error code [0]; Connection has already been closed.; nested ex
2012-03-15 13:48

回答 2 已采纳问题在这里： Connection has already been closed.; nested exception is java.sql.SQLException: Connection h
连接本地数据库没有问题，但是连接服务器数据库报错No operations allowed after connection closed.怎么解决 java mysql 数据库
2022-03-05 11:00

回答 2 已采纳异常报的是请求超时1、检查链接参数是否无误。2、用数据库的客户端工具看下是否可以连上。3、看看网络环境是否有误。
ssm查询时报错Pool must not be null. java
2022-05-06 22:48

回答 3 已采纳应该是dbcp2的jar包跟pool2jar包的版本不兼容了，把你的dbcp2的jar包换个高点版本的就好了链接：https://pan.baidu.com/s/1RWZV8V0z_1NsXNwGRA
hive 报错return code 40000 from org.apache.hadoop.hive.ql.exec.MoveTask解决思路
2023-11-23 17:32

cclovezbf的博客我建议看源码，但先不要看报错源码，直接看errorCode源码，别人hive的开发者也是人，也知道这里会报错，可能会好心告诉我们怎么解决。看到这里获取配置项，就舒服了，毕竟就算我们发现假设hive源码有问题，我也没法...
Unable to start web server; nested exception is .. intellij-idea java
2022-10-04 01:16

回答 2 已采纳 maven clean install(package)项目重新进行构建 build->rebuild project 可参考 https://blog.csdn.net/m0_5076243
关于#java#的问题：nested exception is java.lang.IllegalStateException java spring boot
2021-11-19 14:30

回答 1 已采纳这就需要自己debug了，ConfigurationPropertiesBindingPostProcessor这个类实现的绑定过程
SQL Error: 17008, SQLState: null hibernate
2008-08-17 10:02

回答 3 已采纳楼主如果确定是这块代码的问题, 能不能把HibernateSessionFactory的代码贴出来, 可能有两个原因: 1, 因为dao中你已经把session关闭, 如果Userinfo中使用了l
springboot入门
2018-03-08 00:42

@清风明月情@的博客 = 0; i ; i ++) { User user = new User(); user .setUsername( "username_" + i ); user .setPassword( "password_" + i ); user .setAge( i + 1); result .add( user ); } return...
SQLZOO-Nested SELECT Quiz 求解惑第四题 sql
2022-10-17 21:59

回答 1 已采纳破案了，是第四第五的最后得是gdp>0才行，不能不写，也不能写gdp<>null
java.sql.Time 类型使用问题 ajax java sql
2021-08-30 20:54

回答 1 已采纳数据库你可以用data类型
java.lang.NullPointerException: null idea spring boot
2022-04-03 14:50

回答 1 已采纳我决绝了自己的报错了，这次出现报错的原因是因为我的控制类中没用通过服务类Service而是直接调用dao代理直接进行入库操作导致了空指针的问题，还有一个小问题就是onSale中的字符编码为中文出现了一
Java经验速记
2023-01-30 19:15

Flora.~的博客 # 进入用户主目录 cd ~ # 生成一个.ssh的文件 ssh-keygen -t rsa -C “github邮箱” #一路回车 # 输出 # Your public key has been saved in 绝对路径 cat 绝对路径 # 输出 ssh-rsa .....="邮箱" 复制 ssh-rsa ........
Java错误： nested exception is java.lang.IncompatibleClassChangeError: Implementing class java xml 有问必答
2021-11-23 15:34

回答 3 已采纳可能是导入的jar包重复.尤其在Maven引用中，请查看是否重复引入了相关的依赖或者jar，比如子模块引用了相关的jar，父模块中也引入了次jar
【工具型框架】Mybatis——session管理原理/cache管理原理/datasource管理原理/Tran事务管理原理
2020-09-09 15:00

骆子无悔的博客 // may have fetched a connection so lets call close() throw ExceptionFactory.wrapException("Error opening session. Cause: " + e, e); } finally { ErrorContext.instance().reset(); } } sesson的代理利用...
Oracle Database Server Messages(二) .
2014-02-24 17:52

kuifeng.dong的博客 Skip Headers Oracle9i Database Error Messages Release 2 (9.2) Part Number A96525-01 Home Book List Contents Index Master Index Feedback
DB2的SQLSTATE值
2014-06-27 10:57

kevin11yk的博客 The null value has been assigned to a host variable, because a substring error occurred; for example, an argument of SUBSTR is out of range. +138 01545 An unqualified column name ...
一口气讲完设计模式（单例模式、工厂模式、原型模式、建造者模式、适配器、桥梁模式）
2021-06-26 18:41

编码行者的博客观察者模式（Observer Pattern）状态模式（State Pattern）空对象模式（Null Object Pattern）策略模式（Strategy Pattern）模板模式（Template Pattern）访问者模式（Visitor Pattern） 4 J2EE 模式这些设计...
SQLDirect组件库用户指南
2008-04-22 12:08

henreash的博客 SQLDirect组件库For Delphi 4, 5, 6, 7, 8, 9 (2005), 10 (2006), 2007 和C++ Builder 4, 5, 6, 2006, 2007ver. 5.2用户指南IntroductionThank You for using SQLDirect Component Library. I hope that
没有解决我的问题, 去提问

悬赏问题

¥20 sub地址DHCP问题
¥15 delta降尺度计算的一些细节，有偿
¥15 Arduino红外遥控代码有问题
¥15 数值计算离散正交多项式
¥30 数值计算均差系数编程
¥15 redis-full-check比较两个集群的数据出错
¥15 Matlab编程问题
¥15 训练的多模态特征融合模型准确度很低怎么办
¥15 kylin启动报错log4j类冲突
¥15 超声波模块测距控制点灯，灯的闪烁很不稳定，经过调试发现测的距离偏大

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

2条回答 默认 最新

悬赏问题

2条回答默认最新