여기서 잠깐!!

가. 접속이 안될 경우 : 방화벽 문제인지 살펴보세요 - 검색해보시면 많이 나옵니다.

제어판 - Windows 방화벽 - 고급 설정

나. 에러가 발생할 경우 : 권한(Permission)문제인지 살펴보세요 - 검색 고고!~

나-1-1. IIS에서 '사용 권한 편집'

나-1-2. 탐색기에서 '속성' - '보안'

나-2. 관련 유저(저는 'IUSR'와 'IIS_IUSRS')에 쓰기권한이 있어야합니다.

여기서 잠깐!!!

DB에 대한 설명은 생략했습니다.

localhost에 직접 설치하셔도 되고, 저는 DB Hosting서비스를 이용합니다.

성공의 비결로 [기록하는 습관]을 버려야 한다는 이론이 유럽의 유수 기업에서 각광을 받고 있다. 기록하면 시야가 좁아진다는 것이고, 노트 하는 습관은 인간 두뇌의 종합적 사고를 가로막는다는 것이다. 이 이론의 주인공은 런던을 主무대로 활약하고 있는 전직 언론인 '토니 부잔 '으로 그가 대신 내놓은 방법은 이른바 [마인드 맵]이다.

출처 : [네이버 지식백과] 마인드맵 [Mind map] (매일경제, 매경닷컴)
http://terms.naver.com/entry.nhn?docId=3852&cid=43659&categoryId=43659

File file = new File(UPLOAD_ABS_PATH_WINDOW);
if(!file.exists()){
   file.mkdirs();
  }
file = new File(UPLOAD_ABS_PATH_WINDOW+"scs2xls"+lcIndex+".xls");
if(!file.exists()){
  file.createNewFile();
}
FileOutputStream stream = new FileOutputStream(file);
 
wb.write(stream);
stream.close();

response.setHeader("Content-Disposition", "filename=scs2xls"+lcIndex+".xls");
response.setContentType("application/vnd.ms-excel");

byte b[] = new byte[1024];
  
BufferedInputStream fin = new BufferedInputStream(new FileInputStream(file));
BufferedOutputStream outs = new BufferedOutputStream(response.getOutputStream());

int read=0;
while((read=fin.read(b))!=-1){
   outs.write(b, 0, read);
  }
outs.flush();
fin.close();
outs.close();

out.clear();

response.setHeader("Content-Disposition", "filename=scs2xls"+lcIndex+".xls");

response.setHeader("Content-Disposition", "attachment;filename=scs2xls"+lcIndex+".xls");

12월 06, 2011 10:13:15 오후 org.apache.catalina.core.StandardWrapperValve invoke
심각: Servlet.service() for servlet [jsp] in context with path [/stdCost] threw exception [An exception occurred processing JSP page /contents/excel/action/getImportFileInfo.jsp at line 36

33:
34: //XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(UPLOAD_ABS_PATH_WINDOW+new String(lcFile.getBytes("ISO-8859-1"), "UTF-8")));
35:
36: Workbook wb = WorkbookFactory.create(new FileInputStream(UPLOAD_ABS_PATH_WINDOW+new String(lcFile.getBytes("ISO-8859-1"), "UTF-8")));
37: //Workbook wb = new SXSSFWorkbook(new FileInputStream(UPLOAD_ABS_PATH_WINDOW+lcFile));
38:
39: if(wb != null) {

Stacktrace:] with root cause
java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3044)
at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3065)
at org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3259)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1822)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXMLNS(PiccoloLexer.java:1293)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXML(PiccoloLexer.java:1261)
at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4808)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)
at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)
at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3454)
at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1276)
at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1263)
at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
at org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)
at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:183)
at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:175)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:227)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:159)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:174)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
at org.apache.jsp.contents.excel.action.getImportFileInfo_jsp._jspService(getImportFileInfo_jsp.java:220)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)

HTTP Status 500 -
--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /contents/excel/action/getImportFileInfo.jsp at line 36
33:   
34:   //XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(UPLOAD_ABS_PATH_WINDOW+new String(lcFile.getBytes("ISO-8859-1"), "UTF-8")));
35:   
36:   Workbook wb = WorkbookFactory.create(new FileInputStream(UPLOAD_ABS_PATH_WINDOW+new String(lcFile.getBytes("ISO-8859-1"), "UTF-8"))); 
37:   //Workbook wb = new SXSSFWorkbook(new FileInputStream(UPLOAD_ABS_PATH_WINDOW+lcFile));
38:   
39:   if(wb != null) {

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:567)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:456)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
root cause
javax.servlet.ServletException: java.lang.OutOfMemoryError: Java heap space
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840)
org.apache.jsp.contents.excel.action.getImportFileInfo_jsp._jspService(getImportFileInfo_jsp.java:369)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
root cause
java.lang.OutOfMemoryError: Java heap space
org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3044)
org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3065)
org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3259)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1822)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXMLNS(PiccoloLexer.java:1293)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXML(PiccoloLexer.java:1261)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4808)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)
org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3454)
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1276)
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1263)
org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)
org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:183)
org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:175)
org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:227)
org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:159)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:174)
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
org.apache.jsp.contents.excel.action.getImportFileInfo_jsp._jspService(getImportFileInfo_jsp.java:220)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.21 logs.
--------------------------------------------------------------------------------
Apache Tomcat/7.0.21

--- The error occurred while applying a result map.   
--- Check the 쿼리ID - AutoResultMap.
--- Check the result mapping for the 컬럼명 property.   
--- Cause: java.sql.SQLException: 부적합한 열 이름

<select id="selectDownData" parameterClass="excel" resultClass="java.util.HashMap" remapResults="true">

<table height="100%">

<table style="height:100%;">

Large Text File Viewer(LTFViewer)