Note: | Before you configure a database alias, make sure the WmDB package is enabled. For information about enabling packages, see webMethods Integration Server Administrator’s Guide. |
For this parameter... | Specify... | ||
Alias | The alias name that you want to use for the database. You can specify any combination of letters, numbers, and the underscore character for an alias name; there is no restriction on the number or of characters you can specify. | ||
DB URL | The URL for the database. For example: jdbc:odbc:Support. | ||
DB Username | The user name that the server must supply to log on to the specified database. If a user name and password are not required, leave this field blank. | ||
DB Password | The password that the server must supply to log on to the selected database. If a user name and password are not required, leave this field blank. | ||
DB Driver | The name of the Java class for the JDBC driver. If the server has any drivers currently loaded, the server displays a Loaded Drivers field that has a drop down list containing the drivers that are loaded. If you select a driver from the list, the server places the driver name in the DB Driver field. If you do not specify a driver, the server uses the default driver specified in the watt.server.jdbc.defaultDriver parameter in the server.cnf file. To see the value of the default driver, use the Settings>Extended screen from the Integration Server Administrator as described in webMethods Integration Server Administrator’s Guide.
If you are using the Oracle JRE on a Windows platform, the server has access to the Java classes for the JDBC-ODBC bridge driver named sun.jdbc.odbc.JdbcOdbcDriver. | ||
Minimum Connections | The minimum number of connections to maintain in the database connection pool. The server creates these connections when it first receives a request to connect to the database. If more connections are needed, the server creates additional connections until the value for Maximum Connections, described below, is reached. The default is 0.
See
Enabling Database Connection Pooling for more information. | ||
Maximum Connections | The maximum number of connections to maintain in the database connection pool. When the number of connection requests reaches this value, the server blocks the requests. The default is 1.
See
Enabling Database Connection Pooling for more information. | ||
Expiration Time (ms) | The amount of time the server waits before discarding an inactive connection from the database connection pool. The server only discards connections if the pool contains more than the minimum number of connections. Afterwards, if more connections are needed than exist in the pool, the server creates new ones. The default expiration time is 60000 milliseconds.
See
Enabling Database Connection Pooling for more information. |