Re: RPG calling JAVA performance

Guiseppe,

thanks for the info.

Maybe I'll have a try at modifying your java program, so that it reads the 
CSV instead of executing the SQL.

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Real developers never document.  If it was hard to write, it should be 
hard to understand.
-----




"Beppe Costagliola" <beppecosta@xxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
22/11/2004 14:52
Please respond to RPG programming on the AS400 / iSeries

 
        To:     "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: RPG calling JAVA performance


Peter,

I didn't succeed in calling JexelApi from RPG.

In Rpg before calling the Workbook.createWorkbook(...)
we must call the *contructor for Workbook to get an instance of Workbook.

wb = Workbook();

and then we can invoke the method and get the WritableWorkbook

wwb = createWorkbook(wb.outFile);

Then if we want to use it with Rpg I think that the class should be:

public class jxl.Workbook extends java.lang.Object {
public jxl.Workbook();

because with:

public abstract class jxl.Workbook extends java.lang.Object {
protected jxl.Workbook();

when we invoke the *contructor from Jni it can't be found

But this does not mean that it can't be done. I dind't succeed . . .
If you do, let us know.

Giuseppe.

From: <Peter.Colpaert@xxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, November 22, 2004 2:23 PM
Subject: Re: RPG calling JAVA performance


> Giuseppe,
>
> This apparently only works if the TO file for CPYFRMIMPF already exists,
> which is not the case: we don't know in advance how may fields will be 
in
> the CSV, nor which data type they will be.
>
> My current version supports this, but when the record count goes over
> 1.000, it takes ages to generate.
>
> Have you tried calling JExcelApi from RPG and compared the performance 
to
> POI?
>
> Even if it goes only twice as fast, we could double the record count
> without suffering performance loss.
>
> Thanks,
>
> Peter Colpaert
> Application Developer
> Massive - Kontich, Belgium
> -----
> Real developers never document.  If it was hard to write, it should be
> hard to understand.
> -----
>
>
>
>
> "Beppe Costagliola" <beppecosta@xxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 22/11/2004 14:12
> Please respond to RPG programming on the AS400 / iSeries
>
>
>         To:     "RPG programming on the AS400 / iSeries"
<rpg400-l@xxxxxxxxxxxx>
>         cc:
>         Subject:        Re: RPG calling JAVA performance
>
>
> Peter,
>
> you can upload the CSV into a table (CPYFRMIMPF) and then generate the 
XLS
> from it.
>
> Giuseppe.
>
> ----- Original Message ----- 
> From: <Peter.Colpaert@xxxxxxxxxx>
> To: <rpg400-l@xxxxxxxxxxxx>
> Sent: Monday, November 22, 2004 1:33 PM
> Subject: Re: RPG calling JAVA performance
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.