RE: POI, Java and RNX0301

I had a similar error. When I ran in debug, the problem turned out to be a
naming issue for one of the tabs. The program was trying to name a tab the
same as a previous tab.

Hth,

Frank

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Dame, Mark
Sent: Wednesday, September 10, 2008 8:06 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: POI, Java and RNX0301

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.