oracle数据库网络波动,websphere+oracle连接池不稳定，求助分析

雨木语

于 2021-04-05 05:52:32 发布

阅读量868

点赞数

文章标签： oracle数据库网络波动

[13-5-10 15:41:48:657 CST] 00000406 Configuration W com.thunisoft.summer.security.access.Configuration existControl Not found access control configuration for action :/jcy/cases/pub/editpage,ajxq

[13-5-10 15:41:48:657 CST] 00000406 BaseAuditAdvi I com.thunisoft.jcy.cases.audit.BaseAuditAdvice generateActionId Audit Action Key: EditpageLogic.ajxq

[13-5-10 15:41:48:657 CST] 00000406 BaseAuditAdvi I com.thunisoft.jcy.cases.audit.BaseAuditAdvice saveAuditInfo Audit Action Info Id: 8a8b4c8e3e4bb062013e8d6380f160c3

[13-5-10 15:41:48:657 CST] 00000406 AjAuditAdvice I com.thunisoft.jcy.cases.audit.aj.AjAuditAdvice doAudit Audit AJWH: 10160002117281

[13-5-10 15:41:49:032 CST] 00000401 LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:49:032 CST] 00000401 LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:49:095 CST] 000003bc LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:49:095 CST] 000003bc LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:49:204 CST] 00000441 Configuration W com.thunisoft.summer.security.access.Configuration existControl Not found access control configuration for action :/jcy/cases/pub/ajxq/dealAjxq,showajxq

[13-5-10 15:41:49:641 CST] 0000043a LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:49:641 CST] 0000043a LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:51:391 CST] 00000441 Configuration W com.thunisoft.summer.security.access.Configuration existControl Not found access control configuration for action :/jcy/cases/pub/editpage,ajxq

[13-5-10 15:41:51:407 CST] 00000441 BaseAuditAdvi I com.thunisoft.jcy.cases.audit.BaseAuditAdvice generateActionId Audit Action Key: EditpageLogic.ajxq

[13-5-10 15:41:51:407 CST] 00000441 BaseAuditAdvi I com.thunisoft.jcy.cases.audit.BaseAuditAdvice saveAuditInfo Audit Action Info Id: 8a8b4c8e3e4bb062013e8d638baf60c4

[13-5-10 15:41:51:407 CST] 00000441 AjAuditAdvice I com.thunisoft.jcy.cases.audit.aj.AjAuditAdvice doAudit Audit AJWH: 10160002166449

[13-5-10 15:41:51:845 CST] 00000401 LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:51:845 CST] 00000401 LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:51:938 CST] 000003f2 Configuration W com.thunisoft.summer.security.access.Configuration existControl Not found access control configuration for action :/jcy/cases/pub/ajxq/dealAjxq,showajxq

[13-5-10 15:41:52:188 CST] 0000043a JCYUserAASAct I com.thunisoft.jcy.web.action.JCYUserAASAction execute received user login request!

[13-5-10 15:41:52:235 CST] 0000043a SysLoaderServ I com.thunisoft.summer.security.auth.AuthProvider loadUserRight ---- load user rights start!

[13-5-10 15:41:52:313 CST] 0000043a SysLoaderServ I com.thunisoft.summer.security.auth.AuthProvider loadUserRight ---- load user rights end!

[13-5-10 15:41:52:313 CST] 0000043a JCYUserAASAct I com.thunisoft.jcy.web.action.JCYUserAASAction execute ---- user "dcchentao" login ok!

[13-5-10 15:41:52:313 CST] 0000043a BaseAuditAdvi I com.thunisoft.jcy.cases.audit.BaseAuditAdvice generateActionId Audit Action Key: JCYUserAASAction.execute

[13-5-10 15:41:52:313 CST] 0000043a BaseAuditAdvi I com.thunisoft.jcy.cases.audit.BaseAuditAdvice saveAuditInfo Audit Action Info Id: 8a8b4c8e3e4bb062013e8d638f3960c5

[13-5-10 15:41:52:329 CST] 0000043a LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:52:329 CST] 0000043a LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:52:345 CST] 00000406 AjaxServlet E com.thunisoft.summer.web.action.AjaxServlet doPost error:

