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


  1.  Home
  2. RPG400-L
  3. August 2006

RE: Excel/POI - Please Help The Drowning Man



I changed to Scott's new version of the hssf service program. And, as John
Joiner pointed out, the "wwFile" definition in "hssf_open" was incorrectly
defined as "like(jFileOutputStream)" which I changed to FileInputStream.
This is just a silly mistake on my part. However... this would not cause any problems. A type O field in RPG (a Java "object") is really nothing more than a number. The actual object itself is stored in the JVM, not in your RPG program. The O field is a "reference" to that object. So the JVM creates the object, then returns a number that your program can use to refer to the object when it needs to. As long as the number was correct, having "FileOutputStream" instead of "FileInputStream" wouldn't make any difference at all. As long as the correct type is referenced on the prototype, that is. 

But, anyway, I agree that it's wrong and misleading and I'll update it.



If I run my 'read the s/sheet' job interactively, it WORKS EVERY TIME.
If I run it in batch, IT FAILS EVERY TIME on the 'open' (Java
IOException)!
This sounds an awful lot like something that I've already fixed. Since you appear to be using an old version of the code, could you please download an updated copy? For the sake of convienience, I've zipped up my copy of the code, and placed it at the following link: 

   http://www.scottklement.com/rpg/hssf.zip



Does anyone know what, in a batch job's environment, could be so different
from the interactive that the batch job would fail every time???
Not really, but there was an issue with java i/o exceptions that would occur if you don't have at least FDs open in the job. If you download the code above, it makes sure that there are at least 3 open.
The other thing you'll want to verify is that you have THREAD(*SERIALIZE) on the H-spec of your program.

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.