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.