We use SXSSF method whenever we can. In this case, we're pulling in a
template spreadsheet, so I couldn't find a good way to use SXSSF. I'm also
not using the "java" command, so extentions like -XMX3G are a bit foreign
to me. I'm implementing the JVM through RPG.





From: Mitch Gallman <mgallman@xxxxxxxxxxxx>
To: Java Programming on and around the IBM i
<java400-l@xxxxxxxxxxxx>
Date: 06/01/2016 09:51 AM
Subject: RE: More than 2GB heap with 64 bit JVM?
Sent by: "JAVA400-L" <java400-l-bounces@xxxxxxxxxxxx>



If possible rather than increasing the heap you might want to change your
process to use the Streaming spreadsheet (SXSSF) functionality that POI
provides. This will allow you to build much bigger spreadsheets without
consuming so much memory.

https://poi.apache.org/spreadsheet/how-to.html#sxssf

If you still want to increase the max heap it would be done using the -Xmx
parameter (e.g. Java -Xmx3g Hello)...when I specify -Xmx4g on Java 1.6 I
get an error that the value is too large.

Mitch


-----Original Message-----
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Darren
Strong
Sent: Wednesday, June 01, 2016 8:27 AM
To: java400-l@xxxxxxxxxxxx
Subject: More than 2GB heap with 64 bit JVM?


I have a certain application running using the JNI (more specifically, RPG
calling Java Excel POI HSSF) to create a really large spreadsheet, and its
running out of memory/heap. We're running a 64bit JVM. If I can figure
out how to specify a larger maximum heap size, can I go beyond the current
2GB limit? Is there a way to alter the maximum heap size for a job? If
not by job, by default?

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.