[jboss-jira] [JBoss JIRA] (DROOLS-5494) Uploading Excel Spreadsheets using OpenJDK 11

[Mario Fusco (Jira)]

     [ https://issues.redhat.com/browse/DROOLS-5494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)