Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers.
Post Reply
Posts: 1
Joined: Tue Feb 13, 2024 4:26 pm


Post by dans »

I have a simple read from a huge xlsx multiple spreasheets that starts with ss_open.. and ends with ss_close..
IF I RUN it twice, without logoff and login again, I have an error on ss_open due to a java "OutOfMemoryError"
Do I have to close / deallocate memory after I finish my process?
Scott Klement
Site Admin
Posts: 652
Joined: Sun Jul 04, 2021 5:12 am

Re: ss_open_object_group

Post by Scott Klement »

I'm not familiar with ss_open_object_group or ss_close. Can you explain what they do? Are they similar to ss_begin_object_group and ss_end_object_group? Perhaps you created your own similar tool?

ss_begin_object_group and ss_end_object_group merely tell Java that your program is done with the references to objects. If nothing else is referring to them, Java's garbage collection will free the memory that the objects were using. But if other things are referring to them, they'll stay in memory until all of the references are gone.

Whether you are doing something wrong in your code is very hard to say since we haven't been shown any code.
Post Reply