× 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. JAVA400-L
  3. May 2005

RE: Jakarta POI HSSF question...

Regarding your original problem, please have a look at
http://archive.midrange.com/rpg400-l/200402/msg00301.html and then post the
complete stack trace.

java.io.InputStream is an abstract class that cannot be instantiated.  You
need to instantiate a concrete subclass of it like FileInputStream.

Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> Shane_Cessna@xxxxxxx
> Sent: Thursday, May 26, 2005 12:19 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Jakarta POI HSSF question...
> 
> is there a major difference between these 2 classes?
> 
> D jFileInputStream... 
> D                 S               O   CLASS(*JAVA 
> D                                     : 'java.io.FileInputStream')
>  
> D jInputStream... 
> D                 S               O   CLASS(*JAVA 
> D                                     : 'java.io.InputStream') 
> 
> Shane Cessna
> iSeries Programmer
> iSeries WAS Administrator
> North American Lighting, Inc.
> (618) 662-4483 x2776
> shane_cessna@xxxxxxx 
> 
> 
> 
> "Gary L Peskin" <garyp@xxxxxxxxxxxx>
> Sent by: java400-l-bounces@xxxxxxxxxxxx
> 05/26/2005 01:50 PM
> Please respond to
> Java Programming on and around the iSeries / AS400 
> <java400-l@xxxxxxxxxxxx>
> 
> 
> To
> "'Java Programming on and around the iSeries / AS400'" 
> <java400-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> RE: Jakarta POI HSSF question...
> 
> 
> 
> 
> 
> 
> Hmmm.  I'm looking this up.  In the meantime, can you please 
> do a WRKUSRJOB and see if there is a job starting with a Q 
> under your user name that might have spool files with the stack trace?
> 
> Thanks,
> Gary
> 
> > -----Original Message-----
> > From: java400-l-bounces@xxxxxxxxxxxx
> > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> > Shane_Cessna@xxxxxxx
> > Sent: Thursday, May 26, 2005 11:33 AM
> > To: Java Programming on and around the iSeries / AS400
> > Subject: RE: Jakarta POI HSSF question...
> > 
> > Gary,
> > 
> > Sorry, all it's got is this:
> > 
> >                          Work with Job Spooled Files
> > 
> > Job:   JPDLHS2        User:   SCESSNA        Number:   788748 
> > 
> > Type options, press Enter. 
> >   1=Send   2=Change   3=Hold   4=Delete   5=Display 
> > 6=Release 7=Messages
> > 
> >   8=Attributes        9=Work with printing status 
> > 
> >                  Device or                       Total   Current 
> > Opt  File        Queue       User Data   Status  Pages 
> > Page   Copies 
> > 
> >      QPJOBLOG    QEZJOBLOG   JPDLHS2      RDY        3 
> >         1
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  Bottom
> > Parameters for options 1, 2, 3 or command ===> 
> > F3=Exit   F10=View 3   F11=View 2   F12=Cancel   F22=Printers 
> >   F24=More
> > keys
> > 
> > Shane Cessna
> > iSeries Programmer
> > iSeries WAS Administrator
> > North American Lighting, Inc.
> > (618) 662-4483 x2776
> > shane_cessna@xxxxxxx
> > 
> > 
> > 
> > "Gary L Peskin" <garyp@xxxxxxxxxxxx>
> > Sent by: java400-l-bounces@xxxxxxxxxxxx
> > 05/26/2005 01:26 PM
> > Please respond to
> > Java Programming on and around the iSeries / AS400 
> > <java400-l@xxxxxxxxxxxx>
> > 
> > 
> > To
> > "'Java Programming on and around the iSeries / AS400'" 
> > <java400-l@xxxxxxxxxxxx>
> > cc
> > 
> > Subject
> > RE: Jakarta POI HSSF question...
> > 
> > 
> > 
> > 
> > 
> > 
> > They should be spool files with the batch job.  Try doing a 
> WRKSBMJOB 
> > and then selecting the job and then option 4.
> > 
> > Gary
> > 
> > > -----Original Message-----
> > > From: java400-l-bounces@xxxxxxxxxxxx 
> > > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> > > Shane_Cessna@xxxxxxx
> > > Sent: Thursday, May 26, 2005 10:58 AM
> > > To: Java Programming on and around the iSeries / AS400
> > > Subject: RE: Jakarta POI HSSF question...
> > > 
> > > Gary,
> > > 
> > > How do I go about accessing these spool files?
> > > 
> > > Shane Cessna
> > > iSeries Programmer
> > > iSeries WAS Administrator
> > > North American Lighting, Inc.
> > > (618) 662-4483 x2776
> > > shane_cessna@xxxxxxx
> > > 
> > > 
> > > 
> > > "Gary L Peskin" <garyp@xxxxxxxxxxxx> Sent by: 
> > > java400-l-bounces@xxxxxxxxxxxx
> > > 05/26/2005 09:55 AM
> > > Please respond to
> > > Java Programming on and around the iSeries / AS400 
> > > <java400-l@xxxxxxxxxxxx>
> > > 
> > > 
> > > To
> > > "'Java Programming on and around the iSeries / AS400'" 
> > > <java400-l@xxxxxxxxxxxx>
> > > cc
> > > 
> > > Subject
> > > RE: Jakarta POI HSSF question...
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > It would be helpful if we could see the full stack trace for the 
> > > IOException.  There should be spool files created for
> > System.err and
> > > System.out that would show this.
> > > 
> > > Gary
> > > 
> > > > -----Original Message-----
> > > > From: java400-l-bounces@xxxxxxxxxxxx 
> > > > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> > > > Shane_Cessna@xxxxxxx
> > > > Sent: Thursday, May 26, 2005 7:01 AM
> > > > To: Java Programming on and around the iSeries / AS400
> > > > Subject: RE: Jakarta POI HSSF question...
> > > > 
> > > > I've even tried hardcoding the .xls file name and
> > > spreadsheet name and
> > > > still get the same results...
> > > > 
> > > > /free
> > > >  hssf_begin_object_group(100);
> > > >  monitor;
> > > >    book =
> > > hssf_open('/home/scessna/excel/May05DailyLaborHours2.xls');
> > > >    monitor;
> > > >      spreadsheet = hssf_getSheet(book:'May 25');
> > > >      if spreadsheet = *null;
> > > >        spreadsheet = HSSF_newSheet(book:'May 25');
> > > >      endif;
> > > >    on-error;
> > > >      spreadsheet = HSSF_newSheet(book:'May 25');
> > > >    endmon;
> > > >  on-error;
> > > >    book = new_HSSFWorkbook();
> > > >    spreadsheet = HSSF_newSheet(book:'May 25');  endmon; 
> > > > HSSF_save(book:'/home/scessna/excel/May05DailyLaborHours2.xls');
> > > >  hssf_end_object_group();
> > > >  *inlr = *on;
> > > > /end-free
> > > > 
> > > > Shane Cessna
> > > > iSeries Programmer
> > > > iSeries WAS Administrator
> > > > North American Lighting, Inc.
> > > > (618) 662-4483 x2776
> > > > shane_cessna@xxxxxxx
> > > > 
> > > > 
> > > > 
> > > > michael@xxxxxxxxxxxxxxxxxx
> > > > Sent by: java400-l-bounces@xxxxxxxxxxxx
> > > > 05/26/2005 08:43 AM
> > > > Please respond to
> > > > Java Programming on and around the iSeries / AS400 
> > > > <java400-l@xxxxxxxxxxxx>
> > > > 
> > > > 
> > > > To
> > > > Java Programming on and around the iSeries / AS400 
> > > > <java400-l@xxxxxxxxxxxx> cc
> > > > 
> > > > Subject
> > > > RE: Jakarta POI HSSF question...
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > What's the actual error? What does %status show? See
> > > anything in the
> > > > job log?
> > > > 
> > > > > -------- Original Message --------
> > > > > Subject: RE: Jakarta POI HSSF question...
> > > > > From: Shane_Cessna@xxxxxxx
> > > > > Date: Thu, May 26, 2005 9:35 am
> > > > > To: Java Programming on and around the iSeries / AS400 
> > > > > <java400-l@xxxxxxxxxxxx>
> > > > > 
> > > > > sorry guys, I tried that in the CL...still get the same
> > > > results...if it
> > > > > helps, here's my source...the hssf_h & HSSF binding
> > > > direcotry is the
> > > > stuff
> > > > > that Scott Klement put in a few Club Tech newsletters for
> > > > > 
> > > > iSeriesNetwork.com...http://www.iseriesnetwork.com/noderesourc
> > > > es/code/clubtechcode/ExcelCrtDemo.zip
> > > > > 
> > > > > JPTESTC2 - CLP
> > > > > PGM
> > > > > CHGCURDIR  DIR('/')
> > > > > ADDENVVAR  ENVVAR(CLASSPATH) +
> > > > >              VALUE('.:QIBM/UserData/Java400/ext/poi-2.5.+
> > > > >              1-final-20040804.jar') REPLACE(*YES)
> > > > > CALL       PGM(JPTEST2)
> > > > > ENDPGM
> > > > > 
> > > > > JPTEST2 - RPGLE
> > > > > h dftactgrp(*no) bnddir('HSSF') thread(*serialize) h
> > > > > option(*srcstmt:*nodebugio:*noshowcpy) bnddir('QC2LE')  /copy 
> > > > > qsysinc/qrpglesrc,jni  /copy qrpglesrc,hssf_h
> > > > >  //---------------------------------------------
> > > > >  // Data Structures
> > > > >  //---------------------------------------------
> > > > > d                 ds 
> > > > > dmonthsshort                    48a   Inz('Jan +
> > > > > d                                          Feb +
> > > > > d                                          Mar +
> > > > > d                                          Apr +
> > > > > d                                          May +
> > > > > d                                          Jun +
> > > > > d                                          Jul +
> > > > > d                                          Aug + 
> > > > > d                                          Sep + 
> > > > > d                                          Oct + 
> > > > > d                                          Nov + 
> > > > > d                                          Dec ') 
> > > > > dmonthshort                      4a   dim(12) 
> > overlay(monthsshort)
> > > > > d                 ds 
> > > > > d year4                   1      4  0 
> > > > > d year2a                         2a   overlay(year4:3) 
> > > > > 
> > //---------------------------------------------------------------
> > > > >  // Standalones & Constants
> > > > > 
> > //---------------------------------------------------------------
> > > > > d book            s                   like(HSSFWorkbook) 
> > > > > d spreadsheet     s                   like(HSSFSheet) 
> > > > > d enddate         s               d 
> > > > > d endday          s              2p 0 
> > > > > d dayname2        s              6a   varying 
> > > > > d attachment      s             50a 
> > > > >  
> //------------------------------------------------------------
> > > > >  // Mainline
> > > > >  
> //------------------------------------------------------------
> > > > >  /free 
> > > > >   enddate = %date() - %days(1); 
> > > > >   endday = %subdt(enddate:*days); 
> > > > >   year4 = %subdt(enddate:*years); 
> > > > >   hssf_begin_object_group(100); 
> > > > >   attachment = '/home/scessna/excel/' + 
> > > > >                %trim(monthshort(%subdt(enddate:*months))) + 
> > > > >                %trim(year2a) + 'DailyLaborHours2.xls'; 
> > > > >   dayname2 = 
> %trim(monthshort(%subdt(enddate:*months))) + ' ' +
> > > > >              %char(endday); 
> > > > >   monitor; 
> > > > >     book = hssf_open(%trim(attachment));    <-- this never 
> > > > gets found &
> > > > > jumps to the on-error
> > > > >     monitor; 
> > > > >       spreadsheet = hssf_getSheet(book:%trim(dayname2)); 
> > > > >       if spreadsheet = *null; 
> > > > >         spreadsheet = HSSF_newSheet(book:%trim(dayname2));
> > > > >       endif; 
> > > > >     on-error; 
> > > > >       spreadsheet = HSSF_newSheet(book:%trim(dayname2)); 
> > > > >     endmon; 
> > > > >   on-error; 
> > > > >     book = new_HSSFWorkbook();
> > > > <-- here is
> > > > > where it jumps to...
> > > > >     spreadsheet = HSSF_newSheet(book:%trim(dayname2)); 
> > > > >   endmon; 
> > > > >   HSSF_save(book:%trim(attachment)); 
> > > > >   hssf_end_object_group(); 
> > > > >   *inlr = *on;
> > > > >  /end-free
> > > > > 
> > > > > if you guys can find anything wrong with my code, 
> please let me 
> > > > > know...thanks again...
> > > > > 
> > > > > Shane
> > > > > 
> > > > > 
> > > > > Hi,
> > > > > 
> > > > > here is what I do in a CL before I call the RPGLE 
> (with Jakarta
> > > > > POI):
> > > > > 
> > > > > CHGCURDIR  DIR('/jakartapoi')
> > > > > ADDENVVAR  ENVVAR(CLASSPATH) +
> > > > > VALUE('.:/jakartapoi:/jakartapoi/jakartapoi151.jar') + 
> > > > >              REPLACE(*YES)
> > > > > 
> > > > > Regards,
> > > > > Magne
> > > > > 
> > > > > 
> > > > > Date: Wed, 25 May 2005 10:55:39 -0500
> > > > > From: Shane_Cessna@xxxxxxx Add To Address Book
> > > > > Subject: RE: Jakarta POI HSSF question... 
> > > > > To: Java Programming on and around the iSeries / AS400 
> > > > > <java400-l@xxxxxxxxxxxx>
> > > > > 
> > > > > 
> > > > > 
> > > > > Michael,
> > > > > 
> > > > > Where can I find this CLASSPATH parameter?...
> > > > > 
> > > > > Shane Cessna
> > > > > iSeries Programmer
> > > > > iSeries WAS Administrator
> > > > > North American Lighting, Inc.
> > > > > (618) 662-4483 x2776
> > > > > shane_cessna@xxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.