IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  ADD Mysql Driver to MWS

    Posted Wed November 28, 2018 05:20 AM

    *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


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 2.  RE: ADD Mysql Driver to MWS

    Posted Wed November 28, 2018 07:33 AM

    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.


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: ADD Mysql Driver to MWS

    Posted Wed November 28, 2018 07:37 AM

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


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 4.  RE: ADD Mysql Driver to MWS

    Posted Wed November 28, 2018 08:08 AM

    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


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: ADD Mysql Driver to MWS

    Posted Wed November 28, 2018 09:11 AM

    Hi Elyas,

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

    Regards,
    Holger


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: ADD Mysql Driver to MWS

    Posted Wed November 28, 2018 11:54 PM

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


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 7.  RE: ADD Mysql Driver to MWS

    Posted Thu November 29, 2018 06:39 AM

    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
    #webMethods-General
    #Integration-Server-and-ESB


  • 8.  RE: ADD Mysql Driver to MWS

    Posted Thu November 29, 2018 06:45 AM

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


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods