In HxGN EAM instead of opening one JDBC connection per request a pool of connections is used by JDBC to connect with the database. This helps in managing the connections to the database.
How to increase pool connections?
Search for the file called config.yml in the /app/depconfig/properties/external folder and search for the datasources section. Update the following section to the desired values
min-size:
max-size:
What is the optimum value of this parameter?
The suggested value of this parameter depends on the number of users accessing this application server and the number of JVMs.
-
For 0-100 set the min value to 35 and max value to 100, if you have 1 JVM, 50 if using 2 JVMs.
-
For 100-250 set the min value to 70 and max value to 200. (if using 1 JVM, 100 if using 2 JVMs.