Re: POI, Java and RNX0301

["Aaron Bartell" <aaronbartell@xxxxxxxxx>]

I have run into this with a large multi-tabbed spreadsheet I created while
at my previous employer.  I believe I resolved it by having cells re-use
font/style definitions vs. each cell having it's own.  I also adjusted the
interface to have more on the Java end (custom programming in Java) and that
took the report runtime from 30 minutes to 3 minutes when I put more of the
work on the Java side.  I get the feeling GC (Garbage Collection) isn't as
efficient when RPG and Java are exchanging thousands of object handles - but
that is purely speculation.

HTH,
Aaron Bartell
http://mowyourlawn.com

On Wed, Sep 10, 2008 at 8: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.