[15-8-31 11:00:12:739 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.738 DEBUG [com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo]: [request mobileno]******** [15-8-31 11:00:12:739 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.739 DEBUG [com.huawei.boss.hsc.common.utils.TimeStat]: [ TimeStat ] 解析报文号码 use(ms):43 [15-8-31 11:00:12:740 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.739 DEBUG [com.huawei.boss.hsc.common.utils.TimeStat]: [ TimeStat ] 开始业务处理 use(ms):0 [15-8-31 11:00:12:740 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.740 ERROR [com.huawei.boss.hsc.service.qryaccintegratedinfo.Router]: Area cache is empty! [15-8-31 11:00:12:808 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.752 ERROR [com.huawei.boss.hsc.service.qryaccintegratedinfo.Router]: Can't find area for mobileNo [***********]! org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Got minus one from a read callDSRA0010E: SQL 状态:00000,错误码:0。 at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732) ~[spring-2.5.6.jar:2.5.6] at com.huawei.boss.hsc.service.qryaccintegratedinfo.Router.queryMobileArea(Router.java:51) [classes/:?] at com.huawei.boss.hsc.service.qryaccintegratedinfo.Router.queryMobileAreaByBinarySearch(Router.java:97) [classes/:?] at com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo.callSubService(QryAccIntegratedInfo.java:159) [classes/:?] at com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo.doPost(QryAccIntegratedInfo.java:107) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [javax.j2ee.servlet.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [javax.j2ee.servlet.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:944) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3954) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:945) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:277) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214) [?:CC70.CF [cf151046.03]] at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113) [?:CC70.CF [cf151046.03]] at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) [com.ibm.ws.runtime.jar:?] at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [com.ibm.ws.runtime.jar:?] at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656) [com.ibm.ws.runtime.jar:?] Caused by: java.sql.SQLException: Got minus one from a read callDSRA0010E: SQL 状态:00000,错误码:0。 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) ~[ojdbc6.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:70) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1324) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) ~[bootstrap.jar:WAS70.SERV1 [cf291321.01]] at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1361) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2471) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1639) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2082) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1759) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2631) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1064) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:701) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:668) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:635) ~[com.ibm.ws.runtime.jar:?] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ~[spring-2.5.6.jar:2.5.6] ... 31 more Caused by: oracle.net.ns.NetException: Got minus one from a read call at oracle.net.ns.Packet.receive(Packet.java:243) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:70) ~[publiclib.jar:Oracle JDBC Driver version - "11.1.0.7.0-Production"] at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1324) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118) ~[bootstrap.jar:WAS70.SERV1 [cf291321.01]] at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1361) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2471) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1639) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2082) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1759) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2631) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1064) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:701) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:668) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:635) ~[com.ibm.ws.runtime.jar:?] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) ~[spring-2.5.6.jar:2.5.6] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ~[spring-2.5.6.jar:2.5.6] ... 31 more [15-8-31 11:00:12:816 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.812 ERROR [com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo]: [Request Error] com.huawei.boss.hsc.common.exception.BusinessException: Can't find area for mobileNo [*********]! at com.huawei.boss.hsc.service.qryaccintegratedinfo.Router.queryMobileArea(Router.java:57) ~[classes/:?] at com.huawei.boss.hsc.service.qryaccintegratedinfo.Router.queryMobileAreaByBinarySearch(Router.java:97) ~[classes/:?] at com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo.callSubService(QryAccIntegratedInfo.java:159) ~[classes/:?] at com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo.doPost(QryAccIntegratedInfo.java:107) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [javax.j2ee.servlet.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [javax.j2ee.servlet.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:944) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3954) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:945) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191) [com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:277) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214) [?:CC70.CF [cf151046.03]] at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113) [?:CC70.CF [cf151046.03]] at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) [com.ibm.ws.runtime.jar:?] at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) [com.ibm.ws.runtime.jar:?] at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.java:205) [com.ibm.ws.runtime.jar:?] at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656) [com.ibm.ws.runtime.jar:?] [15-8-31 11:00:12:846 GMT+08:00] 0000002c ServletWrappe I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [hsc-aep_war] [/hsc-aep] [/WEB-INF/interface/qryaccintegratedinfo/error.jsp]: 初始化成功。 [15-8-31 11:00:12:875 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.874 DEBUG [com.huawei.boss.hsc.common.utils.TimeStat]: [ TimeStat ] 【异常】组装报文,返回应答 use(ms):135 [15-8-31 11:00:12:875 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.875 INFO [com.huawei.boss.hsc.wsinterface.QryAccIntegratedInfo]: INOUT QryAccIntegratedInfo|ReqSeq:123456789|ReqMobileNo:**********|ReqTime:000|RespTime:20150831110012|UseTime:171 ms|RetCode:111|Can't find area for mobileNo [*********]! [15-8-31 11:00:12:876 GMT+08:00] 0000002c SystemOut O 2015-08-31 11:00:12.875 DEBUG [com.huawei.boss.hsc.common.utils.TimeStat]: [ TimeStat ] 打印业务日志 use(ms):1