Derby embedded basics

This section explains how to use and configure Derby in an embedded environment.

If you installed the Demos and Samples for the JDK, you can run the sample application program $JAVA_HOME/demo/db/programs/simple, which illustrates how to run Derby embedded in the calling program. See "Installing Java DB" in Getting Started with Java DB for details on installing the sample programs.

• Derby JDBC driver
  Derby consists of both the database engine and an embedded JDBC driver. Applications use JDBC to interact with a database. Applications running on JDK 5 must load the driver in order to work with the database.
• Derby JDBC database connection URL
  A Java application using the JDBC API establishes a connection to a database by obtaining a Connection object.
• Derby system
  A Derby database exists within a system.
• A Derby database
  A Derby database contains dictionary objects such as tables, columns, indexes, and jar files. A Derby database can also store its own configuration information.
• Connecting to databases
  You connect to a database using a form of the Derby connection URL as an argument to the DriverManager.getConnection call.
• Working with the database connection URL attributes
  You specify attributes on the Derby connection URL.