java.net.SocketException: Connection reset by peer: socket write error

用POI导出Excel的时候（大数据量），反复调用导出方法几次会出现一下异常

 

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 org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:750)
	at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:432)
	at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:347)
	at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:773)
	at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:126)
	at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:583)
	at org.apache.coyote.Response.doWrite(Response.java:560)
	at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:365)
	at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:432)
	at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:347)
	at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:396)
	at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:385)
	at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:89)
	at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:83)
	at org.apache.poi.poifs.storage.BigBlock.doWriteData(BigBlock.java:55)
	at org.apache.poi.poifs.storage.DocumentBlock.writeData(DocumentBlock.java:220)
	at org.apache.poi.poifs.storage.BigBlock.writeBlocks(BigBlock.java:86)
	at org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore.writeBlocks(POIFSDocument.java:603)
	at org.apache.poi.poifs.filesystem.POIFSDocument.writeBlocks(POIFSDocument.java:275)
	at org.apache.poi.poifs.filesystem.POIFSFileSystem.writeFilesystem(POIFSFileSystem.java:263)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:916)
	at alpha.gpsf.web.SpeedingQueryAction.exportExcel(SpeedingQueryAction.java:163)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)

 

workbook.write(response.getOutputStream());

//加上下面两句搞定
response.getOutputStream().flush();
response.getOutputStream().close();