Install the MySQL Community Edition Database Driver and Edit the MySQL Configuration File for All Other Products
1. Download the MySQL Community Edition driver to the Software AG_directory \common\lib\ext directory.
2. 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\driver_name
For example:
set CLASSPATH=%CLASSPATH%;%DCI_HOME%\..\lib\ext\mysql-connector-java.jar
3. Open the MySQL configuration file.
a. Remove the values NO_ZERO_IN_DATE and NO_ZERO_DATE from the sql_mode variable.
b. 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.
c. Add the parameter transaction-isolation=READ-COMMITTED.