Unit testing the persistence logic

In this section, we'll build a Phonebook application and store phone numbers. We'll use the Apache Derby database for persistence. Derby can be downloaded from http://db.apache.org/derby/.

You can use better built-in databases such as H2. It has more features and is less restrictive than Derby; however, we're using Derby for simplicity.

The following are the steps to run Derby:

1. Download the binary media file and extract the media to a preferred location. We'll refer to it as DERBY_HOME in the next steps.

2. On a Windows machine, go to DERBY_HOME\bin and execute the startNetworkServer.bat file.

3. It will launch a command prompt and print a message to the console that the database server has started, such as started and ready to accept connections on port 1527.

We will create a Java project to test the Phonebook application. Follow the ensuing steps to build the application:

1. Launch Eclipse and create a Java project named DatabaseAccess.

2. Add a PhoneEntry class to store...