Set Up Repository When Using the Embedded Derby Database
If you used the embedded Derby database for your old repository, follow the instructions below.
1. The new MashZone NextGen comes with a pre-populated Derby repository. Go to the new_Software AG_directory/MashZoneNG/apache-tomcat/bin and rename the mashzonenextgenrepository directory (for example, rename the directory mashzonenextgenrepository_orig).
2. Upgrade from 9.10 or 9.12: Go to the old_Software AG_directory/MashZoneNG/apache-tomee-jaxrs/bin directory and copy the mashzonenextgenrepository and mashzonerepository directories to the new_Software AG_directory /MashZoneNG/apache-tomcat/bin directory.
3. Execute Derby database update SQL commands for the new release. You can execute these commands using any SQL client that can connect to Derby, or you can use the Derby IJ utility delivered with MashZone NextGen, as follows:
a. Open a command window and change to the directory where the Derby database resides (for example, cd new_Software AG_directory/MashZoneNG/apache-tomcat/bin).
b. Start the IJ utility by running this command:
java -jar SAG_HOME/MashZoneNG/prestorepository/derby/lib/derbyrun.jar ij
c. Connect to the embedded Derby database by running this command:
connect 'jdbc:derby:mashzonenextgenrepository';
d. Run the file using the RUN command. For example:
RUN 'new_Software AG_directory/MashZoneNG/upgrade/10.1/MIGRATE-quartz2-DERBY.sql';
e. Exit the IJ utility by running the command EXIT;