Configure a JDBC Connection Pool --> Define and test connection
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 by the DBMS or JDBC driver, such as an openString for Oracle or an 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
|
|
|