Derby database path

The appplication accesses the database via the network client driver. The JDBC url to the database is jdbc:derby://localhost/zeprs;create=true. Note that the path to the database is a full system path. This is important, because you don't want the path hard-coded to the db to allow flexability in development - you may be developing multiple instances of the db.

The path to the database is set in DerbyDatabase class' initialise method, which is used to boot the Derby network server:

String derbyHome = Constants.pathToCatalinaHome + Constants.pathSep + "databases" + Constants.pathSep;

System.setProperty("derby.system.home",derbyHome);

The pathToCatalinaHome is from the catalina.home variable, which is set when the application starts.