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

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

2

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!

3

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

4

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.

5

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

6

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
7

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)

8

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

1 Like