Re: POI, Java and RNX0301

["James Perkins" <jrperkinsjr@xxxxxxxxx>]

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.