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

[Ben-Johan van der Walt (Jira)]

Ben-Johan van der Walt created DROOLS-5494:
----------------------------------------------

             Summary: 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


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)