ESB SAM支持oracle 11G RAC启动时报Timeout waiting for idle object错误

【问题描述】

在启动SAM模块是报如下的错误。其他模块目前没发现问题，

Root caused by: java.util.NoSuchElementException: Timeout waiting for idle object
        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:756)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at com.primeton.ext.infra.connection.DataSourceWrapper.getAvailableConnectionIfNecessary(DataSourceWrapper.java:141)
        at com.primeton.ext.infra.connection.DataSourceWrapper.getConnection(DataSourceWrapper.java:63)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
        at com.eos.infra.connection.ConnectionFactory.createConnection(ConnectionFactory.java:45)
        at com.eos.common.connection.SimpleConnectionHelper.doInGetConnection(SimpleConnectionHelper.java:49)
        at com.eos.common.connection.ConnectionHelper.getCurrentContributionConnection(ConnectionHelper.java:162)
        at com.eos.foundation.database.DatabaseUtil.getConnection(DatabaseUtil.java:1064)
        at com.eos.foundation.database.DatabaseUtil.queryEntitiesByTemplate(DatabaseUtil.java:868)
        at org.gocom.abframe.auth.LoginManager.authentication_biz.invokePojo0(authentication_biz.java:239)
        at org.gocom.abframe.auth.LoginManager.authentication_biz.__choiceinvokePojo0(authentication_biz.java:710)
        at org.gocom.abframe.auth.LoginManager.authentication_biz.__invokeBiz(authentication_biz.java:621)
        at org.gocom.abframe.auth.LoginManager.authentication_biz._invoke(authentication_biz.java:525)
        at org.gocom.abframe.auth.LoginManager.authentication_biz.invoke(authentication_biz.java:567)
        at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
        at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
        at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
        at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
        at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
        at org.gocom.abframe.auth.LoginManager.login_biz.subprocess0(login_biz.java:217)
        at org.gocom.abframe.auth.LoginManager.login_biz.__choicesubprocess0(login_biz.java:604)
        at org.gocom.abframe.auth.LoginManager.login_biz.__invokeBiz(login_biz.java:546)
        at org.gocom.abframe.auth.LoginManager.login_biz._invoke(login_biz.java:449)
        at org.gocom.abframe.auth.LoginManager.login_biz.invoke(login_biz.java:496)
        at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
        at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
        at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
        at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
        at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
        at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
        at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
        at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
        at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
        at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
        at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
        at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:48)
        at com.sun.proxy.$Proxy5.invoke(Unknown Source)
        at org.gocom.abframe.auth.Login_flow.subprocess0(Login_flow.java:472)
        at org.gocom.abframe.auth.Login_flow._login(Login_flow.java:881)
        at org.gocom.abframe.auth.Login_flow.process(Login_flow.java:941)
        at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
        at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
        at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
        at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
        at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
        at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:127)
        at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
        at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:133)
        at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
        at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
        at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
        at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:122)
        at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:54)
        at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:662)
reverse

【解答】

1.请再仔细检查一遍context.xml中的数据库连接各个信息是否填写完全正确，比如多字少字等输入失误情况

2.如输入完全正确仍然存在问题，请在数据库连接Resource中增加以下三个参数： removeAbandoned="true" removeAbandonedTimeout="600" logAbandoned="true" 两个DataSource中均增加上。

3、然后保存，重启SAM测试