RE: poi issues

Peter,

Sounds cool.  I'll check it out.

Greg

|-----Original Message-----
|From: midrange-l-bounces+gfleming=evergladesdirect.com@xxxxxxxxxxxx
|[mailto:midrange-l-bounces+gfleming=evergladesdirect.com@xxxxxxxxxxxx]
On
|Behalf Of Peter Dow (ML)
|Sent: Friday, September 01, 2006 12:33 PM
|To: Midrange Systems Technical Discussion
|Subject: Re: poi issues
|
|Hi Greg,
|
|You might want to try Beppe's SQL2JXL - it's a lot faster than his
|SQL2XLS.  I tried both with the same SQL SELECT stmt and SQLXLS took 45
|minutes while SQLJXL took 2 minutes.  I also tweaked his program to
|handle more than 65535 rows -- when it reaches 65530 rows, it starts a
|new worksheet.  IBM's Client Access Excel add-in does this, and it
|seemed like a reasonable solution (the test I referred to had 80,000+
|rows).
|
|*Peter Dow* /
|Dow Software Services, Inc.
|909 793-9050
|pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /
|
|Fleming, Greg (ED) wrote:
|> 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.
|>
|>
|>
|
|--
|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.