Java DB Reference

Join the Derby Users Discussion Forum

Apache Derby has an active community of users and developers who provide advice and respond to questions by new and experienced users.

Join derby-user@db.apache.org to post questions and see what others are asking. You can also browse the mailing list archive.

For more information, see Apache Derby: Mailing Lists.

Tutorials, Tips and Tuning

Getting Started

• Apache Derby Tutorial
  Step-by-step instructions for installing Derby, using the ij tool and creating a simple application for both the embedded and network client drivers.

• Getting Started with Derby by Stephen B. Morris
  This thorough introduction 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.

• Tutorial: Java databasing with Derby, Java's own open source database by Pan Pantziarka, Reg Developer
  This short tutorial presents installation, command line access and use of Derby as an embedded database within a Java application.

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

• JDBC 4.0 Enhancements in Java SE 6 by Srini Penchikala
  Information on using Apache Derby (Java DB) and JDBC 4.0 in Java SE 6.

Back to top

Features, Hints and Tips

• Hints, Tips and Useful Information from Derby Users
  An amalgamation of useful information about using and working with Derby from the Apache Derby wiki.

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

• LDAP Authentication with Apache Derby (Java DB) by John Yeary
  A short, simple tutorial on how to use Apache Derby and LDAP.

Back to top

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.

Back to top

Tools and Migration

Tools

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

• Working with the Java DB (Derby) Database in NetBeans 5.5 by Brian Leonard, NetBeans Evangelist, Sun Microsystems, NetBeans.org
  This document demonstrates how to quickly set up a connection to Sun'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.

• Journal 8: Database Connectivity, Part 1: Working with Java DB (Derby) (and Java Studio Creator) by Walter Hardy, W. Hardy Interactive, Inc., Web Developer
  A practical guide to developing a database application using Java Studio Creator IDE and Java DB.

• 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 Java DB.

Back to top

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.

Back to top

Applications

Client

• Synchronizing a Web Client Database: LocalCalendar and Google Calendar by David Van Couvering, NetBeans Architect, aka, the NetBeans Database Guy, Sun Microsystems, Java.net
  Use Java DB for the local storage component of a Rich Internet Applications and synchronize its data with a centralized data store running behind the web server. Sample code is provided.

• Further Steps with Derby: Derby Embedded in a Browser by Stephen B. Morris

• 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 Java DB, based on the Apache Derby database, within desktop Java applications. The article uses the Address Book demo to show you how to work with Java DB as an embedded database.

Back to top

Middle Tier

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

• Using Apache Derby with iBATIS JPetStore 4 running on the Geronimo J2EE server
  Shows how easy it is to set up and deploy a J2EE application that uses a Derby database (the iBATIS JPetStore 4.0 web-based sales application) on the Geronimo J2EE server.

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

• Build Web applications with Eclipse, WTP, and Derby by Susan L. Cline
  This article discusses some of the functionality provided by the Eclipse Web Tools Platform, the Derby database plug-ins, and a complete sample application that uses JSPs, JavaServer Pages Standard Tag Library (JSTL), and Servlets. The sample application is a fictitious and simplified airline flight reservation system.

• Implementing Java DB as an Embedded Cache to Support Service by Jason Baragry, Sun Client Solutions Engineer in Oslo, Norway
  Describes how Java DB 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.

Back to top

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.

Back to top

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 Java DB/ 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.

Back to top