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. 3.7, 3.8, 3.9, or 9.9 upgrade: Go to the old_Software AG_directory/Presto/apache-tomee-jaxrs/bin directory and copy the prestorepository and mashzonerepository directories to the new_Software AG_directory/MashZoneNG/apache-tomcat/bin directory. Rename the prestorepository directory to mashzonenextgenrepository in the new installation.
3. 9.10 and higher upgrade: 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.
4. 3.6 upgrade: Go to the old_Software AG_directory/Presto/prestorepository/derby directory and copy the prestorepository directory to the new_Software AG_directory/MashZoneNG/apache-tomcat/bin directory. Rename the prestorepository directory to mashzonenextgenrepository in the new installation.
5. Execute Derby database update SQL commands for 10.1. 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;
Contact Support
|
Community
|
Feedback