Configuring Trading Networks for MySQL Community Edition 8.0
Before you configure MySQL Community Edition 8.0 with Trading Networks, the required JDBC database drivers should be configured in Integration Server and Database Component Configurator. For more information, see webMethods Integration Server Administrator’s Guide and Installing Software AG Products respectively.
Note:
You can configure Trading Networks for MySQL Community Edition 8.0 using Trading Networks Server 10.1 Fix 1 and above.
Important:
The default value for max_allowed_packet is 4MB for MySQL. If this value is less than the document size, the document insertion into the database fails. To avoid this error, contact your MySQL database administrator to update the value of max_allowed_packet value to the largest possible document size to enable document processing and insertion into the database. The protocol limit for max_allowed_packet is 1GB. The value must be a multiple of 1024; non-multiples are rounded down to the nearest multiple.
To configure
Trading Networks for MySQL Community Edition 8.0
1. Download the JDBC driver for MySQL Community Edition 8.0 and place it in the following directory:
Integration_Server_Installation_directory\common\lib\ext
2. To configure the MySQL Community Edition driver on Windows operating system:
a. Go to the Integration_Server_Installation_directory\packages\WmTN\bin directory, open the setcp.bat file, and add the MySQL Community Edition driver jar to the classpath, as follows:
if exist "%INSTALLDIR%\common\lib\ext\<MySQL Community Edition
driver name>" (
set CLASSPATH=%CLASSPATH%;"%INSTALLDIR%\
common\lib\ext\<MySQL Community Edition driver name>"
)
For example:
if exist "%INSTALLDIR%\common\lib\ext\mysql-connector-
java-8.0.21.jar" (
set CLASSPATH=%CLASSPATH%;"%INSTALLDIR%\common\lib\ext
\mysql-connector-java-8.0.21.jar"
)
b. Go to the Integration_Server_Instance_directory\packages\WmTN\bin directory, open the setcp.bat file, and add the MySQL Community Edition driver jar to the classpath, as follows:
if exist "%INSTALLDIR%\common\lib\ext\<MySQL Community Edition
driver name>" (
set CLASSPATH=%CLASSPATH%;"%INSTALLDIR%\
common\lib\ext\<MySQL Community Edition driver name>"
)
For example:
if exist "%INSTALLDIR%\common\lib\ext\mysql-connector-
java-8.0.21.jar" (
set CLASSPATH=%CLASSPATH%;"%INSTALLDIR%\common\lib\ext
\mysql-connector-java-8.0.21.jar"
)
3. To configure the MySQL Community Edition driver on operating systems not based on Windows:
a. Go to the Integration_Server_Installation_directory\packages\WmTN\bin directory, open the setcp.sh file, and add the MySQL Community Edition driver jar to the classpath, as follows:
if [ -f ${INSTALLDIR}/common/lib/ext/<MySQL Community Edition
driver name> ]; then
CLASSPATH=${CLASSPATH}:${INSTALLDIR}/common/lib/ext/<MySQL
Community Edition driver name>
fi
For example:
if [ -f ${INSTALLDIR}/common/lib/ext/mysql-connector-
java-8.0.21.jar ]; then
CLASSPATH=${CLASSPATH}:${INSTALLDIR}/common/lib/ext/mysql-
connector-java-8.0.21.jar
fi
b. Go to the Integration_Server_Instance_directory\packages\WmTN\bin directory, open the setcp.sh file, and add the MySQL Community Edition driver jar to the classpath, as follows:
if [ -f ${INSTALLDIR}/common/lib/ext/<MySQL Community Edition
driver name> ]; then
CLASSPATH=${CLASSPATH}:${INSTALLDIR}/common/lib/ext/<MySQL
Community Edition driver name>
fi
For example:
if [ -f ${INSTALLDIR}/common/lib/ext/mysql-connector-
java-8.0.21.jar ]; then
CLASSPATH=${CLASSPATH}:${INSTALLDIR}/common/lib/ext/mysql-
connector-java-8.0.21.jar
fi