]
Mario Fusco updated DROOLS-5494:
--------------------------------
Sprint: 2020 Week 28-30 (from Jul 6)
Uploading Excel Spreadsheets using OpenJDK 11
---------------------------------------------
Key: DROOLS-5494
URL:
https://issues.redhat.com/browse/DROOLS-5494
Project: Drools
Issue Type: Bug
Components: decision tables
Affects Versions: 7.33.0.Final
Reporter: Ben-Johan van der Walt
Assignee: Mario Fusco
Priority: Major
Using Drools version 7.33.0.Final as well as 7.33.0.Final-redhat-00002.
When trying to upload an Excel Spreadsheet of type .xlsx I am getting a lot of error
trying to upload the file. I am able to import the Excel file via the import Asset button,
but not by using the "Add Asset" button and adding a new Spreadsheet asset and
then uploading the Excel file.
So I am using OpenJDK 11.0.7 and I think that is the reason for the errors.
There are a lot of issues with the libraries from org.apache.poi version 3.17 (e.g.
poi-3.17.jar, poi-ooxml-3.17.jar and poi-ooxml-schemas-3.17.jar) which are all part of the
drools or decision-central war file. Using OpenJDK you have to use at least version 4.1.1
and update a few other dependancies like commons-compress-1.19.jar and xmlbeans-3.1.0.jar
to get it to work.
I do not have a specific excel spreadsheet, but any spreadsheet of type .xlsx will cause
the error when trying to upload it.