RE: poi issues -- MIDRANGE-L

Thanks Nathan,

We've also got Costaglioli's SQL2CSV for creating csv files.  We
actually needed the XLS specifically, because it also lets us use a
template excel file to put headers and define column widths and what-not
on our output.

The good news is I found the problem.  It was the authority to the
/excel directory which contained the /poi-2.0.jar file.

Greg

|-----Original Message-----
|From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
|bounces@xxxxxxxxxxxx] On Behalf Of Nathan Andelin
|Sent: Friday, September 01, 2006 11:59 AM
|To: Midrange Systems Technical Discussion
|Subject: Re: poi issues
|
|Greg,
|
|I don't know what's causing the java exception, but I wrote a command
|called sql2stmf - SQL to Stream File, and it will create CSV stream
files
|from SQL Select statements for Excel.  It doesn't use POI.  It runs
|natively.  If you'd like to try it, and send me a private email, I'll
send
|you the *SAVF.
|
|
|Nathan M. Andelin
|www.relational-data.com
|
|
|
|----- Original Message ----
|From: "Fleming, Greg (ED)" <GFLEMING@xxxxxxxxxxxxxxxxxxxx>
|To: midrange-L@xxxxxxxxxxxx
|Sent: Friday, September 1, 2006 9:15:23 AM
|Subject: poi issues
|
|We use Beppe Costagliola's SQL2XLS program, which in turn uses the
|Jakarta POI API's to create Excel files in the IFS.
|
|Typically, we have submitted jobs which call the SQL2XLSR program,
|passing the SQL string and other parms, with good results, but until
now
|the jobs have always been sumbitted from a user profile which has
fairly
|high authority.
|
|We implemented an application yesterday which allows our users to
choose
|an option on a screen which submits a job to handle this function, and
|it returns the following error:
|
|RPG procedure SQL2XLSR in program GNMPPGM/SQL2XLSR
|
|received Java exception "java.lang.NoClassDefFoundError:
|
|
|org/apache/poi/hssf/usermodel/HSSFWorkbook" when calling method
"<init>"
|
|
|with signature "()V" in class
|"org.apache.poi.hssf.usermodel.HSSFWorkbook".
|
|I have seen this error before, when we were using the SQL2XLS program
|interactively, because there was an indentically named method used by
|our order entry application which of course had a different signature,
|and this caused a conflict.  Since this is happening now in a submitted
|job, I don't think this conflict could be the problem.
|
|Upon googling the error, I found some discussion on the MCPress site
|where Beppe tells some people that it was caused by having the wrong
|version of the POI, but this seems to be applicable to situations where
|the thing won't work at all on the system.
|
|My inclination is to believe this is an authority issue, but the
|question is, authority to what ?  I've checked and opened wide the
|authorities to the IFS directories and files being used by the
|application, and even opened up the authorities on the poi-2.5.jar
file,
|to no avail.
|
|Anyone have any other ideas ?
|
|Thanks
|
|Greg Fleming
|
|Senior Programmer/Analyst
|
|Everglades Direct, Inc.
|
|
|
|--
|This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
|To post a message email: MIDRANGE-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit: http://lists.midrange.com/mailman/listinfo/midrange-l
|or email: MIDRANGE-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at http://archive.midrange.com/midrange-l.
|
|
|
|
|
|--
|This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
|To post a message email: MIDRANGE-L@xxxxxxxxxxxx
|To subscribe, unsubscribe, or change list options,
|visit: http://lists.midrange.com/mailman/listinfo/midrange-l
|or email: MIDRANGE-L-request@xxxxxxxxxxxx
|Before posting, please take a moment to review the archives
|at http://archive.midrange.com/midrange-l.