Install the MySQL Community Edition Database Driver and Edit the MySQL Configuration File for All Other Products

Edit online

Procedure

  1. Download the MySQL Community Edition driver to the Software AG_directory\common\lib\ext directory.
  2. Rename the MySQL Community Edition driver jar to mysql-connector-java.jar.
  3. Go to the Software AG_directory\common\db\bin directory, open the setEnv.bat file, and add the MySQL Community Edition driver jar to the classpath, as follows: 
    set CLASSPATH=%CLASSPATH%;%DCI_HOME%\..\lib\ext\mysql-connector-java.jar
  4. Open the MySQL configuration file.
    1. Remove the values NO_ZERO_IN_DATE and NO_ZERO_DATE from the sql_mode variable.
    2. If MySQL is on a Linux system, set the parameter lower_case_table_names=1. If MySQL is on an AWS RDS system, set the parameter log_bin_trust_function_creators=1.
    3. Add the parameter transaction-isolation=READ-COMMITTED.