- Derby: A Database for All Seasons
- What Is Derby?
- How to Use Derby
- Setting Up Your CLASSPATH
- Testing Your Setup
- Running Your First Derby Program
- Derby Application Components
- Derby Application Startup
- Loading the Derby Driver
- Database and Connection Creation
- Statement Creation
- Table Creation
- Table Access
- Running the Code
Testing Your Setup
The Derby distribution includes a handy tool to verify that your CLASSPATH is correctly configured. This command is the following:
java org.apache.derby.tools.sysinfo -cp embedded SimpleApp.class
If your setup is in order, you should see something like the program output in Listing 1.
Listing 1 All’s well with your Derby setup
FOUND IN CLASS PATH: Derby embedded engine library (derby.jar) user-specified class (SimpleApp) SUCCESS: All Derby related classes found in class path.
If your setup is incomplete, you might see something like Listing 2:
Listing 2 Problems, problems
FOUND IN CLASS PATH: Derby embedded engine library (derby.jar) NOT FOUND IN CLASS PATH: user-specified class (SimpleApp) (SimpleApp not found.)
Hopefully, your installation is properly configured, and you’re now ready to run the example application.