Configuring application server data sources

LiveCycle uses the LiveCycle repository as its data source. The LiveCycle repository stores application assets and, at run time, services can retrieve assets from the repository as part of completing an automated business process.

Access to the data source can be significant, depending on the number of LiveCycle modules you are running and the number of concurrent users accessing the application. Data source access can be optimized using connection pooling. Connection pooling is a technique used to avoid the overhead of making new database connections each time an application or server object requires access to the database. Connection pooling is usually used in web-based and enterprise applications and is usually handled by, but not limited to, an application server.

It is important to properly configure your connection pool parameters so that you never run out of connections, which can cause application performance to deteriorate.

To properly configure connection pool settings, it is important for the application server administrator to monitor the connection pool during peak hours of the day. Monitoring ensures that sufficient connections are available for applications and users at all times. Most application servers include monitoring tools.

You can monitor various statistics for each JDBC data source instance in your domain by using the WebLogic Server Administration Console. See your WebLogic documentation for details.

When the application server administrator determines the correct connection pool settings, that person must communicate this information to the database administrator. The database administrator needs this information because the number of database connections equals the number of connections in the connection pool for the data source. Then, complete the steps to configure the connection pool settings for your application server and data source type as described below.

Configure connection pool settings for WebLogic for Oracle and MySQL

  1. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click IDP_DS.

  2. On the next screen, click the Configuration > Connection Pool tab, and enter a value in the following boxes:

    • Initial Capacity

    • Maximum Capacity

    • Capacity Increment

    • Statement Cache Size

  3. Click Save and then click Activate Changes.

  4. Restart WebLogic managed server.

Configure connection pool settings for WebLogic for SQLServer

  1. Under Change Center, click Lock & Edit.

  2. Under Domain Structure, click Services > JDBC > Data Sources and, in the right pane, click EDC_DS.

  3. On the next screen, click the Configuration > Connection Pool tab, and enter a value in the following boxes:

    • Initial Capacity

    • Maximum Capacity

    • Capacity Increment

    • Statement Cache Size

  4. Click Save and then click Activate Changes.

  5. Restart WebLogic managed server.

Configure connection pool settings for WebSphere for DB2

  1. In the navigation tree, click Resources > JDBC > JDBC Providers. In the right pane, click the data source you created, either DB2 Universal JDBC Driver Provider or LiveCycle - db2 - IDP_DS.

  2. Under Additional Properties, click Data Sources and then select IDP_DS.

  3. On the next screen, under Additional Properties, click Connection Pool Properties and enter a value in the Maximum Connections box and the Minimum Connections box.

  4. Click OK or Apply, and then click Save Directly To Master Configuration.

Configure connection pool settings for WebSphere for Oracle

  1. In the navigation tree, click Resources > JDBC > JDBC Providers. In the right pane, click the Oracle JDBC Driver data source you created.

  2. Under Additional Properties, click Data Sources and then select IDP_DS.

  3. On the next screen, under Additional Properties, click Connection Pool Properties and enter a value in the Maximum Connections box and the Minimum Connections box.

  4. Click OK or Apply, and then click Save Directly To Master Configuration.

Configure connection pool settings for WebSphere for SqlServer

  1. In the navigation tree, click Resources > JDBC > JDBC Providers and, in the right pane, click the User-Defined JDBC Driver data source you created.

  2. Under Additional Properties, click Data Sources and then select IDP_DS.

  3. On the next screen, under Additional Properties, click Connection Pool Properties and enter a value in the Maximum Connections box and the Minimum Connections box:

  4. Click OK or Apply, and then click Save Directly To Master Configuration.

// Ethnio survey code removed