Thanks Kurt,
That looks like what I need!!
A couple of questions if you can advise please.
Do you know if POI3.8 is a late enough version to support this ?
We already have the ss_begin_object_group(100);
The archive indicates we need to add the D Specs below into the HSSF_H
member ...
But I am not understanding how just defining these will change the
processing to create the file on disk as opposed to in memory - do I need
to make any changes to either my program or the HSSFR4 service program ?
Any example or snippet of code would be appreciated.
D SXSSF_Workbook_Class...
D C 'org.apache.poi.xssf.streaming-
D .SXSSFWorkbook'
D SXSSFWorkbook S O CLASS(*JAVA:
SXSSF_WORKBOOK_CLASS)
D SXSSF_Workbook_Class...
D C 'org.apache.poi.xssf.streaming-
D .SXSSFWorkbook'
D SXSSFWorkbook S O CLASS(*JAVA:
SXSSF_WORKBOOK_CLASS)
*-----------------------------------------------------------------
* SXSSF_dispose(): Delete temporary file when done with save
*------------------------------------------------------------------
D SXSSF_dispose PR n
D EXTPROC(*JAVA
D : SXSSF_Workbook_Class
D :'dispose')
Thank you for your kind assistance
Don Brown
From: "Kurt Braman" <kbraman@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 13/09/2017 11:17 PM
Subject: Re: Java exception "java.lang.OutOfMemoryError: Java heap
space" when calling ...
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Don,
I use to encounter the same issue when building large excel files. Check
out the following links in the Midrange-L archive that discuss the
solution
that I found works to eliminate the out of memory error that java was
having. Since I switched to this method of building the excel file, I have
not had the memory error.
New SXSSF spreadsheet generation
https://archive.midrange.com/rpg400-l/201412/msg00087.html
POI Large File
https://archive.midrange.com/rpg400-l/201512/msg00034.html
midrange.com
