Upgrading to Version 11.4

From FMR Knowledge Base
Revision as of 08:34, 3 October 2022 by Vmurrell (talk | contribs) (Change setenv.bat)
Jump to navigation Jump to search

IMPORTANT

If you are using an earlier version of FMR, you will need to make a key change in order to successfully start your Tomcat after installing Version 11.4 or later.

Upgrading from Version 10 or earlier

  1. Folow the Backing Up instructions in this article Upgrading from Version 10 to Version 11.
  2. Next, follow the instructions below.

Preparing to run Version 11.4 or later

FMR supports mySql however the 'jar' file is not included as part of the software distribution so must be obtained and installed seperately prior to starting the application.

Obtain the mySql connector

The file required can be obtained from the MySQL Developer Zone. At the time of writing this article link will take you to the appropriate page.

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

Unzip the files

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

Change setenv.bat

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.

A line need to be added, in the example above it would be this:

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.