Re: POI, Java and RNX0301

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

On Wed, Sep 10, 2008 at 6:05 AM, Dame, Mark <mark.dame@xxxxxxxxxxxxxx>wrote:

Has anyone run into size limitations using POI HSSF (not Excel's limit,
but the RPG interface)? I'm trying to write a program that generates 6
files with 2 worksheets each. The first three files are generated fine.
It gets to the fourth and throw an unknown java error. In the debugger,
each java object looks like an integer. The last method called that
works is createCell, which generates object 2,096,624. The call to
setCellType on that cell then throws the error. It's almost as if that
cell wasn't created because it ran out of handles.

I've also had the same problem with a single file multi-worksheet
program. The number of java objects hits a certain point and it throws
an unknown java error. That program has variable amounts of data so
sometimes it produces a spreadsheet, sometimes not. Again, not Excel's
limit, but something in the objects I think.

I'm a java newbie, so the handles thing is just speculation and it could
be something else. If anyone's solved this, or there's some environment
variable to set, I'd love to know.

TIA
Mark Dame
mark.dame@xxxxxxxxxxxxxx
Phone: (330) 926-5407
Fax: (330) 926-5421




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.
--
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.