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

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
> > 
> > --
> > This is the Java Programming on and around the iSeries / AS400 
> > (JAVA400-L) mailing list To post a message email:
> > JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list 
> > options,
> > visit: http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, 
> please take a 
> > moment to review the archives at 
> > http://archive.midrange.com/java400-l.
> > 
> > 
> > 
> 
> --
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, 
> please take a moment to review the archives at 
> http://archive.midrange.com/java400-l.
> 
> 
>

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.