As Databridge runs with high concurrency, the default database connection pool size set by the EAM server installation process may not be sufficient for the typical load for Databridge. We strongly recommend adjusting the default database connection pool size.
-
After completing Databridge installation, on the Databridge server, locate the depconfig folder under the application root.
-
Locate the depconfig\properties\external\config.yml file.
-
Open the config.yml file in a text editor, and look for the data sources section with information similar to the following:
datasources:
tenant: <db-connection name>
url: jdbc:oracle:thin:@SERVER1:PORT1:INSTANCE1
driver: oracle.jdbc.OracleDriver
user: <user>
password: '</password>'
min-size: 40
max-size: 80
idle-timeout-minutes: 1
-
In the data sources section, modify the min and max sizes for the tenant. Set the value for <min-size> to 40, and <max-size> to at least 80. If you have multiple tenants, repeat this for each tenant specific <db-connection> section.
-
Save the file, and then re-deploy EAM application server by running deploy.bat (Windows) or deploy.sh located in the depconfig folder. You must run the deploy command after making sure the EAM server is not started.
-
The depconfig\ewsconfig.xml file will be automatically updated.