Blogs and articles about Derby
Here we collect articles about Derby. Please also check the Derby Wiki for smaller write-ups.
There are many older Derby articles at IBM developer works that may be of interest here
Note: Some articles use the term "Java DB". Java DB is essentially the same as Derby: it is the bits distributed by Oracle as part of the Java Development Kit (JDK) based on the Derby bits.
Note: Some articles use the term "Cloudscape". Cloudscape is the product name used by IBM before Derby was open sourced.
There is also the now somewhat dated book "Apache Derby - Off to the Races"
Articles grouped by topic, newest listed first
Tutorials, Tips and Tuning
Getting Started
(See also the Derby Tutorial).
Getting Started with Apache Derby (Java DB) (by Stuart Ellis) - including how to use Derby with JRuby on Rails
Flying out of the gate with Derby (by Sing Li)
Derby is a 100%
Java open source relational database, and you can't afford to
ignore it. Learn why in this article.
Apache Derby Database - Tutorial (by Lars Vogel) This articles explains how to install the Apache Derby database, how to start the Derby server, how to connect via Java to Derby and how to use the Derby command line tool to issue SQL statements. The installation of Apache Derby as Windows Service is also explained.
Getting Started with Derby
(by Stephen
B. Morris)
This thorough introduction to Derby addresses
installation, environment set up, building and executing an
application with Derby embedded.
Using Derby as a Network Database Server Engine
(by
Stephen B. Morris
Need a network database server that can
handle multiple remote clients? There's no longer a need to
spend megabucks. Stephen Morris explains how Derby can serve the
needs of many remote clients via an open-source RDBMS.
Further Steps with Derby: Defining and Accessing Your Data
(by Stephen
B. Morris)
Do you need a simple database as part of an
application upgrade? Derby is easy to use and program and
combines high performance with a modest footprint. Stephen
Morris tells you why database development is no longer the sole
preserve of DBAs or data center IT people.
Java databasing with Derby - Java's own open source database(by Pan Pantziarka/the Register )
Features, Hints and Tips
Introducing Java DB 10.5.1.1 (by Rick Hillegas)
Java DB Table Functions (Download Code and White Paper) (by Rick Hillegas)
This white paper explores table functions, a feature introduced in
Derby release 10.4.1.3.
Rich and expressive, SQL is the world's most popular database
query language. Table functions let you take SQL outside its
traditional home in the RDBMS, setting SQL loose on data in the
wild.
LDAP Authentication with Apache Derby (Java DB)
(by John Yeary)
A short, simple tutorial on how to use Apache Derby and LDAP.
Security
Protect Your Apache Derby Database from Superuser Attacks (by Marios Karagiannopoulos)
Java DB Security (by Rick Hillegas) Derby provides several ways to protect the correctness and privacy of your data as well as forestall accidental or malicious misuse of the database software itself. This white paper explains how to improve the database security of applications and machines which use Derby.
Performance and Tuning
Tuning Derby
(by Dejan
Bosanac, Software developer, technology consultant and
author, ONJava.net)
There is a big difference in the behavior of a database when
it is populated with a small amount of test inputs and when
it holds a large amount of data. Usually, you would not
address these database performance issues early in the
development process, but when the time comes, you should
take some action to ensure that the application is working
correctly with large amounts of data.
Tools and Migration
Tools
Working with the Java DB (Derby) Database [in NetBeans] (by the Netbeans team) This document demonstrates how to quickly set up a connection to Oracle's Java DB (which is based on the Apache Derby database) in NetBeans. Once a connection is made, you can easily begin working with the database in the NetBeans IDE, allowing you to create tables, populate them with data, run SQL queries, and more.
Using SQuirreL SQL Client with Derby
SQuirreL SQL Client is a useful tool for browsing and
manipulating SQL databases via JDBC. This paper discusses
setting up SQuirreL to access Derby databases via the Derby
Embedded Driver and Client Drivers with the 10.1 version of
Derby.
Back to basics: Scripting Apache Derby's ij tool
Migration
Using DdlUtils to Migrate Databases to Derby
DdlUtils, an
Apache DB subproject, provides utilities for creating and
working with Database Definition (DDL) files and for
exporting and importing data in XML format. Among other
uses, DdlUtils makes it easier to migrate from one database
vendor to another. This paper provides a simple example for
using DdlUtils to migrate a database to Derby using
the DdlUtils
Ant tasks.
Applications
Client
Further Steps with Derby: Derby Embedded in a Browser (by Stephen B. Morris)
Offline Ajax with Apache Derby (by Michael Galpin)
Using Java DB in Desktop Applications (by John O'Connor, Java
Technology evangelist, engineer, and writer at Sun
Microsystems)
Learn how to deploy Derby, based on the Apache Derby database,
within desktop Java applications. The article uses the Address
Book demo to show you how to work with Derby as an embedded
database.
Middle Tier
Getting Started with the Apache Derby Open Source Database in CF8 (Cold Fusion) (by ColdFusion troubleshooter Charlie Arehart)
An Experiment In Using An Embedded Apache Derby Database To Power ColdFusion Query-Of-Queries (by Ben Nadel)
"Using Apache Derby" (with Cold Fusion), watch my Max presentation
Working with the embedded Derby database for WebSphere Portal (by Cody Burleson)
Using Apache Derby with iBATIS JPetStore 4 on the WebSphere
Server
This document demonstrates setting up the JPetStore 4.0
application to run on a J2EE Application Server using an
embedded Apache Derby database as the persistence layer. Apache
Derby is a small footprint, open source, relational database
engine written in Java. It is ideally suited for use with J2EE
and Web applications where reliability, portability, ease of use
and low maintenance is important.
Embedding Apache Derby in Tomcat and creating an iBATIS JPetStore
Demo
Shows the steps required to embed Derby in a Tomcat version
5.5.12 Server and then deploy a copy of the iBATIS JPetStore
application that utilizes a Derby database.
Installing Apache Derby Database on ColdFusionMX 7.0.2
Instructions for installing and configuring Derby for use on
ColdFusionMX. Conclusion: "All in all, it was very easy to
get Apache Derby to work with ColdFusionMX. ... I'm quite sure
I'll be using much more of Derby in the projects I work
on."
Apache Derby and Red Hat Application Server: JonAS Integration
(by Ramandeep Kaur)
This document provides details on how to configure and run
Apache Derby with Red Hat Application Server.
Persistence
Using JPOX JDO with Derby
Provides a concrete example of using JPOX JDO to persist and
retrieve data to and from Apache Derby. Java Data Objects (JDO)
is a specification for persisting Java objects.
Running the Torque Tutorial on Derby
This page summarizes the changes required to run the Torque 3.2
tutorial on Derby 10.1 using the Derby embedded JDBC driver.
HibernateHelp
This wiki page documents various peoples' experience using
Hibernate with Derby.
Scalability and Failover
HOWTO use C-JDBC with Apache Derby (by Emmanuel Cecche)
How to use Derby with C-JDBC,an open source database cluster
middleware that allows any Java application to transparently
access a cluster of databases through JDBC.
Last Updated: October 14, 2017