Running Business Processes and Composite Applications 10.5 | 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.

Copyright © 2019 | 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.