I cannot seem to create an XSSFWorkbook. HSSFWorkbook does fine with
no problems. The exception happens on this line:
wb = new XSSFWorkbook();
which is part of an if statement where I check if the data I am using
has more than 255 columns and if it does creates the XSSFWorkbook
instead of an HSSFWorkbook.
I included the code snippet where the exception happens (this is from
my test case which runs during maven build). I get the same failure at
runtime and in eclipse. I also included the dependency info since I
think this is probably a dependency issue. I have tried putting in
xmlbeans-2.2.0 and 2.4.0 as well as the one that comes by default
(2.3.0) but I get the same error every time.
I am open to any ideas and suggestions.
I have these maven dependencies in the project:
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.5-FINAL</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.5-FINAL</version>
</dependency>
Which result in the following extra jars in my war file:
ooxml-schemas-1.0.jar
poi-3.5-FINAL.jar
poi-ooxml-3.5-FINAL.jar
stax-api-1.0.1.jar
xmlbeans-2.3.0.jar
Here is the exception:
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:918)
at java.lang.reflect.Field.getFieldAccessor(Field.java:899)
at java.lang.reflect.Field.get(Field.java:358)
at
org.apache.xmlbeans.XmlBeans.typeSystemForClassLoader(XmlBeans.java:770)
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook.<clinit>(Unknown
Source)
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorkbook$Factory.newInstance(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:222)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:138)
at
org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.getAsWorkbook(ExportResponsesBean.java:331)
at
org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBeanTest.testGetAsWorkbookBig(ExportResponsesBeanTest.java:76)
Caused by: 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)
... 39 more
Caused by: 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:513)
... 41 more
Caused by: 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)
... 45 more
Here is the maven list of jars being used at test time:
[DEBUG] Test Classpath :
[DEBUG] /opt/sakai_2-6-x/sam/samigo-app/target/test-classes
[DEBUG] /opt/sakai_2-6-x/sam/samigo-app/target/classes
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/kernel/sakai-kernel-util/1.0.12/sakai-kernel-util-1.0.12.jar
[DEBUG]
/Users/azeckoski/.m2/repository/javax/servlet/servlet-api/2.4/servlet-api-2.4.jar
[DEBUG]
/Users/azeckoski/.m2/repository/net/sf/ehcache/ehcache/1.3.0/ehcache-1.3.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/net/sf/jsr107cache/jsr107cache/1.0/jsr107cache-1.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/backport-util-concurrent/backport-util-concurrent/3.0/backport-util-concurrent-3.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-logging/commons-logging/1.0.4/commons-logging-1.0.4.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/hibernate/hibernate/3.2.5.ga/hibernate-3.2.5.ga.jar
[DEBUG]
/Users/azeckoski/.m2/repository/javax/transaction/jta/1.0.1B/jta-1.0.1B.jar
[DEBUG]
/Users/azeckoski/.m2/repository/asm/asm-attrs/1.5.3/asm-attrs-1.5.3.jar
[DEBUG] /Users/azeckoski/.m2/repository/dom4j/dom4j/1.6.1/dom4j-1.6.1.jar
[DEBUG] /Users/azeckoski/.m2/repository/antlr/antlr/2.7.6/antlr-2.7.6.jar
[DEBUG] /Users/azeckoski/.m2/repository/cglib/cglib/2.1_3/cglib-2.1_3.jar
[DEBUG] /Users/azeckoski/.m2/repository/asm/asm/1.5.3/asm-1.5.3.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-collections/commons-collections/3.1/commons-collections-3.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/springframework/spring/2.0.6/spring-2.0.6.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/kernel/sakai-kernel-api/1.0.12/sakai-kernel-api-1.0.12.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/kernel/sakai-component-manager/1.0.12/sakai-component-manager-1.0.12.jar
[DEBUG]
/Users/azeckoski/.m2/repository/uk/org/ponder/sakairsf/SakaiRSFComponents-evolvers/0.7.2-sakai_2.2.x/SakaiRSFComponents-evolvers-0.7.2-sakai_2.2.x.jar
[DEBUG]
/Users/azeckoski/.m2/repository/uk/org/ponder/rsfutil/RSFComponents-evolvers/0.7.2/RSFComponents-evolvers-0.7.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/uk/org/ponder/rsfutil/rsfutil/0.7.2/rsfutil-0.7.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/uk/org/ponder/j-servletutil/1.2.2/j-servletutil-1.2.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/uk/org/ponder/ponderutilcore/1.2.2/ponderutilcore-1.2.2.jar
[DEBUG] /Users/azeckoski/.m2/repository/log4j/log4j/1.2.8/log4j-1.2.8.jar
[DEBUG] /Users/azeckoski/.m2/repository/junit/junit/3.8.2/junit-3.8.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/xpp3/xpp3_min/1.1.3.4.O/xpp3_min-1.1.3.4.O.jar
[DEBUG]
/Users/azeckoski/.m2/repository/uk/org/ponder/sakairsf/sakairsf/0.7.2-sakai_2.2.x/sakairsf-0.7.2-sakai_2.2.x.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-util/M2/sakai-util-M2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-samigo-api/2.6-SNAPSHOT/sakai-samigo-api-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-samigo-hibernate/2.6-SNAPSHOT/sakai-samigo-hibernate-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/navigo/OKI-SPRING-HIBERNATE/0/OKI-SPRING-HIBERNATE-0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/navigo/SakaiBaseFramework/1.0.a1/SakaiBaseFramework-1.0.a1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-jsf-tool/2.6-SNAPSHOT/sakai-jsf-tool-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-jsf-app/2.6-SNAPSHOT/sakai-jsf-app-2.6-SNAPSHOT.jar
[DEBUG] /Users/azeckoski/.m2/repository/jsf/jsf-api/1.1.01/jsf-api-1.1.01.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-sections-impl/2.6-SNAPSHOT/sakai-sections-impl-2.6-SNAPSHOT.jar
[DEBUG] /Users/azeckoski/.m2/repository/OKI/OkiSID/rc6.1/OkiSID-rc6.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/aopalliance/aopalliance/1.0/aopalliance-1.0.jar
[DEBUG] /Users/azeckoski/.m2/repository/axis/axis/1.1/axis-1.1.jar
[DEBUG] /Users/azeckoski/.m2/repository/axis/axis-ant/1.1/axis-ant-1.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/cglib/cglib-full/2.0.2/cglib-full-2.0.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-codec/commons-codec/1.2/commons-codec-1.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-beanutils/commons-beanutils/1.7.0/commons-beanutils-1.7.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-digester/commons-digester/1.6/commons-digester-1.6.jar
[DEBUG]
/Users/azeckoski/.m2/repository/xml-apis/xml-apis/1.0.b2/xml-apis-1.0.b2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-discovery/commons-discovery/0.2/commons-discovery-0.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-jxpath/commons-jxpath/1.1/commons-jxpath-1.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/ant/ant-optional/1.5.1/ant-optional-1.5.1.jar
[DEBUG] /Users/azeckoski/.m2/repository/jdom/jdom/1.0/jdom-1.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-validator/commons-validator/1.0.2/commons-validator-1.0.2.jar
[DEBUG] /Users/azeckoski/.m2/repository/oro/oro/2.0.7/oro-2.0.7.jar
[DEBUG] /Users/azeckoski/.m2/repository/fop/fop/0.20.5/fop-0.20.5.jar
[DEBUG]
/Users/azeckoski/.m2/repository/batik/batik-1.5-fop/0.20-5/batik-1.5-fop-0.20-5.jar
[DEBUG] /Users/azeckoski/.m2/repository/xalan/xalan/2.6.0/xalan-2.6.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/xerces/xercesImpl/2.6.2/xercesImpl-2.6.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/avalon-framework/avalon-framework/4.0/avalon-framework-4.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/jdbc/jdbc2_0/stdext-h2.1.8/jdbc2_0-stdext-h2.1.8.jar
[DEBUG]
/Users/azeckoski/.m2/repository/jsf/jsf-impl/1.1.01/jsf-impl-1.1.01.jar
[DEBUG] /Users/azeckoski/.m2/repository/ojb/db-ojb/1.0.rc6/db-ojb-1.0.rc6.jar
[DEBUG] /Users/azeckoski/.m2/repository/odmg/odmg/3.0/odmg-3.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/saxpath/saxpath/1.0-FCS/saxpath-1.0-FCS.jar
[DEBUG]
/Users/azeckoski/.m2/repository/axis/axis-saaj/1.2-RC1/axis-saaj-1.2-RC1.jar
[DEBUG] /Users/azeckoski/.m2/repository/struts/struts/1.1/struts-1.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/struts/struts-legacy/1.1/struts-legacy-1.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-fileupload/commons-fileupload/1.1.1/commons-fileupload-1.1.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-io/commons-io/1.4/commons-io-1.4.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-lang/commons-lang/2.1/commons-lang-2.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/taglibs/standard/1.0.4/standard-1.0.4.jar
[DEBUG] /Users/azeckoski/.m2/repository/wsdl4j/wsdl4j/1.4/wsdl4j-1.4.jar
[DEBUG]
/Users/azeckoski/.m2/repository/axis/axis-jaxrpc/1.2-RC1/axis-jaxrpc-1.2-RC1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-samigo-services/2.6-SNAPSHOT/sakai-samigo-services-2.6-SNAPSHOT.jar
[DEBUG] /Users/azeckoski/.m2/repository/ims/imsqti/1.2/imsqti-1.2.jar
[DEBUG] /Users/azeckoski/.m2/repository/xmlbeans/xbean/2.2.0/xbean-2.2.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/xmlbeans/jsr173/1.0_api/jsr173-1.0_api.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-samigo-qti/2.6-SNAPSHOT/sakai-samigo-qti-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-samigo-cp/2.6-SNAPSHOT/sakai-samigo-cp-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-samigo-audio/2.6-SNAPSHOT/sakai-samigo-audio-2.6-SNAPSHOT.jar
[DEBUG] /Users/azeckoski/.m2/repository/liveconnect/plugin/1.5/plugin-1.5.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-sections-api/2.6-SNAPSHOT/sakai-sections-api-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-sections-impl-standalone/2.6-SNAPSHOT/sakai-sections-impl-standalone-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/myfaces/core/myfaces-api/1.1.5/myfaces-api-1.1.5.jar
[DEBUG]
/Users/azeckoski/.m2/repository/javax/servlet/jstl/1.1.2/jstl-1.1.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/myfaces/core/myfaces-impl/1.1.5/myfaces-impl-1.1.5.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-el/commons-el/1.0/commons-el-1.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/myfaces/tomahawk/tomahawk/1.1.3/tomahawk-1.1.3.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/entitybroker/entitybroker-api/1.3.6.2-SNAPSHOT/entitybroker-api-1.3.6.2-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-jsf-widgets/2.6-SNAPSHOT/sakai-jsf-widgets-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-jsf-widgets-sun/2.6-SNAPSHOT/sakai-jsf-widgets-sun-2.6-SNAPSHOT.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/sakaiproject/sakai-gradebook-service-api/2.6-SNAPSHOT/sakai-gradebook-service-api-2.6-SNAPSHOT.jar
[DEBUG] /Users/azeckoski/.m2/repository/OKI/OkiOSID/2.0/OkiOSID-2.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/javax/activation/activation/1.0.2/activation-1.0.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-dbcp/commons-dbcp/1.2.2/commons-dbcp-1.2.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/commons-pool/commons-pool/1.2/commons-pool-1.2.jar
[DEBUG]
/Users/azeckoski/.m2/repository/hsqldb/hsqldb/1.8.0.5/hsqldb-1.8.0.5.jar
[DEBUG]
/Users/azeckoski/.m2/repository/jaxen/jaxen/1.0-FCS-full/jaxen-1.0-FCS-full.jar
[DEBUG] /Users/azeckoski/.m2/repository/jta/jta/h2.1.8/jta-h2.1.8.jar
[DEBUG]
/Users/azeckoski/.m2/repository/javax/servlet/jsp-api/2.0/jsp-api-2.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/javax/sql/jdbc-stdext/2.0/jdbc-stdext-2.0.jar
[DEBUG] /Users/azeckoski/.m2/repository/javax/mail/mail/1.3.1/mail-1.3.1.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/poi/poi/3.5-FINAL/poi-3.5-FINAL.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/poi/poi-ooxml/3.5-FINAL/poi-ooxml-3.5-FINAL.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/poi/ooxml-schemas/1.0/ooxml-schemas-1.0.jar
[DEBUG]
/Users/azeckoski/.m2/repository/org/apache/xmlbeans/xmlbeans/2.3.0/xmlbeans-2.3.0.jar
[DEBUG] /Users/azeckoski/.m2/repository/stax/stax-api/1.0.1/stax-api-1.0.1.jar
Help? :-)
-AZ
--
Aaron Zeckoski (azeckoski (at) vt.edu)
Senior Research Engineer - CARET - University of Cambridge
https://twitter.com/azeckoski - http://www.linkedin.com/in/azeckoski
http://aaronz-sakai.blogspot.com/ - http://tinyurl.com/azprofile
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
