java Excel 数据到导入在tomcat下正常，weblogic下异常原因

最新推荐文章于 2023-08-17 20:09:04 发布

转载最新推荐文章于 2023-08-17 20:09:04 发布 · 2.9k 阅读

本文介绍了一种在WebLogic服务器环境下导入Excel时遇到的异常问题及其解决方案。问题表现为使用Apache POI处理Excel文件时发生错误，特别是与XSSF相关的异常。通过分析，发现原因是WebLogic版本较低导致与Apache POI的兼容性问题。解决方案是在部署目录中添加一个weblogic.xml配置文件，以确保应用正确加载所需的库。

java Excel 数据到导入在tomcat下正常，weblogic下异常原因

org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException

at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:61)

at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:277)

at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:186)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:189)

at com.k8.crm.cust.service.CustExcelService.importLandData(CustExcelService.java:60)

Truncated. see log file for complete stacktrace

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59)

Truncated. see log file for complete stacktrace

java.lang.ExceptionInInitializerError

at sun.misc.Unsafe.ensureClassInitialized(Native Method)

at sun.reflect.UnsafeFieldAccessorFactory.newFieldAccessor(UnsafeFieldAccessorFactory.java:25)

at sun.reflect.ReflectionFactory.newFieldAccessor(ReflectionFactory.java:122)

at java.lang.reflect.Field.acquireFieldAccessor(Field.java:917)

at java.lang.reflect.Field.getFieldAccessor(Field.java:898)

Truncated. see log file for complete stacktrace

java.lang.RuntimeException: Could not instantiate SchemaTypeSystemImpl (java.lang.reflect.InvocationTargetException): is the version of xbean.jar correct?

at schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem(Unknown Source)

at schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.<clinit>(Unknown Source)

at sun.misc.Unsafe.ensureClassInitialized(Native Method)

at sun.reflect.UnsafeFieldAccessorFactory.newFieldAccessor(UnsafeFieldAccessorFactory.java:25)

at sun.reflect.ReflectionFactory.newFieldAccessor(ReflectionFactory.java:122)

Truncated. see log file for complete stacktrace

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

at schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.TypeSystemHolder.loadTypeSystem(Unknown Source)

Truncated. see log file for complete stacktrace

org.apache.xmlbeans.SchemaTypeLoaderException: XML-BEANS compiled schema: Incompatible minor version - expecting up to 23, got 24 (schemaorg_apache_xmlbeans.system.sE130CAA0A01A7CDE5A2B4FEB8B311707.index) - code 3

at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl$XsbReader.<init>(SchemaTypeSystemImpl.java:1522)

at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.initFromHeader(SchemaTypeSystemImpl.java:260)

at org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.<init>(SchemaTypeSystemImpl.java:183)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

Truncated. see log file for complete stacktrace

此bug的出现是因为weblogic的版本过低

修改方法添加一个weblogic.xml 文件

文件内容

<?xml version="1.0" encoding="UTF-8"?>

<weblogic-web-app xmlns="http://www.bea.com/ns/weblogic/90"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"