How to Create a JDBC Connection Pool

Steps

1. From the Common Tasks section in the browser interface, click Sun Java System AS 8.

2. Under SJSAS AppServer Resources->SJSAS 8.1 JDBC Resource click Manage JDBC Resources.

3. Under Component Procedures click the Run action next to createJDBCConnectionPool.

4. Select the installation on which you want to create the connection pool.

5. Under Plan Variables:

   1. Set the name of the Connection Pool.

   2. (Optional) Enter a description of the connection pool.

   3. Enter the JDBC data source resource manager for your connection pool.

   4. Enter the interface the data source class implements.

      Valid entries are:

      • DataSource

      • ConnectionPoolDataSource

      • XADataSource

   5. Enter the minimum number of connections created by the pool.

   6. Enter the maximum number of connections maintained by the pool.

   7. Enter the number of connections to be removed when the time out timer expires.

   8. Enter the maximum number of seconds a connection can be idle in the pool.

   9. Enter the transaction isolation level for the connection pool.

      Valid entries are:

      • read-uncommitted

      • read-committed

      • repeatable-read

      • serializable

      If the entry is blank, the default isolation level of the JDBC driver is used.

   10. Specify whether the connections should be validated before being allocated to an application. Valid entries are true or false.

   11. Enter any attribute name/value pairs for the JDBC driver.

6. Click Run Plan (includes preflight).