Adjusting database connection pool size

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. Infor strongly recommends you adjust the default database connection pool size.

To change the database connection pool size:

  1. After completing Databridge installation, on the Databridge server, locate the depconfig folder under the application root. For example: c:\inforEAM\depconfig.
  2. Open the file ewsconfig.xml, and look for the section similar to the following:

    <ews-config>

    <db-connections>

    <db-connection name="DS_MP_1">

    <url>jdbc:oracle:thin:@gvlddev02.datastream.net:1521:AIXPERF</url>

    <driver>oracle.jdbc.driver.OracleDriver</driver>

    <user>databridge_83</user>

    <password>{ENCR}OazJ++LpZOK/BJ9bbPaUUA==</password>

    <min-size>40</min-size>

    <max-size>80</max-size>

    <idle-timeout-minutes>1</idle-timeout-minutes>

    </db-connection>

    db-connection sections for additional tenants…

  3. 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.
  4. Save the file, and then re-deploy EAM appliction 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.