Skip navigation.

Administration Console Online Help

  Previous Next vertical dots separating previous/next from contents/index/pdf Contents Index

 


Configure a JDBC Connection Pool --> Define and test connection

Tasks     Related Topics

Overview

The Configure a JDBC Connection Pool --> Define and Test Connection page includes the following attributes. See the documentation from your JDBC driver vendor for the correct format for each of these attributes.

Name—Enter a name for the connection pool. This name will be used to identify the connection pool in the configuration file and will be used when creating a data source.

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

URL—Enter 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—Enter 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—Enter the password for the Database User Name to use to connect to the database.

Properties—Enter additional properties required or supported by the DBMS or JDBC driver, such as informixServer for Informix.. Enter each property on a separate line as a key=value pair.

Tasks

Creating and Configuring a JDBC Connection Pool

Related Topics

Connection Pool and Data Source Configuration Guidelines

Configuring JDBC Connection Pools

Overview of Third-Party JDBC Drivers

Creating and Deploying JDBC Components—Connection Pools, MultiPools, and Data Sources

 

Skip navigation bar  Back to Top Previous Next