Administration Console Online Help

Configure a JDBC Connection Pool --> Test Database Connection

Overview

On the Configure a JDBC Connection Pool --> Test Database Connection page, the JDBC Connection Pool Assistant assembles the information you provided in earlier steps into standard connection attributes—attributes typically used to create a database connection. You should do the following:

Review the information displayed to make sure it is correct. You can edit any errors or provide additional properties as necessary. The JDBC Connection Pool Assistant will save your configuration changes when you click the Test Driver Configuration or Skip this Step buttons.

Test the driver configuration or skip the test. When you test the driver configuration, the JDBC Connection Pool Assistant attempts to establish a connection from the administration server to the database using the JDBC driver you selected and using all of the parameters displayed on the page.

Skip this step if the JDBC driver is not installed on the administration server.
If the test fails, you should do one of the following:

Fix any connection property errors on the page and try the test again.
Skip this step to continue creating the configuration. You will need to trouble-shoot the problem again later. The connection problem may not be related to the connection properties.

The Configure a JDBC Connection Pool --> Test Database Connection page includes the following options:

Driver Classname—The full package name of JDBC driver class used to create the physical database connections in the connection pool.

URL—The database URL used to create the connections in this JDBC connection pool. The format and information included in the URL varies greatly between DBMSs and JDBC drivers. For some XA drivers, the URL can be blank. Other JDBC drivers require additional information in the URL, such as the host name and port and the database username and password.

Database User Name—The user name to use to connect to the database. In most cases, the user account must be established on the database server by you database administrator.

Password—The password for the Database User Name to use to connect to the database.

Properties—Additional properties required by the DBMS or JDBC driver, such as an openString for Oracle or an informixServer for Informix.. If you need to enter additional properties, enter each additional property on a separate line as a key=value pair. See the documentation from the JDBC driver vendor for more details.

Tasks

Creating and Configuring a JDBC Connection Pool

Configure a JDBC Connection Pool --> Test Database Connection

Overview

Tasks

Related Topics