java net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: 系统找不到指定的路径

debugcn 发表于 Dev

斯代利

当我尝试生成大于 7MB 的大文件 (Excel) 时，会发生以下异常。小于该大小的文件工作正常。

观察到当我尝试将 tomcat 升级到 v8.5.28 时会发生这种情况。它在 tomcat 8.0.14 中运行良好。

问题
我收到此错误的原因可能是什么？

下面是堆栈跟踪

net.sf.jasperreports.engine.JRRuntimeException: java.io.IOException: The system cannot find the path specified
at net.sf.jasperreports.engine.export.ooxml.BaseHelper.write(BaseHelper.java:64)
at net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter$1.writeText(JRXlsxExporter.java:1560)
at net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter$1.handle(JRXlsxExporter.java:1553)
at net.sf.jasperreports.engine.export.data.StringTextValue.handle(StringTextValue.java:43)
at net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter.exportText(JRXlsxExporter.java:1572)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:1344)
at net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter.exportPage(JRXlsxExporter.java:271)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:1116)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:964)
at com.test.report.base.jasper.JasperReports.JasperReportXlsPreview(JasperReports.java:230)
at com.test.report.base.jasper.ReportGenerator.doReport(ReportGenerator.java:32)
at com.test.report.web.ui.bean.ReportControl.print(ReportControl.java:869)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

CODE
生成Excel文件

    public String JasperReportXlsPreview(ExternalContext ext, HttpServletResponse response,
            Map<String, Object> mapParameter, JasperQueryResultDataSource queryResult, String reportLocation,
            String reportFilename) {
        String message = "";

        JasperReport jasperReport = null;
        JasperPrint jasperPrint = null;
        JRXlsxExporter exporter = null;
        OutputStream output = null;
        SimpleXlsxReportConfiguration configuration = null;

        reportFilename = reportFilename + ".xlsx";

        try {           
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-disposition", "attachment; filename=\"" + reportFilename + "\"");
            response.setContentLength(response.getBufferSize());
            jasperReport = JasperCompileManager.compileReport(reportLocation);
            jasperPrint = JasperFillManager.fillReport(jasperReport, mapParameter, queryResult);
            exporter = new JRXlsxExporter();
            exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
            exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(output));
            configuration = new SimpleXlsxReportConfiguration();
            configuration.setOnePagePerSheet(false);
            configuration.setWhitePageBackground(true);
            configuration.setDetectCellType(true);
            exporter.setConfiguration(configuration);
            exporter.exportReport();            
        } catch (Exception e) {
            e.printStackTrace();
            return "Error: " + e.getMessage();
        } finally {
            queryResult.destroy();
            jasperReport = null;
            jasperPrint = null;
            exporter = null;
            configuration = null;
            response = null;
            ext = null;
            reportFilename = null;
            queryResult = null;
            reportLocation = null;
            mapParameter = null;
        }

        System.gc();

        return message;
}

依赖项
jasperreport：6.5 Java：8

达达67

该错误是由 Tomcat 使用不存在/无效的临时目录引起的。

验证 Tomcat 脚本为java.io.tmpdirJava 系统属性设置的值。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。