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

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

Have you configured the driver as per:
https://techcommunity.softwareag.com/ecosystem/documentation/webmethods/mywebmethods_server/mws10-5/10-5_MWSw/index.html#page/my-webmethods-server-webhelp%2Fta-configuring-mysql-community-edition.html%23wwconnect_header
?
Have a nice day!

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

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.

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

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?

1 Like

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)

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

1 Like