× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



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