Difference between revisions of "Upgrading to Version 11.4"

From FMR Knowledge Base
Jump to navigation Jump to search
(Obtaining the MySql Connector Dependency)
(Adding the MySQL Connector Dependency)
Line 12: Line 12:
 
# Obtain the correct dependency file
 
# Obtain the correct dependency file
 
# Supply this to your Java Web Server (e.g. Tomcat) that you are using to run the Registry.
 
# Supply this to your Java Web Server (e.g. Tomcat) that you are using to run the Registry.
 
  
 
==Obtaining the MySql Connector Dependency==
 
==Obtaining the MySql Connector Dependency==
Line 47: Line 46:
 
[[File:Jar file location.PNG|600px]]<br>
 
[[File:Jar file location.PNG|600px]]<br>
  
==Change setenv.bat==
+
==Supplying the JAR file to your Java Web Server==
Lastly, you need to edit the setenv.bat file so that the Tomcat 'knows' the location of the MySQL jar file.
 
  
Setenv.bat is located in the Tomcat's bin folder and it can easily be edited using Notepad.
+
===Change setenv.bat===
 +
setenv.bat (or setenv.sh for UNIX) is located in the Tomcat's bin folder.  If it doesn't exist simply create it.
  
A line need to be added, in the example above it would be this:
+
In this file, add the location of the mysql-connector jar file to the CLASSPATH.  This can be achieved by use of the following line (which uses a location from the example above):
  
 
  set CLASSPATH=C:\SQL_Connector\mysql-connector-java-8.0.30\mysql-connector-java-8.0.30.jar
 
  set CLASSPATH=C:\SQL_Connector\mysql-connector-java-8.0.30\mysql-connector-java-8.0.30.jar
 +
 +
  
 
To the command set CLASSPATH =, the location of the jar file AND the name of the file is included.
 
To the command set CLASSPATH =, the location of the jar file AND the name of the file is included.
  
 
You can now start the Tomcat and once started, can use FMR.
 
You can now start the Tomcat and once started, can use FMR.

Revision as of 05:28, 10 October 2022

Important Information for Registries using MySQL Database

From version 11.4.0 onwards, the Fusion Metadata Registry will no longer ship with a MySQL connector (due to licensing issues). FMR can still be used with a MySQL database, but you will need to manually supply the MySQL dependency JAR file. If you were using MySQL with an earlier version of FMR, then you will need to make this change in order to successfully start your Tomcat after installing Version 11.4 or later.

Upgrading from Version 10 or earlier

  1. Follow the Backing Up instructions in this article Upgrading from Version 10 to Version 11.
  2. Follow the instructions below.

Adding the MySQL Connector Dependency

To get FMR version 11.4.0 or later, to communicate succesfully with a MySQL database, there are two tasks to perform:

  1. Obtain the correct dependency file
  2. Supply this to your Java Web Server (e.g. Tomcat) that you are using to run the Registry.

Obtaining the MySql Connector Dependency

To enable FMR and a MySQL database to communicate the depdendency MySQL Connector/J version 8.0.29 (or higher) is required. This is a Jar file of approximately 2.5 Mb in size and called: mysql-connector-java-8.0.29.jar

This jar can be obtained from the MySQL Web site. At the time of writing this article this link will take you to the appropriate page or alternatively you can obtain it from Maven Central.

Obtaining the Jar file from the MySQL website

From the dropdown list, select 'Platform Independent' as shown in the image below and then select which type of compressed file you would like to downlaod.

These instructions are based on downloading the Zip file.

Download Connector

If you are prompted as shown below, there is no need to Login or Sign Up, simply click on 'No thanks' to download the relevant files.

Download Connector Confirm.PNG


Once the zip file has been downloaded you need to unzip it in the usual way to a folder which will always be available to the application.


Extracting the files:

Extract SQL Connector.PNG

In this example, I have downloaded the files to a sub folder on my C drive as shown below.

SQL Connector Target.PNG

Make a note of the full location path (including the file name) for the 'jar' file, in this example: 'C:\SQL_Connector\mysql-connector-java-8.0.30\mysql-connector-java-8.0.30.jar'.

Jar file location.PNG

Supplying the JAR file to your Java Web Server

Change setenv.bat

setenv.bat (or setenv.sh for UNIX) is located in the Tomcat's bin folder. If it doesn't exist simply create it.

In this file, add the location of the mysql-connector jar file to the CLASSPATH. This can be achieved by use of the following line (which uses a location from the example above):

set CLASSPATH=C:\SQL_Connector\mysql-connector-java-8.0.30\mysql-connector-java-8.0.30.jar


To the command set CLASSPATH =, the location of the jar file AND the name of the file is included.

You can now start the Tomcat and once started, can use FMR.