O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Features

Database Structure

An Apache Derby database contains objects such as tables, columns, indexes, and .JAR files. An Apache Derby database can also store its own configuration information.

An Apache Derby database is stored in files that live in a directory with the same name as the database (that is, the SAMPLE database is found in the SAMPLE directory). Database directories typically live in system directories.

Creating an Apache Derby Database

There is no CREATE DATABASE command within the Apache Derby environment. Instead, databases are created and accessed via the Apache Derby connection URL. The create=true option can be added to the connect statement to create the database.

Database Names

Database names within Apache Derby ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required