ADD Mysql Driver to MWS

*I have installed MWS successfully but my MWS instance can not start because MWS can not find the mysql driver
*I switch the database to oracle and it seemd to connect seccessfully but can not start also because it can not find the tables there (I DONT KNOW WHY IT DID NOT CREATE THEM AT INSTALLATION TIME)

It is really making me sick been trying for 5 days still no success

Hi,
Can you try the following steps:
a. Download and place mysql-java-connector.jar in the following directory:

<Software AG_directory>\MWS\lib

b. Create a < mysql-connector-name>.bnd text file in

<Software AG_directory>\MWS\lib directory,

Example:

mysql-connector-java-version.bnd

c. Provide instructions for the OSGi bundle conversion in the .bnd text file

attach as fragment to the caf.server bundle

Fragment-Host: com.webmethods.caf.server

Bundle-SymbolicName: mysql-connector-java-

Bundle-Version: < mysql-connector-version >

Include-Resource: < mysql-connector-jar >

-exportcontents: *

Bundle-ClassPath: < mysql-connector-jar >

Import-Package: *;resolution:=optional

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

d. Run following command at

\MWS\bin

mws.bat -s < serverInstanceName > update

Example:

mws.bat –s default update

Please check if this helps.

Also you need to run the Database Configurator to create the tables after installation.

1 Like

the error is the same; wouln’it be easy just make mws like this:
throw you jar somewhre and it works; since what i am doing is the ABC of an installation of a software; if a user faces this complexity at the begining he will be very carfull in taking the choice of puting time and effort in the software if you know what i mean

Hi Elyas,

which version of wM are you trying install?
Is MySQL database officially supported for this version?

Regards,
Holger

MySQL official support for MWS is from 10.1 onwards. Below that it is not officially supported.

the mysql version i am using is 8.0.13 which is the latest version there is (to day is 29/11/2018 for people who will see this post in the future) and the webmethods i downloaded is the latest version also 10.3

Webmethods 10.3 is officially supported on MySQL version 5.7 (both Community and Enterprise Edition).