Derby is a full featured, open source relational database engine.
It is written and implemented completely in Java, and provides users with a
small footprint standards-based database engine that can be tightly embedded
into any Java based solution. Derby ensures data integrity and provides sophisticated
transaction support. In its default configuration there is no separate
database server to be installed or maintained by the end user. For more information
on Derby visit the Derby website at:
Performing the Working With Derby activities requires no prior knowledge of Java, JDBC or SQL. Each Activity Sequence section provides the complete command syntax needed to execute each operation on a Windows machine or in a UNIX/Linux Korn shell. This document demonstrates, but does not teach, the Java, JDBC and SQL presented, so readers wishing a deeper understanding of these topics will need additional reference materials.
Performing the Working With Derby activities does require that Java and Derby software be installed on the computer, and the ability to enter computer operating system commands. Specifically:
If unsure about the Java or Derby environments installed, perform the following steps before attempting the subsequent activities: