Tutorial : Apache Derby Tutorial

Overview:
Apache Derby, an Apache DB subproject, is a relational database implemented in Java. Its footprint is so small you can easily embed it in any Java-based solution. In addition to its embedded framework, Derby supports a more familiar client/server framework with the Derby Network Server. This tutorial introduces Derby's basic features and walks you through using both frameworks; first the embedded framework using the Derby Embedded JDBC driver, then the Network Server framework using the Derby Network Client JDBC driver.

Intended Audience:
This tutorial is intended for new Derby users who have had at least light exposure to SQL, Java, and JDBC.

Tutorial Topics:
This tutorial is organized into the sections below:

1. Install Software shows how to:

   • Install the Apache Derby software.

   • Configure your environment to use the Derby Embedded JDBC driver.

   • Verify your installation with the sysinfo tool.

2. ij Basics shows how to use the ij tool with the embedded Derby JDBC driver to create a database and execute SQL queries.

3. Embedded Derby shows how to compile and run a simple Java application that uses the Derby Embedded JDBC driver.

4. Derby Network Server show how to:

   • Start the Derby Network Server.

   • Configure your environment to use the Derby Network Client JDBC driver.

   • Compile and run a simple Java application that uses the network server.

[Read More..]

Courtesy:- Db.apache.org