Re: Cloudscape / Apache Derby

["Patrick Archibald" <patrick.archibald@xxxxxxxxx>]

Aaron

I created a quick report. The last run had 29 tables with 987539 rows.
The complete replication completed in 11 minutes 17 seconds 375
milliseconds.  I don't have a "changes only" update working yet. It is
a work-in-progress. Overall I'm very pleased with Derby. The only two
SQL syntax changes I had to make were using RTRIM instead of TRIM and
stop using EXCEPTION JOIN and use WHERE NOT EXISTS instead.

Using derby database Thu May 18 13:26:52 EDT 2006
-TABLE- -ROWS-
SOMPFLM000 31815
SOMPFLM010 31815
SOMPFLM020 31815
TPSPFM20 145733
SOMPFLM070 251761
TPSPFM21 70
SOMPFLM071 1830
SOMPFLM072 11842
CMRPFLM000 33133
CMRPFLM200 2323
ADSPFM04 6771
SOMPFLM030 31817
SOMPFLM040 31817
SOMPFLM075 95
EQAPFM05 62
SOMPFLM012 13
TPSPFM26 958
PFAPFLM050 106670
GPLPFM04 201
TPSPFM23 226505
TPSPFM16 6689
TPSPFM41 331
SOMPFM70 725
SOMPFLM022 31818
GPLPFA05 460
SOMPFM87 48
SOMPFM22B 2
SOMPFM86 420
SOMPFA40 0


29 tables with 987539 rows


Driver name: Apache Derby Embedded JDBC Driver
Driver version: 10.1.1.0
Database product name: Apache Derby
Database product version: 10.1.1.0

Thanx, PLA


On 5/18/06, albartell <albartell@xxxxxxxxx> wrote:
> Interesting concept.  Then I am assuming they go through a "syncing" process
> once back in the office?
>
> How much of the data in the tables do you bring down onto their laptops?
>
> Aaron Bartell
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Patrick Archibald
> Sent: Tuesday, May 16, 2006 3:12 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: Cloudscape / Apache Derby
>
> Hi Aaron
>
> I use Derby in a Java Swing/Webstart GUI program. I replicate some iSeries
> DB2 tables to Derby. The user can then take his laptop and access the data
> without a network connection. Let me know if you want more information.
>
> Thanx, PLA
>
> On 5/16/06, albartell <albartell@xxxxxxxxx> wrote:
> > I just got this webcast invite in the mail to inform the masses about
> > Cloudscape/ Apache Derby.
> >
> > http://www-304.ibm.com/jct09002c/isv/news/email/Cloudscape_wc_5-24_nal
> > a.html
> >
> > >From what I have heard Apache Derby is an "embeddable" java database.
> > >I can
> > see it being useful for configuring websites where I would
> > traditionally use *.properties files.
> >
> > My Question: Is anybody using Derby/Cloudscape?  If so what is your
> > particular use?
> >
> > Aaron Bartell
> > http://mowyourlawn.com/blog
> > --
> > 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.
>
> --
> 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.