Apache Derby Configuration

1. If you are running Derby as a Network Server, configure and start the server.
2. Edit the WEB-INF/sql/DERBY/calschema.sql. Place The connect command for your server at the top. For example:
   
   connect 'jdbc:derby://localhost:1527/calendardb;create=true';
3. Using the ij tool, run the WEB-INF/sql/DERBY/calschema.sql script.
4. Edit configuration.properties. If you are running Derby as a networked server, add this information to the bottom of the WEB-INF/configuration.properties file:
   
   JDBCDriver=org.apache.derby.jdbc.ClientDriver
   JDBCConnectString=jdbc\:derby\://localhost:1527/calendardb
   DBObjectClass=com.MHSoftware.db.support.DerbyDB
   JDBCPassword=APP
   JDBCUserID=APP
   
   If the Derby database is on a different machine, replace localhost with the hostname for the remote database server.
   
   If you're running DERBY as an embedded database, add this to the WEB-INF/configuration.properties
   
   JDBCDriver=org.apache.derby.jdbc.EmbeddedDriver
   JDBCConnectString=jdbc\:derby\:calendardb
   DBObjectClass=com.MHSoftware.db.support.DerbyDB
   JDBCPassword=APP
   JDBCUserID=APP

Note
In order for database side event filtering to work, you'll need to copy the WEB-INF/lib/MHS.jar file into the Derby LIB directory and edit the appropriate startup scripts to load the JAR file.