Configuring a Connection Pool through the Admin UI

To configure a connection pool to work with a new JDBC driver:

  1. Open the Dynamo Administration UI (http://hostname:port/dyn/admin) and click on the Configuration Manager link.

  2. Click on the name of the server you want to configure. The configuration page for that server opens.

  3. In the Configure JDBC Connection Pools section, click on Connection Pools.

  4. On the Configure or Delete JDBC Connection Pools page, click on the name of the connection pool you want to configure (the default name is JTDataSource).

  5. On the Choose Type of JDBC Connection Pool page, select your JDBC driver. The configuration page for the connection pool opens.

  6. In the Choose JDBC Driver and Database Vendor section, select a preconfigured JDBC driver from the drop-down list.

    If your JDBC driver/database combination does not appear in the list, you can enter the URL and driver name manually. Refer to your driver documentation to find the appropriate values. Remember that this information is case-sensitive.

  7. In the Database and Server section, enter the server name and database name that correspond with your JDBC driver:

    JDBC Driver

    Database Name

    Server Name

    SOLID Embedded Engine

    Optional

    server:port

    Oracle Thin

    Oracle SID

    server:port

    Oracle OCI

    TNSNAME database alias

    Server

    IBM DB2 UDB

    Optional

    server:port

  8. In the Database Login section, enter a user name and password combination that will give the connection pool access to the target database.

    Warning: Specifying a password does not ensure security; the password appears as plain text in the FakeXADataSource.properties file in <ATG2006.5dir>/home/localconfig/atg/dynamo/service/jdbc/.

  9. You can choose to log database warnings, log all database operations and to make the connection read-only. Some drivers may see improved performance if the connection is read-only, but this property is usually set to false because most applications require read and write access.

    From the three checkboxes toward the bottom of the page, select the desired options for the way connections will be monitored:

    All connections are monitored by the data source. If an error occurs with a connection, the data source invalidates the connection so that the connection can’t be reused and the error won’t persist across connection checkouts.

  10. In the Number of Connections section, set the number of connections you want kept in the pool.

    When the pool starts, it creates the minimum number of connections. When a service requires a connection, it takes one from the pool. If there are no free connections, then the connection pool creates a new connection until the maximum is reached.

    If the maximum is reached and a service requires another connection, the service will block until another service frees a connection. If the blocking property is set to false, then instead of blocking, the ConnectionPool service will fail and return null.

  11. Click on the Apply Changes button at the bottom of the page.

  12. Stop the Dynamo server and then restart it. Note: You must stop Dynamo before restarting it. If you restart Dynamo without stopping it first, Dynamo does not start a new Java instance and will not pick up on the new configuration settings.

 
loading table of contents...