webMethods and Intelligent Business Operations 10.2 | Running Business Processes and Composite Applications | Administering My webMethods Server | Changing the My webMethods Server Configuration | Using My webMethods Server with a MySQL Database | Configuring My webMethods Server to Use MySQL Community Edition
 
Configuring My webMethods Server to Use MySQL Community Edition
MySQL Community Edition requires the use of a native driver. Before you can use My webMethods Server with MySQL Community edition, you must download the driver and add it as a bundle in the My webMethods Server installation.
* To configure My webMethods Server for MySQL Community Edition
1. Download the MySQL native driver mysql-connector-java-version-bin.jar from the following location:
https://dev.mysql.com/downloads/connector/j/5.1.html
2. Copy the .jar file to the Software AG_directory \MWS\lib directory.
3. Create a driver-name.bnd text file in the Software AG_directory \MWS\lib directory, where driver-name is the name of the .jar file.
For example, mysql-connector-java-version.bnd.
4. Provide instructions for the OSGi bundle conversion in the .bnd text file, by replacing the values in italics in the following example.

# attach as fragment to the caf.server bundle
Fragment-Host: com.webmethods.caf.server
Bundle-SymbolicName: mysql-connector-java-
Bundle-Version: 5.1.41
Include-Resource: mysql-connector-java-5.1.41.jar
-exportcontents: *
Bundle-ClassPath: mysql-connector-java-5.1.41.jar
Import-Package: *;resolution:=optional
For Bundle-Version, specify the version number of the .jar file, or any unique number.
5. At a command line prompt, move to the bin directory of server:
Software AG_directory\MWS\bin
6. Update the server instance using the following command:
mws.bat -s serverName update
7. Start My webMethods Server.
Important: Deploying .war files to My webMethods Server might fail after completing the procedure. If such an issue occurs, increase the following parameters in the MySQL configuration file, and then restart the MySQL database server.

innodb_buffer_pool_size = 5G
innodb_log_file_size = 80M
max_allowed_packet = 24M

Copyright © 2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release