T23-2025 - Foundation: BIOVIA recommends to increase default JDBC poolsize to 100

In some rare cases, users of BIOVIA Foundation might no longer be able to login due to a lack of available JDBC connections.

Program

BIOVIA Foundation Hub

Operating System

All supported operating systems

Background

In some rare cases, users of BIOVIA Foundation might no longer be able to login due to a lack of available JDBC connections.

In the log file of Foundation Hub, the following error can be seen:

Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[size:50; busy:49; idle:0; lastwait:10000].

Workaround

By default, Foundation Hub is configured to use a maximum of 50 JDBC connections.

BIOVIA recommends to increase the maximum number of JDBC connections to 100. This minimizes the risk of using up the connection pools.

To increase the JDBC connection pool, please follow the steps below

  1. Take a backup of the app-config.groovy file (which can be found in Foundation Hub server install directory for example C:\Program Files\BIOVIA\Foundation\apache-tomcat\conf)
  2. Modify app-config.groovy file and add a properties element to the existing datasource element. The number of JDBC connection is defined in the maxActive attribute. Set this to 100 as shown in the example below:

    app-config.groovy example
     
  3. Restart Foundation Hub Service after the config file change
  4. If Foundation Hub is load balanced, please repeat the steps 1-3 for each Foundation Hub server.

How to contact BIOVIA Support

If you have any questions, please contact BIOVIA Support.

Need Assistance?

Our support team is here to help you make the most of our software. Whether you have a question, encounter an issue, or need guidance, we've got your back.