Need some help with Apache POI jar dependency
I have Create a simple Process with a Service Task. I create a XSSF workbook and add Data from Database to Fill the xlsx sheet.
I then use a DocumentValue class to convert the workbook to Bonita Document variable which can be downloaded in process Forms.
The Apache POI jar is added to Dependency and manage jars section.
So far, this works well. I am able to achieve exactly what I was hoping for.
But When I build the bar file and install it in my server, the tasks keeps failing as presumably the Apache POI jars are missing in my server.
1) In my Process, I have added the Jars as process Dependency. But still i keep getting error Unable to load class org.apache.poi.xssf.usermodel.XSSFWorkbook due to missing dependency .
2) I am not using a connector as I am not familiar with Creating a Connector. But My Task has a Connectors in and there I have used groovy script to generate the Excel. It works fine but I cannot save that as a New Connector Definition.
3) Please suggest what way I can add the APACHE Library so that my process will work. I was hoping to Add the jars though Process files
4) If I need to add the jar in the Server, Please suggest where do i copy the files.
Considering the new version of Bonita does not use the home folder. Now everything is in Bonita Home in database. So I need to use Push and Pull Scripts to load configuration.