欢迎使用普元产品知识库,本知识库包含普元应用开发平台EOSPlatform,流程平台BPS,企业服务总线ESB,微服务平台Microservice,运维管理平台Devops,数据集成平台DI

页面树结构

欢迎使用普元文档库

Skip to end of metadata
Go to start of metadata

【问题】

 

普元 EOS Platform 7.5 DB2数据库,执行查询命名SQL,报错:

Caused by:
com.primeton.das.sql.impl.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in /home/eos/profiles/nesc/installedApps/xxx/default.ear/default.war/WEB-INF/_srv/work/user/xxx/xxx/xxx/xxx/xxx.namingsql. 
--- The error occurred while applying a parameter map. 
--- Check the com.nesc.ynfanqizha.searchTransDetails.queryAccountInfo-InlineParameterMap. 
--- Check the statement (query failed). 
--- Cause: com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: T4Agent.sendRequest(). Communication API being used: OutputStream.flush(). Location where the error was detected: Connection timed out. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS   DB2ConnectionCorrelator: AC1085E6.AFE4.170620021457
 at com.primeton.das.sql.impl.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:259)
 at com.primeton.das.sql.impl.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:166)
 at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:634)
 at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:608)
 at com.primeton.das.sql.impl.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
 at com.primeton.das.sql.impl.NamedSqlSessionImpl.queryForList(NamedSqlSessionImpl.java:151)
 ... 64 more

【解答】

 

default应用和DB2数据库是在两台机器上,网络做了限制,无法正常通信导致查询报错