The Java Database Connectivity (JDBC) settings for a Document Store are modified on the JDBC Settings page. Blackboard uses "pooled" connections to access the database. Each Web request served by the application server requires at least one database connection. If there are more requests than available connections, the requests are blocked until a database connection is available for it to continue processing. Additional memory resources are required by the database for each connection; however, allocating more connections to the pool than required may degrade performance.
Follow these steps to open the JDBC Settings page.
Step 1 Open the Blackboard Learning System Administrator Control Panel.
Step 2 Select Technical Settings under Content System. The Technical Settings page will appear.
Step 3 Click Document Stores. The Manage Document Store page will open.
Step 4 Select Manage next to one of the Document Stores.
Step 5 Select JDBC Settings.
The following fields are available on the JDBC Settings page.
|
Field |
Description |
|
JDBC Settings |
|
|
Connection Expiration: |
Enter the number of minutes a database connection will remain open before the system automatically closes it. |
|
Max Connections: |
Enter the maximum number of connections that can exist in the connection pool. If this number is too high, performance may decrease. |
|
Min Connections: |
Enter a minimum for the size of the database connection pool. |