HttpServletResponse res = LActionContext.getHttpServletResponse();

gos = ((HttpGauceResponse) res).getGauceOutputStream();

GauceDataSet dSet = new GauceDataSet();    
      
gos.fragment(dSet);

dSet = LGauceConverter.convertToGauceDataSet(result);

dSet.flush();
      
gos.write(dSet);      

gos.close();  

현재 요렇게 위에서 부터 아래로 진행되고 있습니다.

tyr{} carch{} finally{gos.close()}

finally에서 GauceOutputStream을 close 시켜주고 있고요.

개선방안 부탁드립니다.


>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : LG전자
>* GAUCE 버전 : 4.0.4.4
>* WAS 종류(WebLogic 등등) : Weblogic
>* DB 종류 : Oracle
>* 문의 유형(질문/요청/참조) : 질문
>* 내용 : 화면 조회하면서 대용량 데이터 조회시 아래의 에러가 잡힙니다.
>약 3만건 정도 까지는 괜찮은데 6만건 이상 올라가니 에러가 발생하네요.
>쿼리는 실행되서 DataSet에 데이터는 담았고
>DataSet을 JSP단으로 가져올때 에러가 나는거 같습니다.
>이럴때 해결방안 같은게 있나요??
>
>현재 ResultSet > LMultiData > DataSet > GauceOutputStream.write() 로 실행되는데
>
>GauceOutputStream.write()  에서 에러가 납니다.
>
>
>
>com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute()=>Connection reset by peer: socket write error
>JSP/Servlet Error (Catched by LAbstractGauceServlet) :[GSCPGauceServlet-catchService Failed ] Request URI: /analysis/salesPSINav/retrieveSalesPSISearchList.gau, User Location: 0:0:0:0:0:0:0:1(0:0:0:0:0:0:0:1)
>devon.core.exception.LBizException: ddgscp.com.err.retrieve
>        at com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute(ANLSalesPSIRetrieveCmd.java:90)
>        at devonframework.front.command.LCommandEngine.a(Unknown Source)
>        at devonframework.front.command.LCommandEngine.execute(Unknown Source)
>        at devonframework.front.channel.interceptor.LCommandInterceptor.doIntercept(Unknown Source)
>        at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
>        at devonframework.front.channel.interceptor.LConverterInterceptor.doIntercept(Unknown Source)
>        at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
>        at devonframework.front.channel.interceptor.LFileUploadInterceptor.doIntercept(Unknown Source)
>        at devonframework.front.channel.interceptor.LInterceptorChain.doIntercept(Unknown Source)
>        at devonframework.bridge.gauce.channel.LAbstractGauceServlet.process(Unknown Source)
>        at com.lge.ddgscp.framework.channel.GSCPGauceServlet.catchService(GSCPGauceServlet.java:110)
>        at devonframework.front.channel.LAbstractServlet.doGet(Unknown Source)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
>        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
>        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
>        at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
>        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
>        at com.lge.ddgscp.framework.util.CustomCharacterEncodingFilter.doFilter(CustomCharacterEncodingFilter.java:38)
>        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
>        at com.gauce.filter.GauceFilter.doFilter(Unknown Source)
>        at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
>        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
>        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
>        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
>        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
>        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
>        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
>        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
>        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
>        at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
>Caused by: java.net.SocketException: Connection reset by peer: socket write error
>        at java.net.SocketOutputStream.socketWrite0(Native Method)
>        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
>        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
>        at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:568)
>        at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:539)
>        at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:427)
>        at weblogic.servlet.internal.ChunkOutput$2.checkForFlush(ChunkOutput.java:648)
>        at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:333)
>        at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:148)
>        at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:148)
>        at com.gauce.io.bin.H.A(Unknown Source)
>        at com.gauce.io.bin.H.A(Unknown Source)
>        at com.gauce.io.bin.H.write(Unknown Source)
>        at com.lge.ddgscp.analysis.cmd.ANLSalesPSIRetrieveCmd.execute(ANLSalesPSIRetrieveCmd.java:82)
>        ... 31 more
>
>