org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [call PK_CQAJ.PR_GETCQHXAJLIST(?, ?, ?)]; SQL state [null]; error code [0]; DSRA9110E: 关闭 Connection。; nested exception is com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: 关闭 Connection。

Caused by: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: 关闭 Connection。

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

at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareCall(WSJdbcConnection.java:2001)

at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareCall(WSJdbcConnection.java:1893)

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

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

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

at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:166)

at $Proxy0.prepareCall(Unknown Source)

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

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

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

at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)

at $Proxy4.prepareCall(Unknown Source)

at org.springframework.jdbc.core.JdbcTemplate$SimpleCallableStatementCreator.createCallableStatement(JdbcTemplate.java:1175)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:836)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:871)

at com.thunisoft.jcy.cases.pub.cqaj.business.CqajLogic.getCqhxMap(CqajLogic.java:155)

at com.thunisoft.jcy.cases.pub.cqaj.business.CqajLogic.getCqhxajList(CqajLogic.java:94)

at com.thunisoft.jcy.cases.pub.editpage.business.OperationConfigManager.buildCqhxWsInfo(OperationConfigManager.java:740)

at com.thunisoft.jcy.cases.pub.editpage.business.EditpageLogic.getCqhxWs(EditpageLogic.java:436)

at com.thunisoft.jcy.cases.pub.editpage.business.EditpageLogic$$FastClassByCGLIB$$43bc6c0d.invoke()

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

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

at com.thunisoft.jcy.cases.pub.editpage.business.EditpageLogic$$EnhancerByCGLIB$$8bce9aca.getCqhxWs()

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

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

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

at com.thunisoft.summer.web.action.AjaxServlet.doPost(AjaxServlet.java:105)

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

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

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

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

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

at com.thunisoft.summer.web.filter.UserAASFilter.doFilter(UserAASFilter.java:117)

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

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

at com.thunisoft.jcy.web.filter.LoginCheckFilter.doFilter(LoginCheckFilter.java:62)

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

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

at com.thunisoft.summer.web.filter.CharsetFilter.doFilter(CharsetFilter.java:48)

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:832)

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

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

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

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

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

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

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

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.WorkQueueManager.requestComplete(WorkQueueManager.java:556)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:606)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:979)

at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1064)

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

[13-5-10 15:41:52:829 CST] 00000401 LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:52:829 CST] 00000401 LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:53:673 CST] 00000440 Configuration W com.thunisoft.summer.security.access.Configuration existControl Not found access control configuration for action :/jcy/cases/main/dealMain,getRight

[13-5-10 15:41:53:704 CST] 00000401 LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:53:704 CST] 00000401 LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:53:735 CST] 000003bc LocalTranCoor W WLTC0033W: 清除 LocalTransactionContainment 时，资源 ds/jcy 回滚。

[13-5-10 15:41:53:735 CST] 000003bc LocalTranCoor W WLTC0032W: 清除 LocalTransactionContainment 期间回滚了一个或多个本地事务资源。

[13-5-10 15:41:53:876 CST] 00000406 AjaxServlet E com.thunisoft.summer.web.action.AjaxServlet doPost error:

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select N_BMID from T_YWJC_QX_SJQX where N_RYID = ? and C_QXID = ?]; SQL state [null]; error code [0]; DSRA9110E: 关闭 Connection。; nested exception is com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: 关闭 Connection。

Caused by: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: 关闭 Connection。

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

at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2130)

at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2017)

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

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

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

at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:166)

at $Proxy0.prepareStatement(Unknown Source)

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

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

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

at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)

at $Proxy4.prepareStatement(Unknown Source)

at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1153)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:493)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:582)

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:598)

at com.thunisoft.jcy.support.QxpubLogic.getBmidListByQx(QxpubLogic.java:244)

at com.thunisoft.jcy.support.QxpubLogic.getBmidStrByQx(QxpubLogic.java:273)

at com.thunisoft.jcy.cases.pub.main.business.MainConfigLogic.getQxSql(MainConfigLogic.java:784)

at com.thunisoft.jcy.cases.pub.main.business.MainConfigLogic.IteratorMsCount(MainConfigLogic.java:1763)

at com.thunisoft.jcy.cases.pub.main.business.MainConfigLogic.getMsCount(MainConfigLogic.java:1670)

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