|
|
报错如下：
select '0' as id , gsmc as gs,'1.png' as tupian, ssjrbf,ssbylj,ssbytb,ssbnlj,sstbzzl,sswcjh from rbjk_cb_hz where riqi=today-1 and dm='1'order by ssbnlj desc
java.sql.SQLException: System or internal error java.net.SocketException: Connection reset by peer: socket write error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:430)
at com.informix.jdbc.IfxSqli.sendPrepare(IfxSqli.java:1165)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1081)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at com.justep.baas.data.Util.queryData(Util.java:60)
at com.picc.baas.baofei.BaofeiServlet.queryssbfbaofei(BaofeiServlet.java:317)
at com.picc.baas.baofei.BaofeiServlet.service(BaofeiServlet.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
三月 02, 2016 1:29:49 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet X5 Baas baofei Servlet threw exception
java.sql.SQLException: System or internal error java.net.SocketException: Connection reset by peer: socket write error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:430)
at com.informix.jdbc.IfxSqli.sendPrepare(IfxSqli.java:1165)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1081)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at com.justep.baas.data.Util.queryData(Util.java:60)
at com.picc.baas.baofei.BaofeiServlet.queryssbfbaofei(BaofeiServlet.java:317)
at com.picc.baas.baofei.BaofeiServlet.service(BaofeiServlet.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
2016-03-02 13:33:15 开始-WINDOW生成中间文件: /UI2/carbforder/index.w
2016-03-02 13:33:15 结束-WINDOW生成中间文件: /UI2/carbforder/index.w
2016-03-02 13:33:15 开始-中间文件生成缓存文件: /UI2/carbforder/index.w
2016-03-02 13:33:16 结束-中间文件生成缓存文件: /UI2/carbforder/index.w
2016-03-02 13:34:26 开始-WINDOW生成中间文件: /UI2/carbforder/index.w
2016-03-02 13:34:26 结束-WINDOW生成中间文件: /UI2/carbforder/index.w
2016-03-02 13:34:26 开始-中间文件生成缓存文件: /UI2/carbforder/index.w
2016-03-02 13:34:27 结束-中间文件生成缓存文件: /UI2/carbforder/index.w
select '0'as id,case when comcode[1,6]='230921' then '勃利支公司' when comcode[1,6]='230998' then '车商业务部' when comcode[1,6]='230902' then '新兴支公司' when comcode[1,6]='230995' then '次新车团队' when comcode[1,6]='230994' then '财产险团队' when comcode[1,6]='230992' then '营销服务部' when comcode[1,6]='230904' then '茄子河公司' when comcode[1,6]='230997' then '市直销团队' when comcode[1,6] in ('230903','230993')then '桃山支公司'end as gs,case when comcode[1,6] in ('230903','230993') then '230903.jpg' else comcode[1,6]||'.jpg' end as tupian, sum(sumpremium) as baofei from prpcmain where operatedate=today and underwriteflag in ('1','3') and comcode[1,4]='2309' group by 1,2,3 order by baofei desc
java.sql.SQLException: System or internal error java.net.SocketException: Connection reset by peer: socket write error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:430)
at com.informix.jdbc.IfxSqli.sendPrepare(IfxSqli.java:1165)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1081)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at com.justep.baas.data.Util.queryData(Util.java:60)
at com.picc.baas.baofei.BaofeiServlet.querytodaybaofei(BaofeiServlet.java:220)
at com.picc.baas.baofei.BaofeiServlet.service(BaofeiServlet.java:48)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
|
|
IP卡
狗仔卡
发表于 2016-3-2 13:43:27
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
楼主