Dynamic Apps Platform : Administering My webMethods Server : Changing the My webMethods Server Configuration : Configuring My webMethods Server to Use MySQL : Configuring My webMethods Server to Use MySQL Enterprise Edition
Configuring My webMethods Server to Use MySQL Enterprise Edition
You do not need to configure the MySQL native driver when you use MySQL Enterprise Edition.
To configure My webMethods Server for MySQL Enterprise Edition
1. Go to Software AG_directory \MWS\server\default\config and open the mws.db.xml file in a text editor.
Following is a sample mws.db.xml file.

<CONFIG>
<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.wm.dd.jdbc.mysql.MySQLDriver</DRIVER>
<URL>jdbc:wm:mysql://localhost:3306;DatabaseName=<databasename></URL>
<USER><username></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>
</CONFIG>
2. Specify values for the following tags in the file to access MySQL Enterprise Edition:
a. Type your database name inside the <URL></URL> tags.
<URL>jdbc:wm:mysql://…;DatabaseName=databaseName</URL>
b. Type your user name inside the <USER></USER> tags.
<USER>userName</USER>
c. Type your password inside the <PASSWORD></PASSWORD> tags.
<PASSWORD>password</PASSWORD>
3. Save the file.
4. Add the following properties to your MySQL configuration file, which is My.ini on Windows and My.cnf on Linux.

sql-mode="PIPES_AS_CONCAT"
sql-mode="ANSI_QUOTES"
5. Save the file and restart your MySQL database server.
6. Start My webMethods Server.
Copyright © 2017 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback