http://coldfusion.com logo
Join Slack
Powered by
using the great spreadsheet-cfml library and i am ...
# cfml-general
s
using the great spreadsheet-cfml library and i am encountering an error with an excel sheet
Copy code
javax.xml.parsers.FactoryConfigurationError
Provider for class javax.xml.parsers.SAXParserFactory cannot be created
@cfsimplicity or other, any thoughts on what is going on?
c
Doesn't mean much to me, sorry. Which method are you calling? And what does the top of the stack trace look like?
s
Copy code
lucee.runtime.exp.NativeException: Provider for class javax.xml.parsers.SAXParserFactory cannot be created
    at java.xml/javax.xml.parsers.FactoryFinder.findServiceProvider(FactoryFinder.java:305)
    at java.xml/javax.xml.parsers.FactoryFinder.find(FactoryFinder.java:261)
    at java.xml/javax.xml.parsers.SAXParserFactory.newInstance(SAXParserFactory.java:147)
    at org.apache.xmlbeans.impl.common.SAXHelper.saxFactory(SAXHelper.java:62)
    at org.apache.xmlbeans.impl.common.SAXHelper.newXMLReader(SAXHelper.java:47)
    at org.apache.xmlbeans.impl.store.Locale.getSaxLoader(Locale.java:2232)
    at org.apache.xmlbeans.impl.store.Locale.lambda$parseToXmlObject$3(Locale.java:717)
    at org.apache.xmlbeans.impl.store.Locale.syncWrap(Locale.java:490)
    at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:716)
    at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:233)
    at org.apache.xmlbeans.impl.schema.AbstractDocumentFactory.parse(AbstractDocumentFactory.java:71)
    at org.apache.poi.xssf.model.ThemesTable.readFrom(ThemesTable.java:119)
    at org.apache.poi.xssf.model.ThemesTable.<init>(ThemesTable.java:87)
    at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)
    at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:661)
    at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:260)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:118)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:98)
    at org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.create(XSSFWorkbookFactory.java:36)
    at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$2(WorkbookFactory.java:224)
    at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:329)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:224)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:185)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
spreadsheet.read
oddly its only happening on my mac, i tried it in production and its working. I wonder if its a lucee issue
c
Not really sure, tbh. You could try flushing the OSGi bundle in case there's some kind of installation snafu: 
spreadsheet.flushOsgiBundle()
p
Running same versions of Java in both environments?
s
ooh, there is a difference. im on java 8 in production. java 11 locally
p
Parser possibly not there in that version?
s
ill see if there is an update to java 11
p
I run OpenJDK Runtime Environment Zulu17.30+15-CA on my mac
s
i didn’t think commandbox could run on 17
p
Works for me, I forget if I needed to make some tweaks to get it working...its been about a year running this way
c
POI should run on Java 8
s
right, but does it run on OpenJDK java 11
c
Java 8+ I'm using AdoptOpenJDK 11 (on Windows and Linux)
s
ok weird, i will reinstall java and see if i get a different result
c
Is your java 8 install a JRE rather than JDK? I think POI needs the JDK.
s
my java 8 machine is working fine. its my java 11 machine that is having the error
c
Ah, sorry, got that backwards
4 Views
Open in Slack
PreviousNext
Powered by