DB connection pool

Owned by Akash Kumar Jaiswal (Unlicensed)
Last updated: Jun 06, 2021 by Avinash KumarVersion comment
2 min read

This page contains the following information:

Configuring the DB Connection Pool for Adeptia Connect

You can configure Adeptia Connect to use any of the following DB connection pools available for Webrunner and Kernel:

  • c3p0
  • HIkari
  • Universal Connectio Pool (UCP)
  • The default DB connection pool is c3P0.
  • UCP supports only the Oracle database.

To set the DB connection pool, you need to configure two system properties in Adeptia Connect. Follow the steps below to configure the properties:

  1. Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder.
  2. Open server-configure.properties file in the Text Editor. 
  3. Under the Group, Webrunner Connection Pool, set the the value for the property, abpm.webrunner.connection.pool.profile. Refer to the image below.

  4. Under the Group Kernel Connection Pool, set the the value for the property, abpm.kernel.connection.pool.profile. Refer to the image below.
  5. Save the file.

You can choose to set any of the following three values.

  1. C3P0ConnectionPool
  2. UniversalConnectionPool
  3. HikariConnectionPool

You can have the same DB connection pool or a different one for the Webrunner and Kernel. 

Log database connection pool

Following property can be configured to control the size of log database connection pool. It is set to 100 but can be increased if log connections are not available. 

To change the connection pool size of log database, open server-configure.properties file from the …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder and change the value highlighted in the figure below: 

 

Backend database connection pool

Following property can be configured to control the size of backend database connection pool. It is set to 50 but can be increased if backend connections are not available.

To change the connection pool size of backend database, open server-configure.properties file from the …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder and change the value highlighted in the figure below: 

The number of objects and processes within the backend database governs the performance of the user interface. Therefore, when the backend database becomes large, you may need to increase the memory setting to this database:

  1. Go to …<ConnectServerInstallFolder>\AdeptiaServer\ServerKernel\etc folder.
  2. Open server-configure.properties file in the Text Editor. 
  3. Increase the value of the property abpm.embedded.indigo.memory as per your requirement.
     #Webrunner JVM parameters WB:JVM: -Xms128M -Xmx512M -Xrs -XX:PermSize=64M -XX:MaxPermSize=128M 
You may be interested in...
What's new
Best practices
Training guides
Frequently asked questions
Adeptia Connect APIs
Adeptia security report