Set Up Repository When Using Any Other Database

Complete Installation and Upgrade Information for Software AG Products : Upgrading Software AG Products : Migrate MashZone NextGen : Migrate MashZone NextGen : Set Up the MashZone NextGen Repository : Set Up Repository When Using Any Other Database

If you used MySQL, Oracle, PostGres, or SQL Server for your old repository, follow the instructions below.

1. Go to the old_Software AG_directory/{Presto|MashZoneNG}/apache-tomee-jaxrs/lib directory and copy the JDBC driver jar file for your database to the new_Software AG_directory/MashZoneNG/apache-tomcat/lib directory.

Database	JDBC Driver Jar File
MySQL	mysql-connector-java-5.1.31.jar
Oracle	ojdbc6.jar
PostGres	postgresql-9.2.1004.jdbc4.jar
SQL Server	jtds-1.3.1.jar

2. If you used MySQL, Oracle, or SQL Server for the old product, do the following:

a. Go to the new_Software AG_directory/{Presto|MashZoneNG}/apache-tomcat/webapps/mashzone/WEB-INF/lib directory and delete the jackbe-presto-rds-postgre-derby-10.1.jar file.

b. Go to the new_Software AG_directory/{Presto|MashZoneNG}/prestorepository directory and copy the jackbe-presto-rds-oracle-mysql-mssql-10.1.jar file to the new_Software AG_directory/MashZoneNG/apache-tomcat/webapps/mashzone/WEB-INF/lib directory.

3. Configure the new MashZone NextGen to use the existing repository. For instructions, see MashZone NextGen Administration Guide, and then see the section on getting started with MashZone NextGen, and then see the section on moving the MashZone NextGen repositories to a robust database solution. Skip steps 1 through 4, and start with step 5.

Note:

In MashZone NextGen 10.0 and earlier, repository connection information was defined in the apache-tomee-jaxrs/conf/tomee.xml file. In MashZone NextGen 10.1, repository connection information was moved to the apache-tomcat/conf/context.xml file and the format has changed.

4. Execute database update SQL commands for 10.1. Use a SQL client that is connected to your mashzonenextgenrepository. If you need help, contact Software AG Global Support.

a. Go to the new_SoftwareAG_directory/MashZoneNG/upgrade/10.1 directory and open the appropriate database_type.xml file in a text editor.

b. Read the instructions in the file and modify SQL statements that remove existing constraints as necessary.

c. Execute the SQL statements in the file one by one.

Contact Support | Community | Feedback