To Create a JDBC Connection Pool

1. Select the Common Tasks node, then click Resources —> JDBC —> Connection Pool.

   ---

   Note –

   Select New to create a new connection pool from the New Connection Pool page.

   ---

2. Specify the General Settings as follows:

   1. Name: Specify a Name for the pool.

      For example, mysqlpool

   2. Resource Type: Select a Resource Type from the drop-down menu.

      Choices include,

      • javax.sql.XADataSource (global transactions)

      • java.sql.ConnectionPoolDataSource (local transactions, possible performance improvements)

      • javax.sql.DataSource (local transactions only)

   3. Database Vendor: Select a vendor from the list provided in the drop-down menu.

      For example, mySQL

   

3. Click Next.

4. Specify the additional General Settings as follows:

   • Datasource Classname: If the JDBC driver has a Datasource class for the resource type and database vendor specified in the previous page, then the value of the Datasource Classname field is provided.

     For example, MySQL : com.mysql.jdbc.jdbc2.optional.MysqlDataSource

   • Description: A text description of the connection pool.

   

5. Specify the Pool Settings.

   The values are entered, by default.

6. Specify the Connection Validation.

   The values are entered, by default.

7. Specify the Transaction Isolation settings.

   The values are entered, by default.

8. Add the required properties in the Additional Properties table, such as database name (URL), user name, and password. Enter the following.

   1. databaseName

   2. password

   3. portNumber

   4. serverName

   5. user

   

9. Click Finish.