[ http://jira.codehaus.org/browse/DISPL-297?page=comments#action_59904 ] 

Jorge L. Barroso commented on DISPL-297:
----------------------------------------

Interesting bug; I've exported single rows with this view before, but I'll have 
a look.

> Can not export single row to excel by using "ExcelHssfView" and 
> "DefaultHssfExportView"
> ---------------------------------------------------------------------------------------
>
>          Key: DISPL-297
>          URL: http://jira.codehaus.org/browse/DISPL-297
>      Project: DisplayTag
>         Type: Bug

>   Components: Export
>     Versions: After 1.1
>     Reporter: Wallace Mu
>     Priority: Minor
>  Attachments: testExportSingleRow.jsp
>
>
> When the return resultSet just has one single row, it can not be export to 
> Excel. 
> But export to PDF, XML, CSV and RTF is OK.
> I change my "export.excel.class" setting in displaytag.properties, found that 
> :
> If I use "org.displaytag.export.excel.ExcelHssfView" or 
> "org.displaytag.export.excel.DefaultHssfExportView", it will have this error. 
> If I use "org.displaytag.export.ExcelView", it can export.
> If it is error, the following Exception is reported:
> ############################Message 
> begin###################################################
> HTTP Status 500 - 
> --------------------------------------------------------------------------------
> type Exception report
> message 
> description The server encountered an internal error () that prevented it 
> from fulfilling this request.
> exception 
> java.lang.IllegalStateException: getOutputStream() has already been called 
> for this response
>       org.apache.catalina.connector.Response.getWriter(Response.java:606)
>       
> org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:195)
>       org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:124)
>       
> org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:117)
>       
> org.apache.jasper.runtime.PageContextImpl.release(PageContextImpl.java:191)
>       
> org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(JspFactoryImpl.java:115)
>       
> org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:75)
>       
> org.apache.jsp.test.displayTab.testExportSingleRow_jsp._jspService(org.apache.jsp.test.displayTab.testExportSingleRow_jsp:545)
>       org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>       
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
>       org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>       org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>       cn.com.cunamutual.user.SessionChecker.doFilter(SessionChecker.java:47)
>       
> filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
> note The full stack trace of the root cause is available in the Apache 
> Tomcat/5.5.12 logs.
> --------------------------------------------------------------------------------
> Apache Tomcat/5.5.12
> ############################Message 
> end###################################################
> My "displaytag.properties" is showing follow:
> ######################displaytag.properties 
> Begin############################################
> #sort.behavior=list
> #sort.amount=list
> basic.empty.showtable=true
> #basic.msg.empty_list=No results matched your criteria.
> #paging.banner.placement=top
> #paging.banner.onepage=<span class="pagelinks"></span>
> export.types=csv excel xml pdf rtf
> #export.types=excel pdf
> export.excel=true
> export.csv=true
> export.xml=true
> export.pdf=true
> export.rtf=true
> export.amount=list
> export.excel.class=org.displaytag.export.excel.ExcelHssfView
> #export.excel.class=org.displaytag.export.excel.DefaultHssfExportView
> #export.excel.class=org.displaytag.export.ExcelView
> export.pdf.class=org.displaytag.export.PdfView
> export.rtf.class=org.displaytag.export.DefaultRtfExportView
> # if set, file is downloaded instead of opened in the browser window
> export.excel.filename=testExport
> export.pdf.filename=testExport
> export.csv.filename=testExport
> export.rtf.filename=testExport
> export.xml.filename=testExport
> # I18N  default "locale.provider" is "I18nJstlAdapter"
> #locale.provider=org.displaytag.localization.I18nStrutsAdapter
> #locale.provider=org.displaytag.localization.I18nJstlAdapter
> ######################displaytag.properties 
> End############################################

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
displaytag-devel mailing list
displaytag-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-devel

Reply via email to