This is an issue with writing files.
Eventually I'd like to learn to do spreadsheets with style sheets and
xml, just don't have time to do it today. Maybe the RPG-XML Suite is
the way (time, time, need more time). I discussed increasing the jvm
heap size with someone as a solution (I think that's how to implement
the increase memory proposal). The "more power" Tool Time solution
might work, but the program has performance issues now. More memory
means more objects which means even slower performance.
I like your solution Aaron, which I interpreted to be "create the java
spreadsheet objects in java". The pointer size problem in ile goes away
then. (I have one cell style in this app by the way, which is created
once and reused).
Relieved to hear it's not my implementation, it's a repeatable error.
When I didn't see anything in the mailing list archive, that was my
first concern. I got around the problem by splitting the program in
half. Submit once, create three files, submit again, create second
three files. As the distribution is an emailed link to the IFS folder
where the spreadsheets are, it doesn't matter that they are created
separately (vs emailing them as attachments, rpgmail rocks by the way) .
Thanks for the feedback everyone.
Mark Dame
mark.dame@xxxxxxxxxxxxxx
Phone: (330) 926-5407
Fax: (330) 926-5421
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: Thursday, September 11, 2008 7:12 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: POI, Java and RNX0301
I believe POI loads the whole file into memory before it does anything
else.
Maybe the original poster could clarify, but I think this was a case of
building an Excel document vs. processing an existing one.
or change your program to write the file in Open XML. I have never done
the
later, but I suppose it should be fairly straight forward.
Here's an XML Excel tutorial I put together for my product RPG-XML
Suite:
http://www.rpg-xml.com/2008EmailCampaigns/080108/Jan08.html
Of course you could substitute other text replacement engines in there
if you don't have RPG-XML Suite. Note the finished product only works
in Microsoft Office 2003 and greater. With that said, I don't know how
prevalent Open XML is because there was such controversy about the spec
(worldwide). I get the feeling some groups aren't pursuing it as fast
as they could/should because of the initial controversy.
Back to my hole,
Aaron Bartell
http://mowyourlawn.com
On Wed, Sep 10, 2008 at 10:14 PM, James Perkins
<jrperkinsjr@xxxxxxxxx>wrote:
I believe POI loads the whole file into memory before it does anything
else.
I've hit this several times when playing with it in Java. So that
could possibly be the issue. To see if this is the issue you could
decrease the memory on the JVM start-up and see if you get the error
sooner.
Now I don't think there is a real good solution for this though. You
could either increase the memory the JVM uses on start-up or change
your program to write the file in Open XML. I have never done the
later, but I suppose it should be fairly straight forward.
This is all just a guess, so I hope it might help at least a little.
HTH,
James R. Perkins
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
This message (including any attachments) contains confidential
and/or proprietary information intended only for the addressee.
Any unauthorized disclosure, copying, distribution or reliance on
the contents of this information is strictly prohibited and may
constitute a violation of law. If you are not the intended
recipient, please notify the sender immediately by responding to
this e-mail, and delete the message from your system. If you
have any questions about this e-mail please notify the sender
immediately.
midrange.com
