Re: Java exception "java.lang.OutOfMemoryError: Java heap space" when calling ...

Don,

We are currently using POI version 3.14, I'm not sure if this works with
version 3.8.

Below are the pieces of code that was added to the HSSF_H sourece member.

******************************************************************
* SXSSF (Streaming Usermodel API) Data Types
******************************************************************
dcl-c SXSSF_Workbook_Class 'org.apache.poi.xssf.streaming.SXSSFWorkbook';

dcl-s SXSSFWorkbook object(*JAVA: 'SXSSF_WORKBOOK_CLASS');


*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
* SXSSF_dispose
*
* Dispose of temporary files backing this workbook on disk.
* Calling this method will render the workbook unusable.
*
* Returns TRUE is all temporary files were delete successfully
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SXSSF_dispose PR N extproc(*java
:
SXSSF_Workbook_Class
:'dispose')


Added the following prototype after the new_XSSFWorkbook prototype

D new_SXSSFWorkbook...
D PR O class(*java
D : SXSSF_Workbook_Class )
D extproc(*java
D : SXSSF_Workbook_Class
D : *constructor)


Then in the program the prototype for new_XSSFWorkbook was changed to
new_SXSSFWorkbook as shown below.

// Create a new workbook.
wkBook = new_SXSSFWorkbook();

Then after the SS_save I added the call to SXSSF_dispose, as shown below.

// Save the workbook to the IFS.
SS_save( wkBook: wkFilename );
SXSSF_dispose( wkBook );

That was all that needed to can in the program to allow the streaming save
of the excel file.