MIDRANGE dot COM Mailing List Archive



Home » JAVA400-L » May 2006

Re: Cloudscape / Apache Derby



fixed

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.








Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact