Font size:

Blogs and articles about Derby

Blogs
Articles grouped by topic, newest listed first

Here we collect blogs and 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"

Blogs

Knut Hatlen's blogThis often contains news about the latest releases with examples of the new features.

Lance Andersen's blog Java EE and JDBC related issues.

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

Derby 10.8 is out A feature summary (by Knut Hatlen)
What's new in Derby 10.7? (by Knut Hatlen)
Derby 10.6.2 is out (by Knut Hatlen)
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.

Java DB End-to-End Security (by Masoud Kalali)
Derby, as an open source and pure-Java relational database, provides several features that make it suitable for embedded and network server modes, including Derby mechanisms to make it secure on several levels. If you are going to build an application using Derby and security is important, then this article is for you.

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

MyEclipse Derby Database Server Tutorial

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.

Using Java DB with Java Studio Creator and Tomcat (by David Botterill, Java Tools (Java Studio Creator and NetBeans) Evangelist, Sun Microsystems)
In this blog David Botterill helps you set up the Travel sample database of Java Studio Creator 2 on Tomcat using 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)

Synchronizing a Web Client Database: LocalCalendar and Google Calendar (by David van Couvering)

Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse (by Noel Rappin)

Real-world Apache Derby: Who needs Ajax, anyway?
Real-world Apache Derby, Part 1: Apache Derby and OpenOffice.org Calc
Real-world Apache Derby, Part 3: Portable document storage

Cloudscape and Ajax - An example
This article explains all the steps and requirements to create an embedded database and Web server application. The source code and a ready to run application provided as a zip file are available for download.

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 databases, Part 1: Managed objects in a converged provider environment
Using Apache Derby databases, Part 2: Manage IT services beyond mere deployment
(by Stephen Morris) Automating IT management with IBM AIDE and Derby

Apache Derby resources from the Web services perspective, Part 1: Derby data as WS-Resources
Apache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with Derby
Apache Derby resources from the Web services perspective, Part 3: Manage Apache Derby using Web Services Distributed Management

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."

Implementing Java DB as an Embedded Cache to Support Service (by Jason Baragry, Sun Client Solutions Engineer in Oslo, Norway)
Describes how Derby can be used as an embedded database to act as a cache for services deployed in the Sun Java System Application Server.

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

Sequoia Database Clustering Middleware with GlassFish and Java DB (Apache Derby) (by Jagadish Ramu, Glassful engineer)
This demo and tutorial show how GlassFish and Sequoia can be used together to provide clustering capability with Apache Derby. Sequoia is an open source database clustering middleware that allows any Java application to transparently access a cluster of databases through JDBC.

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: August 20, 2011