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
- 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)
- 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:
- Restart Foundation Hub Service after the config file change
- 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.