getOutputStream() has already been called for this response问题

Question

错误信息
严重: Servlet.service() for servlet jsp threw exception
java.lang.IllegalStateException: getOutputStream() has already been called for this response
at org.apache.catalina.connector.Response.getWriter(Response.java:610)
at org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:198)
at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:112)
at org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:125)
at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:118)
at org.apache.jasper.runtime.PageContextImpl.release(PageContextImpl.java:180)
at org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(JspFactoryImpl.java:118)
at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:77)
at org.apache.jsp.WEB_002dINF.pages.successMessage_jsp._jspService(successMessage_jsp.java:69)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at org.apache.struts2.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:156)
at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)
at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:361)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:265)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:128)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at plantix.web.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at plantix.core.context.ThreadContextCleanerFilter.doFilter(ThreadContextCleanerFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
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:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Unknown Source)

Answer 1

后台方法：
方法可以到处数据，但是后台总是报上面的错误。
/**
 * @TNC
 * 写入数据到Excel，并导出
 */
public String writeExcel() {
HttpSession session = this.getRequest().getSession();
try {
// String filename = "";
// if(!"".equals(this.tongjiVO) && this.tongjiVO != null){
// if (!"".equals(this.tongjiVO.getStartTime())) {
// filename = filename.concat(this.tongjiVO.getDepartment()+"_");
// }
// if (!"".equals(this.tongjiVO.getStartTime())) {
// filename = filename.concat(this.tongjiVO.getStartTime()+"_");
// }
// filename = filename.concat("数据统计登记簿");
// }else{
// filename = filename.concat("整体导出数据统计登记簿");
// }
String filename = "数据统计登记簿";
this.getResponse().setHeader("Content-Disposition", "attachment;filename="+new String(filename.getBytes(),"iso8859-1")+".xls");
OutputStream os = this.getResponse().getOutputStream();
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("单表交易", 0);
String[] title = {"编号","需求部门","需求提交人","任务编号","任务名称","执行人","状态","是否定期统计频数","需求开始时间","持续时间","提供数据说明"};
jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,false);
jxl.write.WritableCellFormat wwcf = new jxl.write.WritableCellFormat(wf);
jxl.write.WritableFont wf2 = new jxl.write.WritableFont(WritableFont.TIMES,10,WritableFont.NO_BOLD,false);
jxl.write.WritableCellFormat wwcf2 = new jxl.write.WritableCellFormat(wf2);
wwcf2.setWrap(true);
for (int i = 0; i < title.length; i++) {
ws.addCell(new Label(i, 0, title[i],wwcf));
}
List<Datas2VO> list = null;
if (null != session.getAttribute("list")) {
list = (List<Datas2VO>) session.getAttribute("list");
}else {
setMessage("导出Excel模板失败！");
return "failureMessage";
}
if (null != list) {
Datas2VO dvo = new Datas2VO();
for (int i = 1; i < list.size() + 1; i++) {
dvo = (Datas2VO) list.get(i-1);
//添加编号
Label label = new Label(0, i, dvo.getId());
ws.setColumnView(0, 8);
ws.addCell(label);
//添加需求部门
label = new Label(1, i, dvo.getDepartment());
ws.setColumnView(1, 15);
ws.addCell(label);
//添加需求提交人
label = new Label(2, i, dvo.getSubmitter());
ws.setColumnView(2, 15);
ws.addCell(label);
//添加任务编号
label = new Label(3, i, dvo.getTaskId());
ws.setColumnView(3, 15);
ws.addCell(label);
//添加编号名称
label = new Label(4, i, dvo.getTaskName(),wwcf2);
ws.setColumnView(4, 35);
ws.addCell(label);
//添加执行人
label = new Label(5, i, dvo.getExecutor());
ws.setColumnView(5, 10);
ws.addCell(label);
//添加状态
label = new Label(6, i, dvo.getStatue());
ws.setColumnView(6, 10);
ws.addCell(label);
//添加是否定期统计频数
label = new Label(7, i, dvo.getWhether());
ws.setColumnView(7, 15);
ws.addCell(label);
//添加需求开始时间
label = new Label(8, i, dvo.getStartTime());
ws.setColumnView(8, 20);
ws.addCell(label);
//添加持续时间
label = new Label(9, i, dvo.getDuration());
ws.setColumnView(9, 15);
ws.addCell(label);
//添加提供数据说明
label = new Label(10, i, dvo.getContext(),wwcf2);
ws.setColumnView(10, 30);
ws.addCell(label);
}
wwb.write();
wwb.close();
os.flush();
os.close();
this.getResponse().flushBuffer();
}else {
setMessage("导出Excel模板失败！");
return "failureMessage";
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
setMessage("导出Excel模板失败！");
return "failureMessage";
}
// finally{
// session.invalidate();
// session.removeAttribute("list");
// }
setMessage("成功导出Excel模板");
return "successMessage";
}

