Versions Compared

Old Version 9

changes.mady.by.user Gustaf Sjögren

Saved on

compared with

New Version Current

changes.mady.by.user Gustaf Sjögren

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

If you’re upgrading from a version earlier than 4.0.5-2 to a later version you will also need to perform the following two actions:

  • Prior to start tomcat with new version update your database with next script:

    Code Block
    languagesql
    ALTER DATABASE `<scheme_name>` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
ALTER TABLE `schema_version` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `schema_version` CHANGE `description` `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `schema_version` CHANGE `installed_by` `installed_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `schema_version` CHANGE `script` `script` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `schema_version` CHANGE `type` `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `schema_version` CHANGE `version` `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;

  • Modify database connection string by replacing characterEncoding=UTF8 with character_set_server=utf8mb4&connectionCollation=utf8mb4_general_ci in termweb.properties file.

Note

If you’re upgrading from a to version later than 4.0.9 or later you will also need to download and install mysql-connector-j, as outlined under Install TermWeb 4: https://termweb.atlassian.net/wiki/spaces/T4D/pages/581992449/TermWeb+4+install+on+Linux#Install-TermWeb-4.