dsra9110e oracle statement,WAS提示：DSRA9110E: Connection is closed和Statement is closed问题

最新推荐文章于 2023-12-07 23:10:41 发布

HelloTVM

最新推荐文章于 2023-12-07 23:10:41 发布

阅读量2.1k

点赞数

文章标签： dsra9110e oracle statement

软件名称：websphereV6.1 网络部署版软件版本：Name IBM WebSphere Application Server - NDVersion ...显示全部

软件名称：websphereV6.1 网络部署版

软件版本：

Name IBM WebSphere Application Server - ND

Version 6.1.0.25

ID ND

Build Level cf250922.06

Build Date 6/1/09

环境平台：

1)操作系统：AIX 5.3 64位

2)java版本：java version "1.5.0"

Java(TM) 2 Runtime Environment, Standard Edition (build pap64dev-20060511 (SR2))

IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 AIX ppc64-64 j9vmap6423-20060504 (JI

T enabled)

J9VM - 20060501_06428_BHdSMr

JIT - 20060428_1800_r8

GC - 20060501_AA)

JCL - 20060511a

3)6台机器配置：CPU16核 3.5Ghz 32GB内存

问题描述：

WAS提示：DSRA9110E: Connection is closed和DSRA9110E: Statement is closed。问题比较急，请各位专家指点。

webcontainer：线程非活动超时3500毫秒，

数据库连接池：连接超时180秒，非使用的超时1800秒，时效超时0秒。

WAS架构是：两台IHS做HA集群，4台应用服务器。DM安装在其中一台应用服务器上，服务总共是14个。

1服务器：DM+1Node+4个服务

2服务器：1Node+4个服务

3服务器：1Node+3个服务

4服务器：1Node+3个服务

具体信息：

2010-08-09 08:39:02 ERROR Transaction - Do release the connection from data source exception

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.

at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2657)

at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2741)

at com.ecc.emp.jdbc.ConnectionHolder.releaseConnection(ConnectionHolder.java:64)

at com.ecc.emp.transaction.TransactionSynchronizer.removeTransaction(TransactionSynchronizer.java:155)

at com.ecc.emp.transaction.EMPTransactionManager.commit(EMPTransactionManager.java:131)

at com.ecc.emp.transaction.EMPTransactionManager.commit(EMPTransactionManager.java:144)

at com.yucheng.cmis.ad.mvc.ADRequestController.executeEMPLogic(Unknown Source)

at com.ecc.emp.web.servlet.mvc.EMPRequestController.executeTheFlow(EMPRequestController.java:487)

at com.ecc.emp.web.servlet.mvc.EMPRequestController.doRequest(EMPRequestController.java:307)

at com.ecc.emp.web.servlet.EMPRequestServlet.service(EMPRequestServlet.java:427)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1146)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)

at com.yucheng.cmis.wfi.ContextFilter.doFilter(ContextFilter.java:29)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

at com.ecc.emp.web.jsptags.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:44)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)

at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)

at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3507)

at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:269)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)

at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:122)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

2010-08-26 17:39:24 ERROR EMPJDBC - Failed to SELECT records in tableModel [PrdRateStd] due to SQLException !

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1664)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:911)

at com.ecc.emp.dbmodel.service.TableModelDAO.queryByCondition(TableModelDAO.java:730)

at com.ecc.emp.dbmodel.service.TableModelDAO.queryList(TableModelDAO.java:1483)

at com.ecc.emp.dbmodel.service.TableModelDAO.queryList(TableModelDAO.java:1473)

at com.yucheng.cmis.prd.prdbasicinfo.agent.PrdBasicinfoAgent.getBasicRateByTerm(PrdBasicinfoAgent.java:1544)

at com.yucheng.cmis.prd.prdbasicinfo.component.PrdBasicinfoComponet.getBasicRateByTerm(PrdBasicinfoComponet.java:674)

at com.yucheng.cmis.prdinterface.Prd4IqpInstance.getBasicRateByTerm(Prd4IqpInstance.java:343)

at com.yucheng.cmis.ctr.cont.imp.CtrContImpl.interfaceOfProcessWithLoanAppUnual(CtrContImpl.java:229)

at sun.reflect.GeneratedMethodAccessor206.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:615)

at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)

at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:230)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:912)

at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:756)

at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHelper.java:738)

at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:726)

at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:170)

at Script120.run(Script120.groovy:8)

at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java:243)

at com.sun.script.groovy.GroovyScriptEngine.eval(GroovyScriptEngine.java:81)

at javax.script.AbstractScriptEngine.eval(AbstractScriptEngine.java:247)

at com.yucheng.cmis.wfi.event.handler.DymanicEmpHandler$1.process(DymanicEmpHandler.java:215)

at com.yucheng.cmis.wfi.CMISComponentFactoryBean$EMPRunner.run(CMISComponentFactoryBean.java:139)

at com.yucheng.cmis.wfi.event.handler.DymanicEmpHandler.afterEvent(DymanicEmpHandler.java:165)

at com.yuchengtech.cmis.bpm.provider.eventhandler.BizLogicEventHandler$1.handle(BizLogicEventHandler.java:124)

at com.yuchengtech.cmis.bpm.provider.eventhandler.BizLogicEventHandler$HandlerRunner.execute(BizLogicEventHandler.java:68)

at com.yuchengtech.cmis.bpm.provider.eventhandler.BizLogicEventHandler.afterEvent(BizLogicEventHandler.java:121)

at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher.dispathEvent(WFIEventDispatcher.java:366)

at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher.dispathCompleteProc(WFIEventDispatcher.java:55)

at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher$$FastClassByCGLIB$$59da0af5.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 org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)

at com.yuchengtech.cmis.bpm.core.WFIEventDispatcher$$EnhancerByCGLIB$$32792fc1.dispathCompleteProc()

at sun.reflect.GeneratedMethodAccessor187.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:615)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)

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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy2.completeProc(Unknown Source)

at com.yuchengtech.cmis.bpm.core.WFIActionImpl.submit(WFIActionImpl.java:256)

at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:615)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy3.submit(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:615)

at com.yuchengtech.cmis.bpm.core.WFIProxyImpl.involkAction(WFIProxyImpl.java:62)

at com.yuchengtech.cmis.bpm.core.WFIControllerImpl.process(WFIControllerImpl.java:95)

at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:615)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy6.process(Unknown Source)

at com.yucheng.cmis.wfi.WFIServlet.service(WFIServlet.java:245)