Your copy of the product comes with a Northwind Derby database.
If you are using the Jetty package, it's pre-configured and ready to be used.
But what if you'd like to use that database in your own environment for training purposes?
This page explains how to configure your server to have easy access to the Northwind Derby database.
Note: this will only work properly in a single-server environment. If you use a cluster (more than one server), this procedure will not work properly. You cannot use a Derby database in a cluster.
Step 1: Copy the database file(s) to a location accessible by your server (if it's a zip file, you'll need to unzip it)
Step 2: In order to make connection easy, we recommend that you modify your server configuration to include the following Java variable:
So if your Northwind database directory is at
then you'll define this variable as:
If you use Apache Tomcat, this would go into the script you use to start up Tomcat (perhaps in environment variable
This will then allow you to connect to any Derby database in that directory by simply specifying its directory name (Northwind in this case).