Answer 2

在使用完输出流以后调用以下两行代码即可：
out.clear();
pageContext.pushBody();

Answer 3

具体可以参考：http://blog.csdn.net/ylz2007/archive/2008/08/19/2798520.aspx

Answer 4

页面是自定义的Ext组建：
js：
function doDownload(){
Ext.getBody().mask("数据下载中，请稍等...","x-mask-loading");
window.location.href="Datas2Action_writeExcel.action";
Ext.getBody().unmask();
}form代码：
<p:form id="searchform" border="false" columns="2" width="100%" labelWidth="80"
url="Datas2Action_findDatas2ByWhere.action" resultGrid="datas2grid">

<p:text name="datas2VO.id" fieldLabel="编号" width="150"/>

<p:text name="datas2VO.department" fieldLabel="部门" width="150"/>

<p:text name="datas2VO.submitter" fieldLabel="提交人" width="150"/>

<p:text name="datas2VO.taskId" fieldLabel="任务编号" width="150"/>

<p:textarea name="datas2VO.taskName" fieldLabel="任务名称" width="150"/>

<p:text name="datas2VO.executor" fieldLabel="执行人" width="150"/>

<p:date name="datas2VO.stime1" fieldLabel="从" width="150"/>

<p:date name="datas2VO.stime2" fieldLabel="到" width="150"/>

<p:text name="datas2VO.statue" fieldLabel="状态" width="150"/>

<p:text name="datas2VO.whether" fieldLabel="定期统计频数" width="150"/>

<p:text name="datas2VO.duration" fieldLabel="持续时间" width="150"/>

<p:text name="datas2VO.context" fieldLabel="提供数据说明" width="150"/>

<p:hidden name="datas2VO.startTime" />

<p:button id="button2" iconCls="btn-reset" text="重置" type="reset" />

<p:button id="upload" text="导入数据" type="button" onClick="openUploadWindow"/>

<p:button id="down" text="导出数据" type="button" onClick="doDownload"/>

</p:form>

Answer 5

我在网上看了解决方法，其实就是在执行完输出流之后执行两行代码：
out.clear();
out = pageContext.pushBody();
但是不知道我应该在这个页面的什么吗位置写，刚开始接触Ext的，不会整啊，有一点错页面就无法加载，空页面

Answer 6

放在writeExcel中的输出流关闭后就成。

Answer 7

return null;就可以了！
getOutputStream() 和 response冲突

Answer 8

我在网上看别人都是写在页面中的小脚本中，但是我是在后台写的，这样没关系吗？
pagecontext和out不是页面的内置对象吗？

Answer 9

我看错了，这种情况下是不允许返回值的。。最好采用void

Answer 10

out.clear();
out = pageContext.pushBody();
这个是在jsp页面写的，我的是后台进入action程序里报的这个错误应该怎么解决呢谢谢

Answer 11

我的那个也后台问题。我写的那个方法返回了一个String类型的值，冲突了。问题是八楼帮助解决的。
你可以看一下你写的那个方法是否有返回值，如果有修改成void无返回值的。
如果和我的错误不一样，那你就在看看吧，呵呵