vikramvy
Sep 3rd, 2010, 04:00 PM
I am trying to generate excel file of a records listed on a page. on the List page i placed a link for export.. on click has event - path requestContext/excel.xls
in web.xml - has servlet mapping *.xls to spring controller
Spring controller has bean of class - SimpleURLHandlerMapping
defined a prop key
<prop key="/user/excel.xls">excelExportController</prop>
ExcelExportController implements Controller (Spring Controller) and defines handlerequest.
return new ModelAndView(new ExcelExportPage(), modelMap);
//ExcelExportPage extends AbstractExcelView
rotected void buildExcelDocument(Map model, HSSFWorkbook wb,
HttpServletRequest request, HttpServletResponse response)
throws Exception
{
ExcelExportPage excelPageObj = new ExcelExportPage();
excelPageObj= (ExcelExportPage)model.get("excelObj");
// Entire Excel Generation and data population logic
}//buildExcelDocument Method Ends.
=====================================
On execution.. a popup is dispalyed excel.xls to Open/Save/cancel - Save Works fine.
When i click open...
i get following error.
please refer website:
http://www.zabada.com/tutorials/excel-generation-with-spring-and-poi.php
- start:
[9/3/10 14:01:26:071 CDT] 00000029 SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Cleared thread-bound request context: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:01:26:071 CDT] 00000029 SystemOut O DEBUG <,> [FrameworkServlet(processRequest)] - Successfully completed request
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@cae0cae] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@38de38de] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@2a002a00] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@2d8a2d8a] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getLastModified)] - Last-Modified value for [/ISDWeb/user/cases_for_client.xls] is [-1]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(doService)] - DispatcherServlet with name 'spring-controller' received request for [/ISDWeb/user/cases_for_client.xls]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Bound request context to thread: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [ControllerBase(handleRequestInternal)] - start:
[9/3/10 14:01:29:633 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(render)] - Rendering view [com.jpmorgan.isd.model.excelexport.ExcelExportPage : unnamed] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:633 CDT] 00000028 SystemOut O DEBUG <,> [AbstractView(render)] - Rendering view with name 'null' with model {excelObj=com.jpmorgan.isd.model.excelexport.Excel ExportPage: unnamed, wasMainMaximised=null} and static attributes {}
[9/3/10 14:01:29:821 CDT] 00000028 SystemOut O DEBUG <,> [AbstractExcelView(renderMergedOutputModel)] - Created Excel Workbook from scratch
[9/3/10 14:01:29:962 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Cleared thread-bound request context: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:01:29:962 CDT] 00000028 SystemOut O DEBUG <,> [FrameworkServlet(processRequest)] - Successfully completed request
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@cae0cae] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@38de38de] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@2a002a00] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@2d8a2d8a] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getLastModified)] - Last-Modified value for [/ISDWeb/user/cases_for_client.xls] is [-1]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(doService)] - DispatcherServlet with name 'spring-controller' received request for [/ISDWeb/user/cases_for_client.xls]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Bound request context to thread: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [ControllerBase(handleRequestInternal)] - start:
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(render)] - Rendering view [com.jpmorgan.isd.model.excelexport.ExcelExportPage : unnamed] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractView(render)] - Rendering view with name 'null' with model {excelObj=com.jpmorgan.isd.model.excelexport.Excel ExportPage: unnamed, wasMainMaximised=null} and static attributes {}
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractExcelView(renderMergedOutputModel)] - Created Excel Workbook from scratch
[9/3/10 14:02:05:133 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Cleared thread-bound request context: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:02:05:133 CDT] 0000002c SystemOut O DEBUG <,> [FrameworkServlet(processRequest)] - Successfully completed request
Please Help/suggest.
in web.xml - has servlet mapping *.xls to spring controller
Spring controller has bean of class - SimpleURLHandlerMapping
defined a prop key
<prop key="/user/excel.xls">excelExportController</prop>
ExcelExportController implements Controller (Spring Controller) and defines handlerequest.
return new ModelAndView(new ExcelExportPage(), modelMap);
//ExcelExportPage extends AbstractExcelView
rotected void buildExcelDocument(Map model, HSSFWorkbook wb,
HttpServletRequest request, HttpServletResponse response)
throws Exception
{
ExcelExportPage excelPageObj = new ExcelExportPage();
excelPageObj= (ExcelExportPage)model.get("excelObj");
// Entire Excel Generation and data population logic
}//buildExcelDocument Method Ends.
=====================================
On execution.. a popup is dispalyed excel.xls to Open/Save/cancel - Save Works fine.
When i click open...
i get following error.
please refer website:
http://www.zabada.com/tutorials/excel-generation-with-spring-and-poi.php
- start:
[9/3/10 14:01:26:071 CDT] 00000029 SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Cleared thread-bound request context: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:01:26:071 CDT] 00000029 SystemOut O DEBUG <,> [FrameworkServlet(processRequest)] - Successfully completed request
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@cae0cae] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@38de38de] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@2a002a00] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@2d8a2d8a] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getLastModified)] - Last-Modified value for [/ISDWeb/user/cases_for_client.xls] is [-1]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(doService)] - DispatcherServlet with name 'spring-controller' received request for [/ISDWeb/user/cases_for_client.xls]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Bound request context to thread: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:01:29:618 CDT] 00000028 SystemOut O DEBUG <,> [ControllerBase(handleRequestInternal)] - start:
[9/3/10 14:01:29:633 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(render)] - Rendering view [com.jpmorgan.isd.model.excelexport.ExcelExportPage : unnamed] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:01:29:633 CDT] 00000028 SystemOut O DEBUG <,> [AbstractView(render)] - Rendering view with name 'null' with model {excelObj=com.jpmorgan.isd.model.excelexport.Excel ExportPage: unnamed, wasMainMaximised=null} and static attributes {}
[9/3/10 14:01:29:821 CDT] 00000028 SystemOut O DEBUG <,> [AbstractExcelView(renderMergedOutputModel)] - Created Excel Workbook from scratch
[9/3/10 14:01:29:962 CDT] 00000028 SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Cleared thread-bound request context: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:01:29:962 CDT] 00000028 SystemOut O DEBUG <,> [FrameworkServlet(processRequest)] - Successfully completed request
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@cae0cae] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@38de38de] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [com.jpmorgan.isd.config.app.SimpleUrlHandlerMappin g2@2a002a00] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractUrlHandlerMapping(getHandlerInternal)] - Looking up handler for [/user/cases_for_client.xls]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandler)] - Testing handler map [org.springframework.web.servlet.handler.SimpleUrlH andlerMapping@2d8a2d8a] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getLastModified)] - Last-Modified value for [/ISDWeb/user/cases_for_client.xls] is [-1]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(doService)] - DispatcherServlet with name 'spring-controller' received request for [/ISDWeb/user/cases_for_client.xls]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Bound request context to thread: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.HttpRequestHan dlerAdapter@57d057d0]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(getHandlerAdapter)] - Testing handler adapter [org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter@652e652e]
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [ControllerBase(handleRequestInternal)] - start:
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(render)] - Rendering view [com.jpmorgan.isd.model.excelexport.ExcelExportPage : unnamed] in DispatcherServlet with name 'spring-controller'
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractView(render)] - Rendering view with name 'null' with model {excelObj=com.jpmorgan.isd.model.excelexport.Excel ExportPage: unnamed, wasMainMaximised=null} and static attributes {}
[9/3/10 14:02:05:117 CDT] 0000002c SystemOut O DEBUG <,> [AbstractExcelView(renderMergedOutputModel)] - Created Excel Workbook from scratch
[9/3/10 14:02:05:133 CDT] 0000002c SystemOut O DEBUG <,> [DispatcherServlet(doDispatch)] - Cleared thread-bound request context: com.ibm.ws.webcontainer.srt.SRTServletRequest@73ea 73ea
[9/3/10 14:02:05:133 CDT] 0000002c SystemOut O DEBUG <,> [FrameworkServlet(processRequest)] - Successfully completed request
Please Help/suggest.