Page Comparison

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)

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.
   screenshotImage Added
   
4. Under the Group Kernel Connection Pool, set the the value for the property, abpm.kernel.connection.pool.profile. Refer to the image below.
   Screenshot.Image Added
5. Save the file.

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