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
Expand all | Collapse all

Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

  • 1.  Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 02:13 AM

    I am using webMethods 10.5 version and I am not able to start the MWS.I have configured mysql community edition server when specifiying the database for MWS.The mws.db file in mws/server looks like this.

    <?xml version="1.0" encoding="UTF-8"?>
    <CONNECTION default="true" displayname="Default" id="1" name="default" type="mysql">
    <SQLWORKERCLASS>com.webmethods.portal.service.sql.core.BaseSqlWorker</SQLWORKERCLASS>
    <CONNPROVIDERCLASS>com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider</CONNPROVIDERCLASS>
    <PARAMS>
    <DRIVER>com.mysql.jdbc.Driver</DRIVER>
    <URL>jdbc:wm:mysql//localhost:3306/WebMethods</URL>
    <USER>User</USER>
    <!-- Password could be specified in clear text, it will be automatically encrypted during MWS startup -->
    <PASSWORD>Password</PASSWORD> 
    <CACHESTATEMENTS>false</CACHESTATEMENTS>
    <TESTSQL>SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1</TESTSQL>            
    <MAXCONNECTIONS>100</MAXCONNECTIONS>
    <MINCONNECTIONS>0</MINCONNECTIONS>
    <!-- Max amount of idle time (in seconds) of the objects pooled by this pool -->
    <IDLETIMEOUT>60</IDLETIMEOUT>
    <!-- Time (in seconds) between eviction runs -->
    <CLEANUPPERIOD>10</CLEANUPPERIOD>
    </PARAMS>
    </CONNECTION>
    

    Is it the problem of driver or configuration file.Do I need to do any extra configurations?Please help me I am stuck with this configuration for quite a while now


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232



  • 3.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 03:29 AM

    I have changed as per the documentation you shared but still getting the same error.And also what would be the default mws serverName?


    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 03:48 AM

    check if the driver jar file is present in the following file:
    sag-root/profiles/MWS_instancename/configuration/org.eclipse.equinox.simpleconfigurator/bundles.info
    if it is not there there is something wrong with the configuration of the driver.

    The default MWS instance name is: default.


    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 04:04 AM

    Yes it is present in that file.
    com.mysql.jdbc,5.1.49,…/…/common/runtime/bundles/mws-lib/eclipse/plugins/com.mysql.jdbc_5.1.49.jar,4,true


    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 04:26 AM

    I also see you are using:
    jdbc:wm:mysql// in the URL however you are using the native driver, can you change it to: jdbc:mysql?


    #Integration-Server-and-ESB
    #webMethods


  • 7.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 05:07 AM

    Can you analayze the build,mws.db and log file.I am attching here.Still getting the same errordeploy.xml (80.2 KB) mws.db.xml (1.2 KB) bundles.txt (70.4 KB) deploy.xml (80.2 KB) mws.db.xml (1.2 KB)


    #webMethods
    #Integration-Server-and-ESB


  • 8.  RE: Cannot load database driver: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver cannot be found by com.webmethods.caf.server_10.5.0.0000-0232

    Posted Thu July 16, 2020 05:34 AM

    you are now missing a : in your URL:
    jdbc:mysql://localhost:3306/webMethods


    #webMethods
    #Integration-Server-and-ESB