Installer 10.7 | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products On Premises | Preparing for Database Component Creation | Prepare for Database Component Creation in MySQL | Install the MySQL Community Edition Database Driver and Edit the MySQL Configuration File for All Other Products
 
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.