当前位置: 代码迷 >> Java Web开发 >> jsp在excel导入sql 2000数据库时的诡异异常
  详细解决方案

jsp在excel导入sql 2000数据库时的诡异异常

热度:174   发布时间:2016-04-17 01:00:50.0
jsp在excel导入sql 2000数据库时的诡异错误
导入正常,但是在控制台报错。
百度谷歌都没有搜到类似的错误。哦对了,搜到一个也是excel导入的下标异常错误,说是jar包太旧了,我换成最新的jxl.jar包还是不行。
错误如下
XML code
Warning:  Exception when parsing URL I2"I2".  Using default.java.lang.ArrayIndexOutOfBoundsException    at java.lang.System.arraycopy(Native Method)    at jxl.biff.StringHelper.getUnicodeString(StringHelper.java:189)    at jxl.read.biff.HyperlinkRecord.<init>(HyperlinkRecord.java:191)    at jxl.read.biff.SheetReader.read(SheetReader.java:435)    at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)    at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)    at com.dsxx.dao.ExcelDao.upExcelDb(ExcelDao.java:239)    at com.dsxx.service.ExcelService.upExcelToDb(ExcelService.java:60)    at com.dsxx.actions.PreWorkAction.getUploadPath(PreWorkAction.java:72)    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)    at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)    at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)    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:654)    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)    at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)    at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)    at com.dsxx.util.EncodingFilter.doFilter(EncodingFilter.java:19)    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:230)    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)    at java.lang.Thread.run(Thread.java:619)
  相关解决方案