Example Programs

# Example Apache Derby Programs

This directory contains example programs. For a complete description, see Getting Started with Apache Derby, the Apache Derby Server and Administration Guide and Working With Derby .

- Simple

  A very simple JDBC application that boots the driver, creates a database, and loads some data.

- Network Server Sample Programs

  Two examples are provided to demonstrate how to obtain an embedded connection and client connections using the Network Server to connect to the same database. An embedded connection is a connection to a database that is booted in the same JVM as the application. Client applications that require a database connection across the network use the network server protocol (DRDA) to connect to the Network Server. This type of connection is referred to as a client connection.

- ToursDB sample database schema

  The toursdb is provided as an example and demo database to illustrate some functionality of the Derby RDBMS. Many of the examples in the Derby documentation use tables that exist in the toursdb database. The document describes the tables, the names and types of columns in those tables, and the constraints, indexes, and triggers in the database.

- Working With Derby

  Programs described and modified as part of the activities documented in the Working With Derby manual.