<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>

<URL>jdbc:wm:mysql://…;DatabaseName=databaseName</URL>

<USER>userName</USER>

<PASSWORD>password</PASSWORD>