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 page from the Integration Server Administrator as described in IBM webMethods Integration Server Administrator’s Guide. Important: Be sure the server has access to the Java classes for the driver. For more information about making the Java classes available, see Making the Java Classes for JDBC Drivers Accessible. 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. Note: This field displays only if the server is configured for database connection pooling (that is, if the watt.server.db.connectionCache property in the server.cnf file is set to server). 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. Note: This field displays only if the server is configured for database connection pooling (that is, if the watt.server.db.connectionCache property in the server.cnf file is set to server). 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. Note: This field displays only if the server is configured for database connection pooling (that is, if the watt.server.db.connectionCache property in the server.cnf file is set to server). See
Enabling
Database Connection Pooling for more information. |